pgAdmin 4 commit: Improve logic to get the DDL statements as a part of - Mailing list pgadmin-hackers
| From | Akshay Joshi |
|---|---|
| Subject | pgAdmin 4 commit: Improve logic to get the DDL statements as a part of |
| Date | |
| Msg-id | E1jDPTi-0001Vh-8x@gothos.postgresql.org Whole thread Raw |
| List | pgadmin-hackers |
Improve logic to get the DDL statements as a part of the comparison. Fixes #5221 Fixed 23 issues related to schema diff. Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=44c0d765415731172b9bfdc8f93c6854d2153b91 Modified Files -------------- docs/en_US/release_notes_4_20.rst | 3 +- .../databases/schemas/functions/__init__.py | 23 +- .../functions/gpdb/sql/default/update.sql | 3 +- .../templates/functions/pg/sql/11_plus/update.sql | 5 +- .../templates/functions/pg/sql/12_plus/update.sql | 5 +- .../templates/functions/pg/sql/9.2_plus/update.sql | 5 +- .../templates/functions/pg/sql/9.5_plus/update.sql | 5 +- .../templates/functions/pg/sql/9.6_plus/update.sql | 5 +- .../templates/functions/pg/sql/default/update.sql | 5 +- .../functions/ppas/sql/12_plus/update.sql | 5 +- .../functions/ppas/sql/9.2_plus/update.sql | 5 +- .../functions/ppas/sql/9.5_plus/update.sql | 5 +- .../functions/ppas/sql/9.6_plus/update.sql | 5 +- .../functions/ppas/sql/default/update.sql | 5 +- .../servers/databases/schemas/tables/__init__.py | 51 +-- .../schemas/tables/compound_triggers/__init__.py | 59 ++- .../tables/constraints/foreign_key/utils.py | 4 +- .../databases/schemas/tables/indexes/__init__.py | 101 ++-- .../schemas/tables/partitions/__init__.py | 171 +++---- .../databases/schemas/tables/rules/__init__.py | 74 ++- .../databases/schemas/tables/schema_diff_utils.py | 506 +++++++-------------- .../templates/columns/sql/10_plus/update.sql | 4 +- .../templates/columns/sql/9.2_plus/update.sql | 9 +- .../templates/columns/sql/default/update.sql | 2 +- .../partitions/sql/pg/10_plus/partition_diff.sql | 22 + .../partitions/sql/pg/11_plus/partition_diff.sql | 24 + .../partitions/sql/ppas/10_plus/partition_diff.sql | 22 + .../partitions/sql/ppas/11_plus/partition_diff.sql | 24 + .../templates/tables/sql/10_plus/schema_diff.sql | 14 - .../tables/templates/tables/sql/12_plus/update.sql | 2 +- .../tables/templates/tables/sql/default/update.sql | 2 +- .../templates/triggers/sql/pg/default/update.sql | 26 +- .../templates/triggers/sql/ppas/default/update.sql | 27 +- .../databases/schemas/tables/triggers/__init__.py | 60 ++- .../databases/schemas/tables/triggers/utils.py | 35 +- .../servers/databases/schemas/tables/utils.py | 14 +- .../templates/mviews/pg/9.4_plus/sql/update.sql | 4 +- .../templates/mviews/ppas/9.3_plus/sql/update.sql | 11 +- .../templates/views/pg/9.4_plus/sql/update.sql | 2 + .../templates/views/ppas/9.4_plus/sql/update.sql | 2 + .../pg/9.4_plus/alter_view_add_some_priv_msql.sql | 4 + .../tests/pg/9.4_plus/alter_view_definition.sql | 5 +- .../pg/9.4_plus/alter_view_definition_msql.sql | 1 - .../9.4_plus/alter_view_add_some_priv_msql.sql | 4 + .../tests/ppas/9.4_plus/alter_view_definition.sql | 5 +- .../ppas/9.4_plus/alter_view_definition_msql.sql | 1 - web/pgadmin/tools/schema_diff/__init__.py | 62 +-- web/pgadmin/tools/schema_diff/compare.py | 117 +---- web/pgadmin/tools/schema_diff/directory_compare.py | 208 +++++++-- .../schema_diff/static/js/schema_diff.backform.js | 2 + .../tools/schema_diff/static/js/schema_diff_ui.js | 107 ++--- .../schema_diff/tests/test_schema_diff_comp.py | 14 +- 52 files changed, 958 insertions(+), 928 deletions(-)
pgadmin-hackers by date: