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:

Previous
From: Fahar Abbas
Date:
Subject: Re: Windows testing required: Updated runtime
Next
From: Akshay Joshi
Date:
Subject: Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4