[pgAdmin][RM7333] ERD Tool: drag table throws Uncaught TypeError

[Aditya Toshniwal]

Hi Hackers,

Attached patch fixes the error when drag and drop table in ERD.
Please review.

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"


RM7333.patch
Description: Binary data

pgAdmin 4 commit: Fixed an issue where the drag and drop table in ERD t

[Akshay Joshi]

Fixed an issue where the drag and drop table in ERD throws an error. Fixes #7333

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=3d1a9624c197465fd0c13fc1b46c243e9b6c4cef
Author: Aditya Toshniwal 

Modified Files
--
docs/en_US/release_notes_6_9.rst  | 1 +
web/pgadmin/tools/erd/static/js/erd_tool/nodes/TableNode.jsx  | 2 +-
.../tools/erd/static/js/erd_tool/ui_components/BodyWidget.jsx | 8 
3 files changed, 6 insertions(+), 5 deletions(-)

pgAdmin 4 commit: Updated documentation for the new query tool.

[Akshay Joshi]

Updated documentation for the new query tool.

refs #6131

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4f9eaf850da85965513356eb96a98bf0577d16f0

Modified Files
--
docs/en_US/editgrid.rst|   5 +-
docs/en_US/images/editgrid.png | Bin 147923 -> 227923 bytes
docs/en_US/images/editgrid_filter_dialog.png   | Bin 52493 -> 54570 bytes
docs/en_US/images/geometry_viewer.png  | Bin 1310723 -> 453405 bytes
.../images/geometry_viewer_property_table.png  | Bin 1725131 -> 517251 bytes
docs/en_US/images/new_connection_dialog.png| Bin 49691 -> 0 bytes
docs/en_US/images/new_connection_options.png   | Bin 45739 -> 0 bytes
docs/en_US/images/query_autocomplete.png   | Bin 64852 -> 80479 bytes
docs/en_US/images/query_data_editing.png   | Bin 0 -> 23116 bytes
docs/en_US/images/query_editing.png| Bin 0 -> 40729 bytes
docs/en_US/images/query_execute_section.png| Bin 106471 -> 105766 bytes
docs/en_US/images/query_execution.png  | Bin 0 -> 16695 bytes
.../images/query_explain_analyze_statistics.png| Bin 243889 -> 136732 bytes
docs/en_US/images/query_explain_analyze_table.png  | Bin 230047 -> 224878 bytes
docs/en_US/images/query_output_data.png| Bin 106471 -> 199407 bytes
docs/en_US/images/query_output_error.png   | Bin 86974 -> 97641 bytes
docs/en_US/images/query_output_explain.png | Bin 86037 -> 0 bytes
docs/en_US/images/query_output_explain_details.png | Bin 213690 -> 106242 bytes
docs/en_US/images/query_output_explain_options.png | Bin 50441 -> 0 bytes
docs/en_US/images/query_output_history.png | Bin 168568 -> 110114 bytes
docs/en_US/images/query_output_messages.png| Bin 77489 -> 78228 bytes
.../images/query_output_notifications_listen.png   | Bin 83608 -> 58767 bytes
.../images/query_output_notifications_notify.png   | Bin 80625 -> 69601 bytes
.../images/query_output_notifications_panel.png| Bin 99605 -> 77524 bytes
docs/en_US/images/query_sql_editor.png | Bin 56223 -> 38470 bytes
docs/en_US/images/query_status_bar.png | Bin 0 -> 37293 bytes
docs/en_US/images/query_tool.png   | Bin 161291 -> 163388 bytes
docs/en_US/images/query_tool_connection_status.png | Bin 88290 -> 200018 bytes
docs/en_US/images/query_tool_editable_columns.png  | Bin 166937 -> 163303 bytes
docs/en_US/images/query_tool_macros_clear_all.png  | Bin 128381 -> 0 bytes
.../query_tool_macros_clear_confirmation.png   | Bin 129827 -> 107440 bytes
docs/en_US/images/query_tool_macros_clear_row.png  | Bin 98550 -> 0 bytes
docs/en_US/images/query_tool_macros_execution.png  | Bin 97558 -> 121386 bytes
docs/en_US/images/query_tool_manage_macros.png | Bin 53042 -> 61833 bytes
.../images/query_tool_manage_macros_dialog.png | Bin 108198 -> 91800 bytes
docs/en_US/images/query_tool_message.png   | Bin 75236 -> 67824 bytes
.../images/query_tool_new_connection_dialog.png| Bin 0 -> 88211 bytes
.../images/query_tool_new_connection_options.png   | Bin 0 -> 54623 bytes
docs/en_US/images/query_toolbar.png| Bin 27844 -> 41915 bytes
docs/en_US/images/query_toolbar_explain.png| Bin 195038 -> 151401 bytes
docs/en_US/query_tool.rst  |  31 ++--
docs/en_US/query_tool_toolbar.rst  | 170 -
.../static/js/components/sections/MainToolBar.jsx  |   8 +-
43 files changed, 114 insertions(+), 100 deletions(-)

pgAdmin 4 commit: Fixed the following issues for the new query tool:

[Akshay Joshi]

Fixed the following issues for the new query tool:
 1) In Dark mode > Replace/Find dialogue forward & reverse buttons are stuck to 
each other.
 2) In Dark/High contrast mode > Checkbox is not visible for false value.
 3) Wrap toolbar when size goes very small.
 4) Replace functionality does not work when tried in sequence 2 times. 
Codemirror search is not cyclic. So, changes are made to always search from the 
start.
 5) Replace all does not work when tried in sequence 2 times. Same reason as 
above.
 6) Fix broken macros $SELECTION$ feature.
 7) Make query history SQL readonly.
 8) The Filter dialog save button should be disabled when opened.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=0795b22ae6fd63a6d5bd130497d3f8eebf27b5f7
Author: Aditya Toshniwal 

Modified Files
--
web/pgadmin/static/js/components/CodeMirror.jsx| 13 +
.../static/js/components/QueryToolComponent.jsx| 18 +++---
.../static/js/components/QueryToolDataGrid/Editors.jsx |  2 +-
.../static/js/components/dialogs/FilterDialog.jsx  |  2 +-
.../static/js/components/sections/MainToolBar.jsx  |  3 ++-
.../sqleditor/static/js/components/sections/Query.jsx  | 17 +
6 files changed, 37 insertions(+), 18 deletions(-)

Re: [pgAdmin][RM7333] ERD Tool: drag table throws Uncaught TypeError

[Akshay Joshi]

Thanks, the patch applied.

On Tue, Apr 26, 2022 at 4:03 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached patch fixes the error when drag and drop table in ERD.
> Please review.
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

pgAdmin 4 commit: Added capability to deploy PostgreSQL servers on EDB

[Akshay Joshi]

Added capability to deploy PostgreSQL servers on EDB BigAnimal. Fixes #7179

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=5677b1e5f80520aae7f45e1fe3b27c83d2d2dc59
Author: Khushboo Vashi 

Modified Files
--
docs/en_US/cloud_aws_rds.rst   |  93 
docs/en_US/cloud_deployment.rst|  93 +---
docs/en_US/cloud_edb_biganimal.rst |  91 
...t_credentials.png => cloud_aws_credentials.png} | Bin
...loyment_database.png => cloud_aws_database.png} | Bin
...loyment_instance.png => cloud_aws_instance.png} | Bin
docs/en_US/images/cloud_aws_provider.png   | Bin 0 -> 68743 bytes
..._deployment_review.png => cloud_aws_review.png} | Bin
docs/en_US/images/cloud_biganimal_credentials.png  | Bin 0 -> 87046 bytes
docs/en_US/images/cloud_biganimal_database.png | Bin 0 -> 75803 bytes
docs/en_US/images/cloud_biganimal_instance.png | Bin 0 -> 150517 bytes
docs/en_US/images/cloud_biganimal_provider.png | Bin 0 -> 70440 bytes
docs/en_US/images/cloud_biganimal_review.png   | Bin 0 -> 146258 bytes
docs/en_US/images/cloud_deployment_provider.png| Bin 75351 -> 0 bytes
docs/en_US/release_notes_6_9.rst   |   1 +
web/pgacloud/pgacloud.py   |   2 -
web/pgacloud/providers/biganimal.py| 181 
web/pgacloud/providers/rds.py  |  29 +-
web/pgacloud/utils/io.py   |  13 +-
web/pgadmin/misc/bgprocess/process_executor.py |   3 +-
web/pgadmin/misc/cloud/__init__.py | 235 ++
web/pgadmin/misc/cloud/biganimal/__init__.py   | 432 ++
web/pgadmin/misc/cloud/rds/__init__.py | 330 ++
.../cloud/{utils/aws_regions.py => rds/regions.py} |   0
web/pgadmin/misc/cloud/static/js/CloudWizard.jsx   | 496 -
web/pgadmin/misc/cloud/static/js/aws.js| 243 ++
web/pgadmin/misc/cloud/static/js/biganimal.js  | 206 +
.../misc/cloud/static/js/cloud_components.jsx  | 106 +
.../cloud/static/js/cloud_db_details_schema.ui.js  | 459 ---
web/pgadmin/misc/cloud/utils/__init__.py   |  61 ++-
web/pgadmin/misc/cloud/utils/rds.py| 175 
web/pgadmin/static/img/aws.svg |   1 +
web/pgadmin/static/js/components/ExternalIcon.jsx  |   4 +
.../static/js/components/FormComponents.jsx|   3 +-
web/pgadmin/utils/constants.py |   2 +-
web/yarn.lock  |  10 +-
36 files changed, 2399 insertions(+), 870 deletions(-)

