pgAdmin 4 commit: Improve logic to get the DDL statements as a part of

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(-)