pgAdmin 4 commit: Added support of Declarative Partitioning (Range, Lis

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin 4 commit: Added support of Declarative Partitioning (Range, Lis
Date: 2017-07-07 06:30:01
Message-ID: E1dTMm9-0007DJ-Le@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2017-07-07 06:35:26 Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4
Previous Message Fahar Abbas 2017-07-07 05:08:46 Re: Windows testing required: Updated runtime