pgAdmin 4 commit: Improve code coverage and API test cases for Columns

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(dot)mahajan(at)enterprisedb(dot)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(-)