pgAdmin 4 commit: Add Reverse Engineered and Modified SQL tests for For - Mailing list pgadmin-hackers

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(-)