Thread: pgAdmin 4 commit: 1) Add Reverse Engineered and Modified SQL tests for
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(-)