1) Add Reverse Engineered and Modified SQL tests for Foreign Keys. Fixes #4616
2) Fix issue where Validated switch option is inverted for the Foreign Key. Fixes #4412
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6a931588aa105a52f00a2547095cae6070ea345e
Modified Files
--------------
docs/en_US/release_notes_4_13.rst | 2 +
.../foreign_key/static/js/foreign_key.js | 2 +-
.../9.3_plus/alter_name_comment_validation.sql | 13 +
.../alter_name_comment_validation_msql.sql | 8 +
.../tests/9.3_plus/create_foreign_key_cascade.sql | 10 +
.../9.3_plus/create_foreign_key_cascade_msql.sql | 6 +
.../tests/9.3_plus/create_foreign_key_restrict.sql | 10 +
.../9.3_plus/create_foreign_key_restrict_msql.sql | 6 +
.../9.3_plus/create_foreign_key_setdefault.sql | 10 +
.../create_foreign_key_setdefault_msql.sql | 6 +
.../tests/9.3_plus/create_foreign_key_setnull.sql | 10 +
.../9.3_plus/create_foreign_key_setnull_msql.sql | 6 +
.../tests/9.3_plus/create_foreign_key_simple.sql | 10 +
.../9.3_plus/create_foreign_key_simple_msql.sql | 6 +
.../create_foreign_key_with_all_options.sql | 14 +
.../create_foreign_key_with_all_options_msql.sql | 13 +
.../tests/9.3_plus/test_foreign_keys.json | 293 +++++++++++++++++++++
.../foreign_key/sql/9.1_plus/properties.sql | 4 +-
.../templates/foreign_key/sql/default/create.sql | 5 +-
.../foreign_key/sql/default/properties.sql | 4 +-
.../templates/foreign_key/sql/default/update.sql | 6 +-
web/regression/re_sql/tests/test_resql.py | 58 +++-
22 files changed, 491 insertions(+), 11 deletions(-)