Added support of Row Security Policies. Fixes #5516
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=18277543b6c702fa84f332c3a74840c376cd43e2
Author: Pradip Parkale <pradip.parkale@enterprisedb.com>
Modified Files
--------------
docs/en_US/release_notes_4_23.rst | 1 +
.../servers/databases/schemas/tables/__init__.py | 11 +
.../tables/row_security_policies/__init__.py | 589 +++++++++++++++++++++
.../static/img/coll-row_security_policy.svg | 37 ++
.../static/img/row_security_policy.svg | 22 +
.../static/js/row_security_policy.js | 184 +++++++
.../tables/row_security_policies/tests/__init__.py | 16 +
.../tests/default/alter_policy.sql | 11 +
.../tests/default/alter_policy_msql.sql | 2 +
.../tests/default/create_insert_policy.sql | 11 +
.../tests/default/create_public_policy.sql | 11 +
.../tests/default/create_select_policy.sql | 11 +
.../row_security_policies/tests/default/test.json | 86 +++
.../row_security_policies/tests/rls_test_data.json | 493 +++++++++++++++++
.../row_security_policies/tests/test_rls_add.py | 116 ++++
.../row_security_policies/tests/test_rls_delete.py | 91 ++++
.../tests/test_rls_delete_multiple.py | 94 ++++
.../row_security_policies/tests/test_rls_get.py | 98 ++++
.../row_security_policies/tests/test_rls_put.py | 122 +++++
.../tables/row_security_policies/tests/utils.py | 140 +++++
.../schemas/tables/row_security_policies/utils.py | 145 +++++
.../databases/schemas/tables/static/js/table.js | 61 ++-
.../row_security_policies/sql/9.5_plus/create.sql | 22 +
.../row_security_policies/sql/9.5_plus/delete.sql | 1 +
.../sql/9.5_plus/get_parent.sql | 5 +
.../sql/9.5_plus/get_policy_name.sql | 9 +
.../sql/9.5_plus/get_position.sql | 2 +
.../row_security_policies/sql/9.5_plus/nodes.sql | 13 +
.../sql/9.5_plus/properties.sql | 19 +
.../row_security_policies/sql/9.5_plus/update.sql | 33 ++
.../tables/templates/tables/sql/10_plus/create.sql | 17 +
.../templates/tables/sql/10_plus/properties.sql | 2 +-
.../tables/templates/tables/sql/11_plus/create.sql | 17 +
.../templates/tables/sql/11_plus/properties.sql | 2 +-
.../tables/templates/tables/sql/11_plus/update.sql | 24 +
.../tables/templates/tables/sql/12_plus/create.sql | 17 +
.../templates/tables/sql/12_plus/properties.sql | 2 +-
.../tables/templates/tables/sql/12_plus/update.sql | 25 +
.../templates/tables/sql/9.6_plus/create.sql | 18 +
.../templates/tables/sql/9.6_plus/properties.sql | 2 +-
.../templates/tables/sql/9.6_plus/update.sql | 25 +
.../tables/templates/tables/sql/default/create.sql | 15 +
.../templates/tables/sql/default/properties.sql | 2 +-
.../tables/templates/tables/sql/default/update.sql | 24 +
.../servers/databases/schemas/tables/utils.py | 34 ++
web/webpack.config.js | 1 +
web/webpack.shim.js | 1 +
47 files changed, 2678 insertions(+), 6 deletions(-)
