Improve code coverage and API test cases for Columns and Constraints (Index, Foreign Key, Check, Exclusion). Fixes #5332
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8fcf5276327b101be869785159c6f9f557b4a211 Author: Yogesh Mahajan <yogesh.maha...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_4_26.rst | 1 + .../tables/columns/tests/column_test_data.json | 803 ++++++++++++++++++ .../tables/columns/tests/test_column_add.py | 144 ++-- .../tables/columns/tests/test_column_delete.py | 68 +- .../tests/test_column_dependencies_dependents.py | 109 +++ .../tables/columns/tests/test_column_get.py | 60 +- ...delete_multiple.py => test_column_get_nodes.py} | 74 +- .../columns/tests/test_column_get_statistics.py | 100 +++ .../tables/columns/tests/test_column_msql.py | 155 +--- .../tables/columns/tests/test_column_put.py | 114 +-- .../tables/columns/tests/test_column_sql.py | 104 +++ .../schemas/tables/columns/tests/utils.py | 64 +- .../tests/check_constraint_test_data.json | 576 +++++++++++++ .../tests/test_check_constraint_add.py | 63 +- .../tests/test_check_constraint_delete.py | 85 +- ...est_check_constraint_dependencies_dependents.py | 93 +++ .../tests/test_check_constraint_get.py | 64 +- .../tests/test_check_constraint_get_nodes.py | 106 +++ .../tests/test_check_constraint_msql.py | 105 +++ .../tests/test_check_constraint_put.py | 59 +- .../tests/test_check_constraint_sql.py | 105 +++ .../tests/test_check_constraint_validate.py | 95 +++ .../constraints/check_constraint/tests/utils.py | 86 +- .../tests/exclusion_constraint_test_data.json | 545 ++++++++++++ .../tests/test_exclusion_constraint_add.py | 85 +- .../tests/test_exclusion_constraint_delete.py | 99 ++- ...exclusion_constraint_dependencies_dependents.py | 93 +++ .../tests/test_exclusion_constraint_get.py | 79 +- .../tests/test_exclusion_constraint_get_nodes.py | 102 +++ .../test_exclusion_constraint_get_statistics.py | 99 +++ .../tests/test_exclusion_constraint_msql.py | 100 +++ .../tests/test_exclusion_constraint_put.py | 69 +- .../tests/test_exclusion_constraint_sql.py | 99 +++ .../exclusion_constraint/tests/utils.py | 64 ++ .../foreign_key/tests/foreign_key_test_data.json | 620 ++++++++++++++ .../foreign_key/tests/test_foreign_key_add.py | 71 +- .../foreign_key/tests/test_foreign_key_delete.py | 72 +- .../test_foreign_key_dependencies_dependents.py | 96 +++ .../foreign_key/tests/test_foreign_key_get.py | 56 +- .../tests/test_foreign_key_get_convergingindex.py | 79 ++ .../tests/test_foreign_key_get_nodes.py | 107 +++ .../foreign_key/tests/test_foreign_key_msql.py | 97 +++ .../foreign_key/tests/test_foreign_key_put.py | 59 +- .../foreign_key/tests/test_foreign_key_sql.py | 102 +++ .../foreign_key/tests/test_foreign_key_validate.py | 97 +++ .../tables/constraints/foreign_key/tests/utils.py | 104 ++- .../tests/index_constraint_test_data.json | 910 +++++++++++++++++++++ .../tests/test_index_constraint_add.py | 157 ++-- .../tests/test_index_constraint_delete.py | 67 +- ...est_index_constraint_dependencies_dependents.py | 93 +++ .../tests/test_index_constraint_get.py | 68 +- .../tests/test_index_constraint_get_nodes.py | 102 +++ .../tests/test_index_constraint_get_statistics.py | 102 +++ .../tests/test_index_constraint_msql.py | 96 +++ .../tests/test_index_constraint_put.py | 64 +- .../tests/test_index_constraint_sql.py | 99 +++ .../constraints/index_constraint/tests/utils.py | 78 +- .../constraints/tests/constraints_test_data.json | 48 ++ ...lete_multiple.py => test_constraints_delete.py} | 60 +- .../constraints/tests/test_constraints_get.py | 167 ++++ .../tests/test_constraints_get_nodes.py | 135 +++ .../schemas/tables/constraints/tests/utils.py | 68 ++ web/regression/python_test_utils/test_utils.py | 15 + 63 files changed, 7767 insertions(+), 789 deletions(-)
