Add Reverse Engineered and Modified SQL tests for Foreign Tables. Fixes #4618.
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=5e54f20578c9620c6b92a442c13c79c00a3db3a8
Modified Files
--------------
docs/en_US/release_notes_4_13.rst | 1 +
.../databases/schemas/foreign_tables/__init__.py | 5 +
.../foreign_tables/sql/12_plus/get_constraints.sql | 3 +-
.../templates/foreign_tables/sql/9.2_plus/acl.sql | 3 +-
.../foreign_tables/sql/9.2_plus/update.sql | 37 ++-
.../foreign_tables/sql/9.5_plus/update.sql | 42 ++--
.../tests/pg/9.2_plus/alter_add_opts.sql | 16 ++
.../tests/pg/9.2_plus/alter_add_opts_msql.sql | 5 +
.../tests/pg/9.2_plus/alter_add_priv.sql | 20 ++
.../tests/pg/9.2_plus/alter_add_priv_msql.sql | 1 +
.../tests/pg/9.2_plus/alter_col_opts.sql | 19 ++
.../tests/pg/9.2_plus/alter_col_opts_msql.sql | 14 ++
.../pg/9.2_plus/alter_comment_add_columns.sql | 15 ++
.../pg/9.2_plus/alter_comment_add_columns_msql.sql | 8 +
.../tests/pg/9.2_plus/alter_remove_opts_priv.sql | 17 ++
.../pg/9.2_plus/alter_remove_opts_priv_msql.sql | 4 +
.../create_foreign_table_with_all_options.sql | 20 ++
.../create_foreign_table_with_all_options_msql.sql | 14 ++
.../tests/pg/9.2_plus/test_foreign_table.json | 242 +++++++++++++++++++
.../tests/pg/9.5_plus/alter_add_cons_opts.sql | 19 ++
.../tests/pg/9.5_plus/alter_add_cons_opts_msql.sql | 8 +
.../tests/pg/9.5_plus/alter_add_priv.sql | 23 ++
.../tests/pg/9.5_plus/alter_add_priv_msql.sql | 1 +
.../tests/pg/9.5_plus/alter_col_opts.sql | 22 ++
.../tests/pg/9.5_plus/alter_col_opts_msql.sql | 14 ++
.../pg/9.5_plus/alter_comment_add_columns.sql | 15 ++
.../pg/9.5_plus/alter_comment_add_columns_msql.sql | 8 +
.../pg/9.5_plus/alter_remove_opts_priv_cons.sql | 17 ++
.../9.5_plus/alter_remove_opts_priv_cons_msql.sql | 7 +
.../create_foreign_table_with_all_options.sql | 23 ++
.../create_foreign_table_with_all_options_msql.sql | 17 ++
.../tests/pg/9.5_plus/test_foreign_table.json | 264 +++++++++++++++++++++
.../tests/ppas/9.2_plus/alter_add_opts.sql | 16 ++
.../tests/ppas/9.2_plus/alter_add_opts_msql.sql | 5 +
.../tests/ppas/9.2_plus/alter_add_priv.sql | 20 ++
.../tests/ppas/9.2_plus/alter_add_priv_msql.sql | 1 +
.../tests/ppas/9.2_plus/alter_col_opts.sql | 19 ++
.../tests/ppas/9.2_plus/alter_col_opts_msql.sql | 14 ++
.../ppas/9.2_plus/alter_comment_add_columns.sql | 15 ++
.../9.2_plus/alter_comment_add_columns_msql.sql | 8 +
.../tests/ppas/9.2_plus/alter_remove_opts_priv.sql | 17 ++
.../ppas/9.2_plus/alter_remove_opts_priv_msql.sql | 4 +
.../create_foreign_table_with_all_options.sql | 20 ++
.../create_foreign_table_with_all_options_msql.sql | 14 ++
.../tests/ppas/9.2_plus/test_foreign_table.json | 242 +++++++++++++++++++
.../tests/ppas/9.5_plus/alter_add_cons_opts.sql | 19 ++
.../ppas/9.5_plus/alter_add_cons_opts_msql.sql | 8 +
.../tests/ppas/9.5_plus/alter_add_priv.sql | 23 ++
.../tests/ppas/9.5_plus/alter_add_priv_msql.sql | 1 +
.../tests/ppas/9.5_plus/alter_col_opts.sql | 22 ++
.../tests/ppas/9.5_plus/alter_col_opts_msql.sql | 14 ++
.../ppas/9.5_plus/alter_comment_add_columns.sql | 15 ++
.../9.5_plus/alter_comment_add_columns_msql.sql | 8 +
.../ppas/9.5_plus/alter_remove_opts_priv_cons.sql | 17 ++
.../9.5_plus/alter_remove_opts_priv_cons_msql.sql | 7 +
.../create_foreign_table_with_all_options.sql | 23 ++
.../create_foreign_table_with_all_options_msql.sql | 17 ++
.../tests/ppas/9.5_plus/test_foreign_table.json | 264 +++++++++++++++++++++
58 files changed, 1714 insertions(+), 43 deletions(-)