Add Reverse Engineered SQL tests for Schemas. Fixes #4575 Branch ------ master
Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e0c53e7d1dfdb68a55c8aca30d4e59a37c913724 Modified Files -------------- docs/en_US/release_notes_4_13.rst | 1 + .../templates/schemas/pg/9.2_plus/sql/acl.sql | 3 +- .../templates/schemas/pg/default/sql/acl.sql | 3 +- .../templates/schemas/ppas/9.1_plus/sql/acl.sql | 3 +- .../templates/schemas/ppas/9.2_plus/sql/acl.sql | 3 +- .../tests/pg/9.2_plus/alter_schema_add_priv.sql | 22 ++ .../pg/9.2_plus/alter_schema_add_priv_msql.sql | 13 + .../tests/pg/9.2_plus/alter_schema_drop_priv.sql | 14 ++ .../pg/9.2_plus/alter_schema_drop_priv_msql.sql | 5 + .../tests/pg/9.2_plus/alter_schema_name.sql | 9 + .../tests/pg/9.2_plus/alter_schema_name_msql.sql | 2 + .../pg/9.2_plus/create_schema_all_options.sql | 25 ++ .../pg/9.2_plus/create_schema_all_options_msql.sql | 18 ++ .../pg/9.2_plus/create_schema_with_comment.sql | 9 + .../9.2_plus/create_schema_with_comment_msql.sql | 4 + .../schemas/tests/pg/9.2_plus/test_schema.json | 272 +++++++++++++++++++++ .../tests/ppas/9.2_plus/alter_schema_add_priv.sql | 22 ++ .../ppas/9.2_plus/alter_schema_add_priv_msql.sql | 17 ++ .../tests/ppas/9.2_plus/alter_schema_drop_priv.sql | 14 ++ .../ppas/9.2_plus/alter_schema_drop_priv_msql.sql | 7 + .../tests/ppas/9.2_plus/alter_schema_name.sql | 9 + .../tests/ppas/9.2_plus/alter_schema_name_msql.sql | 2 + .../ppas/9.2_plus/create_schema_all_options.sql | 25 ++ .../9.2_plus/create_schema_all_options_msql.sql | 18 ++ .../ppas/9.2_plus/create_schema_with_comment.sql | 9 + .../9.2_plus/create_schema_with_comment_msql.sql | 4 + .../schemas/tests/ppas/9.2_plus/test_schema.json | 272 +++++++++++++++++++++ web/regression/re_sql/tests/test_resql.py | 7 +- 28 files changed, 807 insertions(+), 5 deletions(-)
