pgAdmin 4 commit: Implementation of Table, Column, Index, Trigger, Cons - Mailing list pgadmin-hackers

Implementation of Table, Column, Index, Trigger, Constraints and Rule Node.
 - Table, Column, Index and Trigger (Author:- Murtuza Zabuawala)
 - Constraints Primary Key/Unique/Check/Foreign Key/Exclusion
     with integration into Table node (Author:- Harshal Dhumal)
 - Rule (Author:- Surinder Kumar)
 - Vacuum Control (Initial patch by Surinder Kumar and further enhancement by Murtuza)

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4dbe0588321d8c391f0adbbe84f2d34d554ab71b

Modified Files
--------------
.../servers/databases/schemas/tables/__init__.py   | 2809 ++++++++++++++++++++
.../databases/schemas/tables/column/__init__.py    |  906 +++++++
.../tables/column/static/img/coll-column.png       |  Bin 0 -> 400 bytes
.../schemas/tables/column/static/img/column.png    |  Bin 0 -> 435 bytes
.../tables/column/templates/column/js/column.js    |  586 ++++
.../templates/column/macros/privilege.macros       |   13 +
.../column/templates/column/macros/security.macros |    6 +
.../schemas/tables/constraints/__init__.py         |  133 +
.../constraints/check_constraint/__init__.py       |  833 ++++++
.../static/img/check-constraints-bad.png           |  Bin 0 -> 579 bytes
.../static/img/check-constraints.png               |  Bin 0 -> 406 bytes
.../check_constraint/css/check_constraint.css      |   15 +
.../check_constraint/js/check_constraint.js        |  216 ++
.../constraints/exclusion_constraint/__init__.py   |  820 ++++++
.../static/img/exclusion_constraint.png            |  Bin 0 -> 725 bytes
.../js/exclusion_constraint.js                     |  915 +++++++
.../tables/constraints/foreign_key/__init__.py     | 1072 ++++++++
.../foreign_key/static/img/foreign_key.png         |  Bin 0 -> 299 bytes
.../static/img/foreign_key_no_validate.png         |  Bin 0 -> 618 bytes
.../templates/foreign_key/css/foreign_key.css      |   12 +
.../templates/foreign_key/js/foreign_key.js        | 1072 ++++++++
.../constraints/index_constraint/__init__.py       |  878 ++++++
.../index_constraint/static/img/primary_key.png    |  Bin 0 -> 443 bytes
.../static/img/unique_constraint.png               |  Bin 0 -> 422 bytes
.../index_constraint/js/index_constraint.js        |  536 ++++
.../constraints/static/img/coll-constraints.png    |  Bin 0 -> 314 bytes
.../templates/constraints/js/constraints.js        |   54 +
.../databases/schemas/tables/constraints/type.py   |   42 +
.../databases/schemas/tables/indexes/__init__.py   |  874 ++++++
.../tables/indexes/static/img/coll-index.png       |  Bin 0 -> 468 bytes
.../schemas/tables/indexes/static/img/index.png    |  Bin 0 -> 562 bytes
.../tables/indexes/templates/index/js/index.js     |  409 +++
.../databases/schemas/tables/rules/__init__.py     |  497 ++++
.../schemas/tables/rules/static/img/coll-rule.png  |  Bin 0 -> 357 bytes
.../schemas/tables/rules/static/img/rule.png       |  Bin 0 -> 373 bytes
.../tables/rules/templates/rules/css/rule.css      |   16 +
.../tables/rules/templates/rules/js/rules.js       |  266 ++
.../schemas/tables/static/img/coll-table.png       |  Bin 0 -> 555 bytes
.../schemas/tables/static/img/table-repl-sm.png    |  Bin 0 -> 675 bytes
.../schemas/tables/static/img/table-repl.png       |  Bin 0 -> 839 bytes
.../databases/schemas/tables/static/img/table.png  |  Bin 0 -> 593 bytes
.../check_constraint/sql/9.1_plus/alter.sql        |    4 +
.../check_constraint/sql/9.1_plus/create.sql       |    4 +
.../check_constraint/sql/9.1_plus/delete.sql       |    3 +
.../check_constraint/sql/9.1_plus/get_name.sql     |    4 +
.../check_constraint/sql/9.1_plus/get_oid.sql      |    7 +
.../sql/9.1_plus/get_oid_with_transaction.sql      |    5 +
.../check_constraint/sql/9.1_plus/get_parent.sql   |    7 +
.../check_constraint/sql/9.1_plus/nodes.sql        |    6 +
.../check_constraint/sql/9.1_plus/properties.sql   |   13 +
.../check_constraint/sql/9.1_plus/update.sql       |    4 +
.../check_constraint/sql/9.2_plus/alter.sql        |    4 +
.../check_constraint/sql/9.2_plus/create.sql       |    6 +
.../check_constraint/sql/9.2_plus/delete.sql       |    3 +
.../check_constraint/sql/9.2_plus/get_name.sql     |    5 +
.../check_constraint/sql/9.2_plus/get_oid.sql      |    8 +
.../sql/9.2_plus/get_oid_with_transaction.sql      |    6 +
.../check_constraint/sql/9.2_plus/get_parent.sql   |    7 +
.../check_constraint/sql/9.2_plus/nodes.sql        |    7 +
.../check_constraint/sql/9.2_plus/properties.sql   |   14 +
.../check_constraint/sql/9.2_plus/update.sql       |   13 +
.../check_constraint/sql/9.2_plus/validate.sql     |    2 +
.../templates/column/macros/privilege.macros       |   13 +
.../tables/templates/column/macros/security.macros |    6 +
.../tables/templates/column/sql/9.1_plus/acl.sql   |   34 +
.../templates/column/sql/9.1_plus/create.sql       |   38 +
.../templates/column/sql/9.1_plus/delete.sql       |    1 +
.../templates/column/sql/9.1_plus/depend.sql       |    9 +
.../column/sql/9.1_plus/edit_mode_types.sql        |    5 +
.../column/sql/9.1_plus/get_collations.sql         |    7 +
.../column/sql/9.1_plus/get_inherited_tables.sql   |   12 +
.../templates/column/sql/9.1_plus/get_parent.sql   |    5 +
.../templates/column/sql/9.1_plus/get_position.sql |    4 +
.../templates/column/sql/9.1_plus/get_types.sql    |   14 +
.../column/sql/9.1_plus/is_referenced.sql          |    5 +
.../tables/templates/column/sql/9.1_plus/nodes.sql |   18 +
.../templates/column/sql/9.1_plus/properties.sql   |   45 +
.../templates/column/sql/9.1_plus/update.sql       |  107 +
.../tables/templates/column/sql/9.2_plus/acl.sql   |   34 +
.../templates/column/sql/9.2_plus/create.sql       |   38 +
.../templates/column/sql/9.2_plus/delete.sql       |    1 +
.../templates/column/sql/9.2_plus/depend.sql       |    9 +
.../column/sql/9.2_plus/edit_mode_types.sql        |    5 +
.../column/sql/9.2_plus/get_collations.sql         |    7 +
.../column/sql/9.2_plus/get_inherited_tables.sql   |   12 +
.../templates/column/sql/9.2_plus/get_parent.sql   |    5 +
.../templates/column/sql/9.2_plus/get_position.sql |    4 +
.../templates/column/sql/9.2_plus/get_types.sql    |   14 +
.../column/sql/9.2_plus/is_referenced.sql          |    5 +
.../tables/templates/column/sql/9.2_plus/nodes.sql |   18 +
.../templates/column/sql/9.2_plus/properties.sql   |   45 +
.../templates/column/sql/9.2_plus/update.sql       |  105 +
.../exclusion_constraint/sql/9.1_plus/alter.sql    |    4 +
.../exclusion_constraint/sql/9.1_plus/begin.sql    |    1 +
.../exclusion_constraint/sql/9.1_plus/create.sql   |   12 +
.../exclusion_constraint/sql/9.1_plus/delete.sql   |    3 +
.../exclusion_constraint/sql/9.1_plus/end.sql      |    1 +
.../sql/9.1_plus/get_access_methods.sql            |    6 +
.../sql/9.1_plus/get_constraint_cols.sql           |   22 +
.../exclusion_constraint/sql/9.1_plus/get_name.sql |    3 +
.../exclusion_constraint/sql/9.1_plus/get_oid.sql  |    4 +
.../sql/9.1_plus/get_oid_with_transaction.sql      |    6 +
.../sql/9.1_plus/get_oper_class.sql                |    7 +
.../sql/9.1_plus/get_operator.sql                  |   29 +
.../sql/9.1_plus/get_parent.sql                    |    7 +
.../exclusion_constraint/sql/9.1_plus/nodes.sql    |    7 +
.../sql/9.1_plus/properties.sql                    |   30 +
.../exclusion_constraint/sql/9.1_plus/update.sql   |   22 +
.../exclusion_constraint/sql/9.2_plus/alter.sql    |    4 +
.../exclusion_constraint/sql/9.2_plus/begin.sql    |    1 +
.../exclusion_constraint/sql/9.2_plus/create.sql   |   12 +
.../exclusion_constraint/sql/9.2_plus/delete.sql   |    3 +
.../exclusion_constraint/sql/9.2_plus/end.sql      |    1 +
.../sql/9.2_plus/get_access_methods.sql            |    6 +
.../sql/9.2_plus/get_constraint_cols.sql           |   22 +
.../exclusion_constraint/sql/9.2_plus/get_name.sql |    3 +
.../exclusion_constraint/sql/9.2_plus/get_oid.sql  |    4 +
.../sql/9.2_plus/get_oid_with_transaction.sql      |    6 +
.../sql/9.2_plus/get_oper_class.sql                |    7 +
.../sql/9.2_plus/get_operator.sql                  |   30 +
.../sql/9.2_plus/get_parent.sql                    |    7 +
.../exclusion_constraint/sql/9.2_plus/nodes.sql    |    7 +
.../sql/9.2_plus/properties.sql                    |   30 +
.../exclusion_constraint/sql/9.2_plus/update.sql   |   22 +
.../tables/templates/foreign_key/sql/alter.sql     |    4 +
.../tables/templates/foreign_key/sql/begin.sql     |    1 +
.../tables/templates/foreign_key/sql/create.sql    |   27 +
.../templates/foreign_key/sql/create_index.sql     |    5 +
.../tables/templates/foreign_key/sql/delete.sql    |    3 +
.../tables/templates/foreign_key/sql/end.sql       |    1 +
.../tables/templates/foreign_key/sql/get_cols.sql  |    7 +
.../foreign_key/sql/get_constraint_cols.sql        |   13 +
.../templates/foreign_key/sql/get_constraints.sql  |   37 +
.../tables/templates/foreign_key/sql/get_name.sql  |    3 +
.../tables/templates/foreign_key/sql/get_oid.sql   |    5 +
.../foreign_key/sql/get_oid_with_transaction.sql   |    6 +
.../templates/foreign_key/sql/get_parent.sql       |    7 +
.../tables/templates/foreign_key/sql/nodes.sql     |    7 +
.../templates/foreign_key/sql/properties.sql       |   31 +
.../tables/templates/foreign_key/sql/update.sql    |   18 +
.../tables/templates/foreign_key/sql/validate.sql  |    2 +
.../tables/templates/index/sql/9.1_plus/alter.sql  |   11 +
.../index/sql/9.1_plus/backend_support.sql         |    9 +
.../index/sql/9.1_plus/column_details.sql          |   30 +
.../tables/templates/index/sql/9.1_plus/create.sql |   12 +
.../tables/templates/index/sql/9.1_plus/delete.sql |    1 +
.../tables/templates/index/sql/9.1_plus/get_am.sql |    3 +
.../index/sql/9.1_plus/get_collations.sql          |    7 +
.../templates/index/sql/9.1_plus/get_oid.sql       |    7 +
.../templates/index/sql/9.1_plus/get_op_class.sql  |    5 +
.../templates/index/sql/9.1_plus/get_parent.sql    |    5 +
.../tables/templates/index/sql/9.1_plus/nodes.sql  |   12 +
.../templates/index/sql/9.1_plus/properties.sql    |   22 +
.../tables/templates/index/sql/9.1_plus/update.sql |   24 +
.../templates/index_constraint/sql/alter.sql       |    4 +
.../templates/index_constraint/sql/begin.sql       |    1 +
.../templates/index_constraint/sql/create.sql      |   12 +
.../templates/index_constraint/sql/delete.sql      |    3 +
.../tables/templates/index_constraint/sql/end.sql  |    1 +
.../index_constraint/sql/get_constraint_cols.sql   |    7 +
.../templates/index_constraint/sql/get_indices.sql |    3 +
.../templates/index_constraint/sql/get_name.sql    |   15 +
.../templates/index_constraint/sql/get_oid.sql     |    4 +
.../sql/get_oid_with_transaction.sql               |    5 +
.../templates/index_constraint/sql/get_parent.sql  |    7 +
.../templates/index_constraint/sql/nodes.sql       |   14 +
.../templates/index_constraint/sql/properties.sql  |   29 +
.../templates/index_constraint/sql/update.sql      |   22 +
.../tables/templates/rules/sql/backend_support.sql |    9 +
.../schemas/tables/templates/rules/sql/create.sql  |   27 +
.../schemas/tables/templates/rules/sql/delete.sql  |   16 +
.../tables/templates/rules/sql/properties.sql      |   27 +
.../schemas/tables/templates/rules/sql/rule_id.sql |    9 +
.../schemas/tables/templates/rules/sql/update.sql  |   33 +
.../schemas/tables/templates/table/js/table.js     |  954 +++++++
.../tables/templates/table/sql/9.1_plus/acl.sql    |   46 +
.../table/sql/9.1_plus/backend_support.sql         |   18 +
.../tables/templates/table/sql/9.1_plus/create.sql |  157 ++
.../tables/templates/table/sql/9.1_plus/delete.sql |    1 +
.../tables/templates/table/sql/9.1_plus/depend.sql |    9 +
.../table/sql/9.1_plus/enable_disable_trigger.sql  |    2 +
.../table/sql/9.1_plus/get_columns_for_table.sql   |   16 +
.../templates/table/sql/9.1_plus/get_inherits.sql  |   16 +
.../templates/table/sql/9.1_plus/get_oftype.sql    |    6 +
.../templates/table/sql/9.1_plus/get_oid.sql       |    5 +
.../templates/table/sql/9.1_plus/get_relations.sql |    6 +
.../sql/9.1_plus/get_tables_for_constraints.sql    |    8 +
.../sql/9.1_plus/get_types_where_condition.sql     |   10 +
.../tables/templates/table/sql/9.1_plus/nodes.sql  |    6 +
.../templates/table/sql/9.1_plus/properties.sql    |   65 +
.../templates/table/sql/9.1_plus/reset_stats.sql   |    1 +
.../tables/templates/table/sql/9.1_plus/sql.sql    |    1 +
.../templates/table/sql/9.1_plus/truncate.sql      |    1 +
.../tables/templates/table/sql/9.1_plus/update.sql |  201 ++
.../tables/templates/table/sql/9.5_plus/acl.sql    |   46 +
.../table/sql/9.5_plus/backend_support.sql         |   18 +
.../tables/templates/table/sql/9.5_plus/create.sql |  157 ++
.../tables/templates/table/sql/9.5_plus/delete.sql |    1 +
.../tables/templates/table/sql/9.5_plus/depend.sql |    9 +
.../table/sql/9.5_plus/enable_disable_trigger.sql  |    2 +
.../table/sql/9.5_plus/get_columns_for_table.sql   |   16 +
.../templates/table/sql/9.5_plus/get_inherits.sql  |   16 +
.../templates/table/sql/9.5_plus/get_oftype.sql    |    6 +
.../templates/table/sql/9.5_plus/get_oid.sql       |    5 +
.../templates/table/sql/9.5_plus/get_relations.sql |    6 +
.../sql/9.5_plus/get_tables_for_constraints.sql    |    8 +
.../sql/9.5_plus/get_types_where_condition.sql     |   10 +
.../tables/templates/table/sql/9.5_plus/nodes.sql  |    6 +
.../templates/table/sql/9.5_plus/properties.sql    |   65 +
.../templates/table/sql/9.5_plus/reset_stats.sql   |    1 +
.../tables/templates/table/sql/9.5_plus/sql.sql    |    1 +
.../templates/table/sql/9.5_plus/truncate.sql      |    1 +
.../tables/templates/table/sql/9.5_plus/update.sql |  201 ++
.../templates/table/sql/macros/constraints.macro   |  103 +
.../templates/trigger/sql/9.1_plus/alter.sql       |    9 +
.../trigger/sql/9.1_plus/backend_support.sql       |    9 +
.../templates/trigger/sql/9.1_plus/create.sql      |   27 +
.../templates/trigger/sql/9.1_plus/delete.sql      |    1 +
.../sql/9.1_plus/enable_disable_trigger.sql        |    2 +
.../templates/trigger/sql/9.1_plus/get_columns.sql |    6 +
.../templates/trigger/sql/9.1_plus/get_oid.sql     |    5 +
.../templates/trigger/sql/9.1_plus/get_parent.sql  |    5 +
.../trigger/sql/9.1_plus/get_triggerfunctions.sql  |   11 +
.../templates/trigger/sql/9.1_plus/nodes.sql       |    5 +
.../templates/trigger/sql/9.1_plus/properties.sql  |   23 +
.../templates/trigger/sql/9.1_plus/update.sql      |    8 +
.../databases/schemas/tables/triggers/__init__.py  |  944 +++++++
.../tables/triggers/static/img/coll-trigger.png    |  Bin 0 -> 350 bytes
.../tables/triggers/static/img/trigger-bad.png     |  Bin 0 -> 610 bytes
.../schemas/tables/triggers/static/img/trigger.png |  Bin 0 -> 324 bytes
.../triggers/templates/trigger/css/trigger.css     |   20 +
.../triggers/templates/trigger/js/trigger.js       |  547 ++++
.../templates/datatype/sql/9.1_plus/get_types.sql  |    3 +-
.../templates/macros/schemas/privilege.macros      |    4 +
.../schemas/templates/schema/js/schema.js          |  250 ++
.../vacuum_settings/sql/vacuum_defaults.sql        |    2 +
.../templates/vacuum_settings/vacuum_fields.json   |   39 +
.../servers/databases/schemas/utils.py             |  157 +-
238 files changed, 18920 insertions(+), 3 deletions(-)