pgAdmin 4 commit: Added support of Declarative Partitioning (Range,Lis - Mailing list pgadmin-hackers
From | Akshay Joshi |
---|---|
Subject | pgAdmin 4 commit: Added support of Declarative Partitioning (Range,Lis |
Date | |
Msg-id | E1dTMm9-0007DJ-Le@gothos.postgresql.org Whole thread Raw |
List | pgadmin-hackers |
Added support of Declarative Partitioning (Range, List) for PostgreSQL 10. This allows the user to create partitioned table and it's partitions. - Edit partitions, Create/Listing of constraints, rules, triggers under partitions. (Implemented by Harshal) - Updating browser tree node when create/attach/detach partitions from table dialog.(Implemented by Ashesh) Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c2fb0394bf4238fde94372bba88fa07330fdafbb Modified Files -------------- .../servers/databases/schemas/static/js/schema.js | 36 + .../servers/databases/schemas/tables/__init__.py | 2170 +++---------------- .../tables/column/templates/column/js/column.js | 26 +- .../schemas/tables/column/tests/test_column_get.py | 2 +- .../check_constraint/js/check_constraint.js | 15 +- .../js/exclusion_constraint.js | 19 +- .../templates/foreign_key/js/foreign_key.js | 19 +- .../index_constraint/js/index_constraint.js | 27 +- .../templates/constraints/js/constraints.js | 4 +- .../databases/schemas/tables/indexes/__init__.py | 156 +- .../tables/indexes/templates/index/js/index.js | 31 +- .../schemas/tables/partitions/__init__.py | 583 ++++++ .../partitions/static/img/coll-partition.png | Bin 0 -> 1433 bytes .../tables/partitions/static/img/partition.png | Bin 0 -> 1264 bytes .../tables/partitions/static/js/partition.js | 1276 ++++++++++++ .../tables/rules/templates/rules/js/rules.js | 12 +- .../schemas/tables/static/js/partition.utils.js | 323 +++ .../databases/schemas/tables/static/js/table.js | 520 ++++- .../templates/partition/sql/10_plus/attach.sql | 2 + .../partition/sql/10_plus/backend_support.sql | 9 + .../templates/partition/sql/10_plus/create.sql | 30 + .../templates/partition/sql/10_plus/detach.sql | 1 + .../partition/sql/10_plus/get_attach_tables.sql | 23 + .../templates/partition/sql/10_plus/nodes.sql | 15 + .../templates/partition/sql/10_plus/properties.sql | 82 + .../tables/templates/table/sql/10_plus/acl.sql | 46 + .../templates/table/sql/10_plus/get_inherits.sql | 17 + .../tables/templates/table/sql/10_plus/get_oid.sql | 5 + .../templates/table/sql/10_plus/get_table.sql | 8 + .../tables/templates/table/sql/10_plus/nodes.sql | 9 + .../templates/table/sql/10_plus/properties.sql | 73 + .../tables/templates/table/sql/default/create.sql | 3 +- .../templates/table/sql/default/get_schema_oid.sql | 3 +- .../schemas/tables/tests/test_table_add.py | 61 +- .../schemas/tables/tests/test_table_delete.py | 2 +- .../schemas/tables/tests/test_table_put.py | 89 +- .../databases/schemas/tables/tests/utils.py | 150 ++ .../triggers/templates/trigger/js/trigger.js | 37 +- .../servers/databases/schemas/tables/utils.py | 2178 ++++++++++++++++++++ .../browser/templates/browser/js/browser.js | 197 +- web/pgadmin/browser/templates/browser/js/node.js | 22 +- .../tools/backup/templates/backup/js/backup.js | 2 +- web/pgadmin/tools/datagrid/__init__.py | 26 +- .../datagrid/templates/datagrid/js/datagrid.js | 2 +- .../templates/maintenance/js/maintenance.js | 13 +- .../tools/restore/templates/restore/js/restore.js | 3 +- web/pgadmin/utils/__init__.py | 3 + web/pgadmin/utils/exception.py | 8 + 48 files changed, 6275 insertions(+), 2063 deletions(-)
pgadmin-hackers by date: