pgAdmin 4 commit: Implementation of Table, Column, Index, Trigger, Cons

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(-)