pgAdmin 4 commit: Add Reverse Engineered and Modified SQL tests for For

Akshay Joshi <[email protected]>
Newsgroups gmane.comp.db.postgresql.pgadmin.devel
Message-ID <[email protected]>
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(-)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.