[pgAdmin4][Patch] - Server Disconnect Issue

[Khushboo Vashi]

Hi,

Please find the attached patch to fix the Server Disconnect Issue.

Steps to reproduce the issue:

Connect the server -> Refresh the page -> Disconnect the server.
Password popup will appear on disconnection.

Thanks,
Khushboo


server_disconnect_issue.patch
Description: Binary data

[pgAdmin4][Patch] - Linter Fixes

[Khushboo Vashi]

Hi,

Please find the attached patch to fix the linter issue.

Thanks,
Khushboo


linter_fixes.patch
Description: Binary data

pgAdmin 4 commit: 1) Fixed linter error.

[Akshay Joshi]

1) Fixed linter error.
2) Fixed an issue where a password popup will appear on disconnecting from the 
server.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7d91cca14deeb3fc81006939e325827f600c9b8e
Author: Khushboo Vashi 

Modified Files
--
web/package.json   |  2 +-
.../browser/server_groups/servers/static/js/server.js  |  2 +-
web/pgadmin/misc/cloud/static/js/cloud_components.jsx  |  2 +-
.../misc/cloud/static/js/cloud_db_details_schema.ui.js | 14 +++---
web/pgadmin/static/js/tree/tree.js |  2 +-
web/yarn.lock  |  4 ++--
6 files changed, 13 insertions(+), 13 deletions(-)

pgAdmin 4 commit: Fixed ERDInitialize API test case.

[Akshay Joshi]

Fixed ERDInitialize API test case.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=1bee39a67ee30fad18300b5f1ad2e828f39596d3

Modified Files
--
web/pgadmin/tools/erd/tests/test_initialize.py | 1 +
1 file changed, 1 insertion(+)

Re: [pgAdmin4][Patch] - Server Disconnect Issue

[Akshay Joshi]

Thanks, the patch applied

On Tue, Apr 26, 2022 at 4:59 PM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the Server Disconnect Issue.
>
> Steps to reproduce the issue:
>
> Connect the server -> Refresh the page -> Disconnect the server.
> Password popup will appear on disconnection.
>
> Thanks,
> Khushboo
>
>
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

Re: [pgAdmin4][Patch] - Linter Fixes

[Akshay Joshi]

Thanks, the patch applied.

On Tue, Apr 26, 2022 at 5:33 PM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the linter issue.
>
> Thanks,
> Khushboo
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

pgAdmin 4 commit: Fixed audit issues.

[Akshay Joshi]

Fixed audit issues.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=f725cc2307775ffb6b5d85b7c728db53d639fa54

Modified Files
--
web/package.json |  6 +++---
web/yarn.lock| 40 +---
2 files changed, 24 insertions(+), 22 deletions(-)

[pgAdmin4][Patch] - BigAnimal Fixes

[Khushboo Vashi]

Hi,

While deploying the PostgreSQL on the BigAnimal cloud, the Public IP
addresses were not added, fixed this issue in the attached patch.

Thanks,
Khushboo


cloud_public_ip_fixe.patch
Description: Binary data