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