Added publication and subscription support in Schema Diff. Fixes #6153 Branch ------ master
Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=44cc7a308ab2b9d4f9ec10d34bff29a71dc2fb20 Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_5_0.rst | 1 + .../servers/databases/publications/__init__.py | 191 ++- .../templates/publications/sql/default/delete.sql | 2 +- .../publications/sql/default/dependencies.sql | 5 + .../publications/sql/default/get_all_tables.sql | 2 +- .../publications/sql/default/get_position.sql | 2 +- .../publications/sql/default/get_tables.sql | 4 +- .../servers/databases/subscriptions/__init__.py | 191 ++- .../subscriptions/static/js/subscription.js | 1 + .../tests/10_plus/alter_maintenance_db.sql | 2 +- .../tests/10_plus/alter_subscription.sql | 2 +- .../subscriptions/tests/10_plus/alter_sync.sql | 2 +- .../tests/10_plus/create_subscription.sql | 2 +- .../tests/subscription_test_data.json | 20 +- .../tests/test_subscription_create.py | 3 +- .../templates/depends/pg/11_plus/dependents.sql | 8 +- .../templates/depends/pg/12_plus/dependents.sql | 8 +- .../templates/depends/ppas/11_plus/dependents.sql | 9 +- .../templates/depends/ppas/12_plus/dependents.sql | 8 +- web/pgadmin/browser/utils.py | 5 +- .../server_groups/servers/model_validation.js | 10 +- .../js/erd_tool/ui_components/BodyWidget.jsx | 2 +- .../tools/schema_diff/tests/pg/10_plus/source.sql | 41 + .../tools/schema_diff/tests/pg/10_plus/target.sql | 47 + .../tools/schema_diff/tests/pg/11_plus/source.sql | 43 + .../tools/schema_diff/tests/pg/11_plus/target.sql | 48 + .../tools/schema_diff/tests/pg/12_plus/source.sql | 50 + .../tools/schema_diff/tests/pg/12_plus/target.sql | 48 + .../schema_diff/tests/ppas/10_plus/source.sql | 43 + .../schema_diff/tests/ppas/10_plus/target.sql | 47 + .../schema_diff/tests/ppas/11_plus/source.sql | 1319 ++++++++++++++++++++ .../schema_diff/tests/ppas/11_plus/target.sql | 1261 +++++++++++++++++++ 32 files changed, 3287 insertions(+), 140 deletions(-)