Added support to compare schemas and databases in schema diff. Fixes #5891 Branch ------ master
Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b76bb5837844d65bbc26e766600c992230e56273 Modified Files -------------- docs/en_US/images/schema_diff_DDL_comparison.png | Bin 445311 -> 441370 bytes docs/en_US/images/schema_diff_compare_button.png | Bin 63793 -> 95363 bytes .../images/schema_diff_comparison_results.png | Bin 204651 -> 226990 bytes docs/en_US/images/schema_diff_dialog.png | Bin 372964 -> 126941 bytes docs/en_US/images/schema_diff_filter_option.png | Bin 156963 -> 169845 bytes .../schema_diff_generate_script_query_editor.png | Bin 233673 -> 252819 bytes docs/en_US/release_notes_4_28.rst | 1 + docs/en_US/schema_diff.rst | 19 ++- .../databases/schemas/collations/__init__.py | 9 ++ .../servers/databases/schemas/domains/__init__.py | 9 ++ .../databases/schemas/foreign_tables/__init__.py | 7 + .../schemas/fts_configurations/__init__.py | 21 +++ .../databases/schemas/fts_dictionaries/__init__.py | 7 + .../databases/schemas/fts_parsers/__init__.py | 21 +++ .../databases/schemas/fts_templates/__init__.py | 21 +++ .../databases/schemas/functions/__init__.py | 15 ++- .../servers/databases/schemas/packages/__init__.py | 19 ++- .../databases/schemas/sequences/__init__.py | 9 ++ .../servers/databases/schemas/synonyms/__init__.py | 12 ++ .../servers/databases/schemas/tables/__init__.py | 6 +- .../schemas/tables/compound_triggers/__init__.py | 15 ++- .../databases/schemas/tables/indexes/__init__.py | 12 +- .../tables/row_security_policies/__init__.py | 15 ++- .../databases/schemas/tables/rules/__init__.py | 17 +++ .../databases/schemas/tables/schema_diff_utils.py | 22 +++- .../databases/schemas/tables/triggers/__init__.py | 8 +- .../servers/databases/schemas/types/__init__.py | 9 ++ .../servers/databases/schemas/views/__init__.py | 11 ++ web/pgadmin/tools/schema_diff/__init__.py | 145 ++++++++++++++++++--- web/pgadmin/tools/schema_diff/compare.py | 10 +- web/pgadmin/tools/schema_diff/directory_compare.py | 19 ++- .../schema_diff/static/js/schema_diff.backform.js | 2 +- .../tools/schema_diff/static/js/schema_diff_ui.js | 63 ++++++++- .../schema_diff/tests/test_schema_diff_comp.py | 2 +- 34 files changed, 466 insertions(+), 60 deletions(-)
