1) Add Reverse Engineered and Modified SQL tests for Foreign Servers. Fixes #4617 2) Add Reverse Engineered and Modified SQL tests for User Mappings. Fixes #4627
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4745ad56e9f0253e8038889bc1765c213d65a47c Modified Files -------------- docs/en_US/release_notes_4_13.rst | 2 + .../templates/foreign_servers/sql/9.3_plus/acl.sql | 1 + .../foreign_servers/sql/9.3_plus/create.sql | 1 - .../foreign_servers/sql/default/create.sql | 2 +- .../tests/pg/9.3_plus/alter_comment_version.sql | 13 ++ .../pg/9.3_plus/alter_comment_version_msql.sql | 5 + .../tests/pg/9.3_plus/alter_options_privileges.sql | 18 +++ .../pg/9.3_plus/alter_options_privileges_msql.sql | 4 + .../pg/9.3_plus/alter_remove_options_priv.sql | 15 ++ .../pg/9.3_plus/alter_remove_options_priv_msql.sql | 4 + .../tests/pg/9.3_plus/create_fs_all_options.sql | 18 +++ .../pg/9.3_plus/create_fs_all_options_msql.sql | 13 ++ .../tests/pg/9.3_plus/test_foreign_servers.json | 159 +++++++++++++++++++++ .../tests/ppas/9.3_plus/alter_comment_version.sql | 13 ++ .../ppas/9.3_plus/alter_comment_version_msql.sql | 5 + .../ppas/9.3_plus/alter_options_privileges.sql | 18 +++ .../9.3_plus/alter_options_privileges_msql.sql | 4 + .../ppas/9.3_plus/alter_remove_options_priv.sql | 15 ++ .../9.3_plus/alter_remove_options_priv_msql.sql | 4 + .../tests/ppas/9.3_plus/create_fs_all_options.sql | 18 +++ .../ppas/9.3_plus/create_fs_all_options_msql.sql | 13 ++ .../tests/ppas/9.3_plus/test_foreign_servers.json | 159 +++++++++++++++++++++ .../tests/pg/default/alter_options.sql | 6 + .../tests/pg/default/alter_options_deleted.sql | 5 + .../pg/default/alter_options_deleted_msql.sql | 2 + .../tests/pg/default/alter_options_msql.sql | 2 + .../tests/pg/default/create_user_mapping.sql | 6 + .../tests/pg/default/create_user_mapping_msql.sql | 2 + .../tests/pg/default/test_user_mappings.json | 99 +++++++++++++ .../tests/ppas/default/alter_options.sql | 6 + .../tests/ppas/default/alter_options_deleted.sql | 5 + .../ppas/default/alter_options_deleted_msql.sql | 2 + .../tests/ppas/default/alter_options_msql.sql | 2 + .../tests/ppas/default/create_user_mapping.sql | 6 + .../ppas/default/create_user_mapping_msql.sql | 2 + .../tests/ppas/default/test_user_mappings.json | 99 +++++++++++++ .../schemas/tables/columns/tests/10_plus/test.json | 2 +- .../schemas/tables/columns/tests/12_plus/test.json | 2 +- .../schemas/tables/columns/tests/default/test.json | 2 +- .../compound_triggers/tests/ppas/12_plus/test.json | 2 +- .../check_constraint/tests/Default/test.json | 2 +- .../exclusion_constraint/tests/11_plus/test.json | 2 +- .../exclusion_constraint/tests/default/test.json | 2 +- .../schemas/tables/rules/tests/default/test.json | 2 +- web/regression/re_sql/tests/test_resql.py | 44 ++++-- 45 files changed, 790 insertions(+), 18 deletions(-)
