pgAdmin 4 commit: Sorting the data during tree data loading using the n

Sorting the data during tree data loading using the natural sort
algorithm.

This patch takes care of:
* Consistent behaviour during create, update operation on any node.
- It should return the node data during creating a new object, or
updating the existing one.
* Now that - we have consistent behaviour during these operations, we
can consistently move, update the tree item based the node data from
the server.
* Implemented the methods for each node to get the information about
that particular node only.
* Using the above changes to implement the 'refresh' operation on tree
node properly.

I must thank Surinder, and Harshal for helping me implement the 'node'
method, and also changed the behaviour of create & update methods to
return the node data for most of the nodes.

Fixes #1244

Branch
------
master

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

Modified Files
--------------
libraries.txt | 1 +
web/pgadmin/browser/collection.py | 2 +-
web/pgadmin/browser/server_groups/__init__.py | 50 +-
.../browser/server_groups/servers/__init__.py | 16 +-
.../server_groups/servers/databases/__init__.py | 34 +-
.../servers/databases/casts/__init__.py | 127 ++-
.../servers/databases/event_triggers/__init__.py | 51 +-
.../event_triggers/sql/9.3_plus/nodes.sql | 3 +
.../servers/databases/extensions/__init__.py | 133 ++--
.../databases/foreign_data_wrappers/__init__.py | 253 +++---
.../foreign_servers/__init__.py | 264 +++---
.../foreign_servers/user_mapping/__init__.py | 260 +++---
.../servers/databases/languages/__init__.py | 155 ++--
.../servers/databases/schemas/__init__.py | 104 ++-
.../databases/schemas/catalog_objects/__init__.py | 40 +
.../schemas/catalog_objects/columns/__init__.py | 6 +-
.../catalog_object/sql/pg/9.1_plus/nodes.sql | 4 +
.../catalog_object/sql/ppas/9.1_plus/nodes.sql | 4 +
.../databases/schemas/collations/__init__.py | 169 ++--
.../templates/collation/sql/9.1_plus/get_oid.sql | 11 +-
.../templates/collation/sql/9.1_plus/nodes.sql | 4 +
.../servers/databases/schemas/domains/__init__.py | 298 +++----
.../schemas/domains/domain_constraints/__init__.py | 48 ++
.../domain_constraints/sql/9.1_plus/properties.sql | 5 +
.../domain_constraints/sql/9.2_plus/properties.sql | 5 +
.../templates/domains/sql/9.1_plus/node.sql | 4 +
.../templates/domains/sql/9.2_plus/node.sql | 4 +
.../databases/schemas/foreign_tables/__init__.py | 272 ++++---
.../templates/foreign_tables/sql/9.1_plus/node.sql | 4 +
.../templates/foreign_tables/sql/9.2_plus/node.sql | 4 +
.../templates/foreign_tables/sql/9.5_plus/node.sql | 4 +
.../schemas/fts_configurations/__init__.py | 338 ++++----
.../fts_configuration/sql/9.1_plus/properties.sql | 7 +-
.../fts_configuration/sql/9.1_plus/update.sql | 4 +-
.../databases/schemas/fts_dictionaries/__init__.py | 320 ++++----
.../fts_dictionary/sql/9.1_plus/properties.sql | 9 +-
.../databases/schemas/fts_parser/__init__.py | 310 ++++----
.../templates/fts_parser/sql/9.1_plus/nodes.sql | 4 +-
.../fts_parser/sql/9.1_plus/properties.sql | 10 +-
.../databases/schemas/fts_templates/__init__.py | 399 +++++-----
.../templates/fts_template/sql/9.1_plus/nodes.sql | 4 +-
.../fts_template/sql/9.1_plus/properties.sql | 9 +-
.../templates/fts_template/sql/9.1_plus/update.sql | 4 +-
.../databases/schemas/functions/__init__.py | 497 ++++++------
.../templates/function/pg/sql/9.1_plus/get_oid.sql | 2 +-
.../templates/function/pg/sql/9.1_plus/node.sql | 5 +
.../function/pg/sql/9.1_plus/properties.sql | 5 +-
.../templates/function/pg/sql/9.2_plus/get_oid.sql | 2 +-
.../templates/function/pg/sql/9.2_plus/node.sql | 5 +
.../function/pg/sql/9.2_plus/properties.sql | 3 +-
.../templates/function/pg/sql/9.5_plus/get_oid.sql | 2 +-
.../templates/function/pg/sql/9.5_plus/node.sql | 5 +
.../function/pg/sql/9.5_plus/properties.sql | 5 +-
.../function/ppas/sql/9.1_plus/get_oid.sql | 2 +-
.../templates/function/ppas/sql/9.1_plus/node.sql | 5 +
.../function/ppas/sql/9.1_plus/properties.sql | 3 +-
.../function/ppas/sql/9.2_plus/get_oid.sql | 2 +-
.../templates/function/ppas/sql/9.2_plus/node.sql | 5 +
.../function/ppas/sql/9.2_plus/properties.sql | 3 +-
.../function/ppas/sql/9.5_plus/get_oid.sql | 2 +-
.../templates/function/ppas/sql/9.5_plus/node.sql | 5 +
.../function/ppas/sql/9.5_plus/properties.sql | 3 +-
.../procedure/ppas/sql/9.1_plus/get_oid.sql | 2 +-
.../templates/procedure/ppas/sql/9.1_plus/node.sql | 5 +
.../procedure/ppas/sql/9.1_plus/properties.sql | 3 +-
.../procedure/ppas/sql/9.2_plus/get_oid.sql | 2 +-
.../templates/procedure/ppas/sql/9.2_plus/node.sql | 5 +
.../procedure/ppas/sql/9.2_plus/properties.sql | 3 +-
.../procedure/ppas/sql/9.5_plus/get_oid.sql | 2 +-
.../templates/procedure/ppas/sql/9.5_plus/node.sql | 5 +
.../procedure/ppas/sql/9.5_plus/properties.sql | 3 +-
.../trigger_function/pg/sql/9.1_plus/get_oid.sql | 2 +-
.../trigger_function/pg/sql/9.1_plus/node.sql | 5 +
.../pg/sql/9.1_plus/properties.sql | 3 +-
.../trigger_function/pg/sql/9.2_plus/get_oid.sql | 2 +-
.../trigger_function/pg/sql/9.2_plus/node.sql | 7 +-
.../pg/sql/9.2_plus/properties.sql | 3 +-
.../trigger_function/pg/sql/9.5_plus/get_oid.sql | 2 +-
.../trigger_function/pg/sql/9.5_plus/node.sql | 5 +
.../pg/sql/9.5_plus/properties.sql | 3 +-
.../trigger_function/ppas/sql/9.1_plus/get_oid.sql | 2 +-
.../trigger_function/ppas/sql/9.1_plus/node.sql | 5 +
.../ppas/sql/9.1_plus/properties.sql | 3 +-
.../trigger_function/ppas/sql/9.2_plus/get_oid.sql | 2 +-
.../trigger_function/ppas/sql/9.2_plus/node.sql | 5 +
.../ppas/sql/9.2_plus/properties.sql | 3 +-
.../trigger_function/ppas/sql/9.5_plus/get_oid.sql | 2 +-
.../trigger_function/ppas/sql/9.5_plus/node.sql | 5 +
.../ppas/sql/9.5_plus/properties.sql | 3 +-
.../servers/databases/schemas/packages/__init__.py | 230 +++---
.../schemas/packages/edbfuncs/__init__.py | 27 +-
.../templates/edbfunc/ppas/9.1_plus/node.sql | 8 +-
.../templates/edbfunc/ppas/9.2_plus/node.sql | 7 +-
.../templates/edbproc/ppas/9.1_plus/node.sql | 7 +-
.../templates/edbproc/ppas/9.2_plus/node.sql | 7 +-
.../databases/schemas/packages/edbvars/__init__.py | 8 +-
.../edbvars/templates/edbvar/ppas/node.sql | 3 +
.../databases/schemas/sequences/__init__.py | 162 ++--
.../templates/sequence/sql/9.1_plus/get_oid.sql | 8 +-
.../templates/sequence/sql/9.1_plus/nodes.sql | 13 +-
.../servers/databases/schemas/tables/__init__.py | 50 +-
.../databases/schemas/tables/column/__init__.py | 139 ++--
.../schemas/tables/constraints/__init__.py | 14 +-
.../constraints/check_constraint/__init__.py | 240 ++++--
.../constraints/exclusion_constraint/__init__.py | 235 ++++--
.../js/exclusion_constraint.js | 3 -
.../tables/constraints/foreign_key/__init__.py | 275 ++++---
.../constraints/index_constraint/__init__.py | 167 ++--
.../databases/schemas/tables/indexes/__init__.py | 96 ++-
.../databases/schemas/tables/rules/__init__.py | 114 +--
.../tables/templates/column/sql/9.1_plus/nodes.sql | 8 +-
.../tables/templates/column/sql/9.2_plus/nodes.sql | 8 +-
.../schemas/tables/templates/rules/sql/nodes.sql | 13 +
.../table/sql/9.1_plus/get_schema_oid.sql | 9 +
.../table/sql/9.5_plus/get_schema_oid.sql | 9 +
.../databases/schemas/tables/triggers/__init__.py | 80 +-
.../servers/databases/schemas/types/__init__.py | 105 ++-
.../types/templates/type/sql/9.1_plus/nodes.sql | 3 +
.../servers/databases/schemas/views/__init__.py | 566 ++++++-------
.../databases/schemas/views/children/__init__.py | 11 +
.../schemas/views/templates/mview/js/mview.js | 6 +-
.../templates/mview/pg/9.3_plus/sql/get_oid.sql | 9 +
.../templates/mview/pg/9.3_plus/sql/nodes.sql | 13 +
.../templates/mview/pg/9.4_plus/sql/get_oid.sql | 9 +
.../templates/mview/pg/9.4_plus/sql/nodes.sql | 13 +
.../templates/mview/ppas/9.3_plus/sql/get_oid.sql | 9 +
.../templates/mview/ppas/9.3_plus/sql/nodes.sql | 13 +
.../schemas/views/templates/view/js/view.js | 6 +-
.../templates/view/pg/9.1_plus/sql/get_oid.sql | 9 +
.../views/templates/view/pg/9.1_plus/sql/nodes.sql | 13 +
.../templates/view/pg/9.2_plus/sql/get_oid.sql | 9 +
.../views/templates/view/pg/9.2_plus/sql/nodes.sql | 13 +
.../templates/view/pg/9.3_plus/sql/get_oid.sql | 9 +
.../views/templates/view/pg/9.3_plus/sql/nodes.sql | 13 +
.../templates/view/pg/9.4_plus/sql/get_oid.sql | 9 +
.../views/templates/view/pg/9.4_plus/sql/nodes.sql | 13 +
.../templates/view/ppas/9.1_plus/sql/get_oid.sql | 9 +
.../templates/view/ppas/9.1_plus/sql/nodes.sql | 13 +
.../templates/view/ppas/9.2_plus/sql/get_oid.sql | 9 +
.../templates/view/ppas/9.2_plus/sql/nodes.sql | 13 +
.../templates/view/ppas/9.3_plus/sql/get_oid.sql | 9 +
.../templates/view/ppas/9.3_plus/sql/nodes.sql | 13 +
.../templates/view/ppas/9.4_plus/sql/get_oid.sql | 9 +
.../templates/view/ppas/9.4_plus/sql/nodes.sql | 13 +
.../servers/resource_groups/__init__.py | 130 +--
.../templates/resource_groups/sql/nodes.sql | 6 +
.../server_groups/servers/tablespaces/__init__.py | 86 +-
.../servers/templates/servers/servers.js | 3 +
.../browser/templates/browser/js/browser.js | 881 ++++++++++++++++++++-
.../browser/templates/browser/js/collection.js | 3 +-
.../browser/templates/browser/js/messages.js | 2 +-
web/pgadmin/browser/templates/browser/js/node.js | 332 ++------
web/pgadmin/misc/depends/static/js/depends.js | 16 +-
web/pgadmin/misc/sql/static/js/sql.js | 13 +-
.../misc/statistics/static/js/statistics.js | 20 +-
web/pgadmin/static/js/pgadmin.js | 46 ++
156 files changed, 5363 insertions(+), 3464 deletions(-)