Implementation of View & Materialized View
Branch
------
master
Details
-------
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ecde42cbed4f8238c3bbfe945e26da9f6eefdb79
Author: Surinder Kumar <surinder.kumar@enterprisedb.com>
Modified Files
--------------
.../servers/databases/schemas/views/__init__.py | 1471 ++++++++++++++++++++
.../databases/schemas/views/children/__init__.py | 12 +
.../schemas/views/static/img/coll-mview.png | Bin 0 -> 374 bytes
.../schemas/views/static/img/coll-view.png | Bin 0 -> 418 bytes
.../databases/schemas/views/static/img/mview.png | Bin 0 -> 344 bytes
.../databases/schemas/views/static/img/view.png | Bin 0 -> 437 bytes
.../schemas/views/templates/mview/css/mview.css | 12 +
.../schemas/views/templates/mview/js/mview.js | 313 +++++
.../views/templates/mview/pg/9.3_plus/sql/acl.sql | 41 +
.../templates/mview/pg/9.3_plus/sql/create.sql | 41 +
.../templates/mview/pg/9.3_plus/sql/delete.sql | 13 +
.../templates/mview/pg/9.3_plus/sql/get_schema.sql | 7 +
.../mview/pg/9.3_plus/sql/get_view_name.sql | 11 +
.../templates/mview/pg/9.3_plus/sql/grant.sql | 6 +
.../templates/mview/pg/9.3_plus/sql/properties.sql | 111 ++
.../templates/mview/pg/9.3_plus/sql/refresh.sql | 4 +
.../templates/mview/pg/9.3_plus/sql/update.sql | 216 +++
.../templates/mview/pg/9.3_plus/sql/view_id.sql | 4 +
.../templates/mview/ppas/9.3_plus/sql/acl.sql | 41 +
.../templates/mview/ppas/9.3_plus/sql/create.sql | 47 +
.../templates/mview/ppas/9.3_plus/sql/delete.sql | 13 +
.../mview/ppas/9.3_plus/sql/get_schema.sql | 7 +
.../mview/ppas/9.3_plus/sql/get_view_name.sql | 11 +
.../templates/mview/ppas/9.3_plus/sql/grant.sql | 6 +
.../mview/ppas/9.3_plus/sql/properties.sql | 111 ++
.../templates/mview/ppas/9.3_plus/sql/refresh.sql | 4 +
.../templates/mview/ppas/9.3_plus/sql/update.sql | 179 +++
.../templates/mview/ppas/9.3_plus/sql/view_id.sql | 4 +
.../schemas/views/templates/view/css/view.css | 12 +
.../schemas/views/templates/view/js/view.js | 267 ++++
.../views/templates/view/pg/9.1_plus/sql/acl.sql | 51 +
.../templates/view/pg/9.1_plus/sql/create.sql | 20 +
.../templates/view/pg/9.1_plus/sql/delete.sql | 13 +
.../templates/view/pg/9.1_plus/sql/get_schema.sql | 7 +
.../views/templates/view/pg/9.1_plus/sql/grant.sql | 6 +
.../templates/view/pg/9.1_plus/sql/properties.sql | 69 +
.../templates/view/pg/9.1_plus/sql/update.sql | 67 +
.../templates/view/pg/9.1_plus/sql/view_id.sql | 4 +
.../views/templates/view/pg/9.2_plus/sql/acl.sql | 52 +
.../templates/view/pg/9.2_plus/sql/create.sql | 24 +
.../templates/view/pg/9.2_plus/sql/delete.sql | 13 +
.../templates/view/pg/9.2_plus/sql/get_schema.sql | 7 +
.../views/templates/view/pg/9.2_plus/sql/grant.sql | 6 +
.../templates/view/pg/9.2_plus/sql/properties.sql | 71 +
.../templates/view/pg/9.2_plus/sql/update.sql | 75 +
.../templates/view/pg/9.2_plus/sql/view_id.sql | 4 +
.../views/templates/view/pg/9.3_plus/sql/acl.sql | 38 +
.../templates/view/pg/9.3_plus/sql/create.sql | 23 +
.../templates/view/pg/9.3_plus/sql/delete.sql | 13 +
.../templates/view/pg/9.3_plus/sql/get_schema.sql | 7 +
.../views/templates/view/pg/9.3_plus/sql/grant.sql | 6 +
.../templates/view/pg/9.3_plus/sql/properties.sql | 74 +
.../templates/view/pg/9.3_plus/sql/update.sql | 75 +
.../templates/view/pg/9.3_plus/sql/view_id.sql | 4 +
.../views/templates/view/pg/9.4_plus/sql/acl.sql | 39 +
.../templates/view/pg/9.4_plus/sql/create.sql | 22 +
.../templates/view/pg/9.4_plus/sql/delete.sql | 13 +
.../templates/view/pg/9.4_plus/sql/get_schema.sql | 7 +
.../views/templates/view/pg/9.4_plus/sql/grant.sql | 6 +
.../templates/view/pg/9.4_plus/sql/properties.sql | 77 +
.../templates/view/pg/9.4_plus/sql/update.sql | 81 ++
.../templates/view/pg/9.4_plus/sql/view_id.sql | 4 +
.../views/templates/view/ppas/9.1_plus/sql/acl.sql | 39 +
.../templates/view/ppas/9.1_plus/sql/create.sql | 20 +
.../templates/view/ppas/9.1_plus/sql/delete.sql | 13 +
.../view/ppas/9.1_plus/sql/get_schema.sql | 7 +
.../templates/view/ppas/9.1_plus/sql/grant.sql | 6 +
.../view/ppas/9.1_plus/sql/properties.sql | 76 +
.../templates/view/ppas/9.1_plus/sql/update.sql | 75 +
.../templates/view/ppas/9.1_plus/sql/view_id.sql | 4 +
.../views/templates/view/ppas/9.2_plus/sql/acl.sql | 52 +
.../templates/view/ppas/9.2_plus/sql/create.sql | 23 +
.../templates/view/ppas/9.2_plus/sql/delete.sql | 13 +
.../view/ppas/9.2_plus/sql/get_schema.sql | 7 +
.../templates/view/ppas/9.2_plus/sql/grant.sql | 6 +
.../view/ppas/9.2_plus/sql/properties.sql | 70 +
.../templates/view/ppas/9.2_plus/sql/update.sql | 75 +
.../templates/view/ppas/9.2_plus/sql/view_id.sql | 4 +
.../views/templates/view/ppas/9.3_plus/sql/acl.sql | 38 +
.../templates/view/ppas/9.3_plus/sql/create.sql | 23 +
.../templates/view/ppas/9.3_plus/sql/delete.sql | 13 +
.../view/ppas/9.3_plus/sql/get_schema.sql | 7 +
.../templates/view/ppas/9.3_plus/sql/grant.sql | 6 +
.../view/ppas/9.3_plus/sql/properties.sql | 74 +
.../templates/view/ppas/9.3_plus/sql/update.sql | 75 +
.../templates/view/ppas/9.3_plus/sql/view_id.sql | 4 +
.../views/templates/view/ppas/9.4_plus/sql/acl.sql | 39 +
.../templates/view/ppas/9.4_plus/sql/create.sql | 22 +
.../templates/view/ppas/9.4_plus/sql/delete.sql | 13 +
.../view/ppas/9.4_plus/sql/get_schema.sql | 7 +
.../templates/view/ppas/9.4_plus/sql/grant.sql | 6 +
.../view/ppas/9.4_plus/sql/properties.sql | 77 +
.../templates/view/ppas/9.4_plus/sql/update.sql | 81 ++
.../templates/view/ppas/9.4_plus/sql/view_id.sql | 4 +
web/pgadmin/static/js/backform.pgadmin.js | 29 +-
95 files changed, 4941 insertions(+), 9 deletions(-)