pgAdmin 4 commit: Implementation of View & Materialized View - Mailing list pgadmin-hackers
| From | Akshay Joshi |
|---|---|
| Subject | pgAdmin 4 commit: Implementation of View & Materialized View |
| Date | |
| Msg-id | E1b3jJW-0003ih-V8@gothos.postgresql.org Whole thread Raw |
| List | pgadmin-hackers |
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(-)
pgadmin-hackers by date: