pgAdmin 4 commit: Function and procedure support for PG11. Fixes #3362

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgAdmin 4 commit: Function and procedure support for PG11. Fixes #3362

Dave Page-7
Function and procedure support for PG11. Fixes #3362

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=d1ecba56b8d6c70de4e48b344e1d1e56561bbdfe
Author: Khushboo Vashi <[hidden email]>

Modified Files
--------------
docs/en_US/procedure_dialog.rst                    |  13 ++-
docs/en_US/release_notes_3_1.rst                   |   5 +-
.../databases/schemas/functions/__init__.py        |  10 +-
.../schemas/functions/static/js/procedure.js       |  19 ++--
.../function/pg/sql/11_plus/coll_stats.sql         |  20 ++++
.../templates/function/pg/sql/11_plus/create.sql   |  70 ++++++++++++
.../templates/function/pg/sql/11_plus/delete.sql   |  21 ++++
.../function/pg/sql/11_plus/get_definition.sql     |  15 +++
.../templates/function/pg/sql/11_plus/get_oid.sql  |  17 +++
.../templates/function/pg/sql/11_plus/node.sql     |  22 ++++
.../function/pg/sql/11_plus/properties.sql         |  33 ++++++
.../templates/function/pg/sql/11_plus/update.sql   | 116 ++++++++++++++++++++
.../function/ppas/sql/9.2_plus/create.sql          |   2 +-
.../templates/procedure/pg/sql/default/acl.sql     |  35 ++++++
.../procedure/pg/sql/default/coll_stats.sql        |  20 ++++
.../templates/procedure/pg/sql/default/create.sql  |  50 +++++++++
.../templates/procedure/pg/sql/default/delete.sql  |  21 ++++
.../procedure/pg/sql/default/get_definition.sql    |  15 +++
.../procedure/pg/sql/default/get_languages.sql     |   4 +
.../templates/procedure/pg/sql/default/get_oid.sql |  17 +++
.../procedure/pg/sql/default/get_out_types.sql     |   6 ++
.../procedure/pg/sql/default/get_schema.sql        |   6 ++
.../procedure/pg/sql/default/get_types.sql         |  20 ++++
.../templates/procedure/pg/sql/default/node.sql    |  29 +++++
.../procedure/pg/sql/default/properties.sql        |  39 +++++++
.../templates/procedure/pg/sql/default/stats.sql   |   8 ++
.../templates/procedure/pg/sql/default/update.sql  | 106 ++++++++++++++++++
.../procedure/pg/sql/default/variables.sql         |   6 ++
.../trigger_function/pg/sql/11_plus/coll_stats.sql |  20 ++++
.../trigger_function/pg/sql/11_plus/create.sql     |  57 ++++++++++
.../trigger_function/pg/sql/11_plus/delete.sql     |  21 ++++
.../pg/sql/11_plus/get_definition.sql              |  15 +++
.../trigger_function/pg/sql/11_plus/get_oid.sql    |  18 ++++
.../trigger_function/pg/sql/11_plus/node.sql       |  23 ++++
.../trigger_function/pg/sql/11_plus/properties.sql |  33 ++++++
.../trigger_function/pg/sql/11_plus/update.sql     | 109 +++++++++++++++++++
.../schemas/functions/tests/test_function_add.py   |  80 ++++++++++++++
.../functions/tests/test_function_delete.py        |  49 +++++++++
.../schemas/functions/tests/test_function_get.py   |  49 +++++++++
.../schemas/functions/tests/test_function_put.py   |  57 ++++++++++
.../schemas/functions/tests/test_procedure_add.py  |  90 ++++++++++++++++
.../functions/tests/test_procedure_delete.py       |  56 ++++++++++
.../schemas/functions/tests/test_procedure_get.py  |  55 ++++++++++
.../schemas/functions/tests/test_procedure_put.py  |  62 +++++++++++
.../functions/tests/test_trigger_func_add.py       |  43 ++------
.../functions/tests/test_trigger_func_delete.py    |  48 ++-------
.../functions/tests/test_trigger_func_get.py       |  51 +++------
.../functions/tests/test_trigger_func_put.py       |  58 +++-------
.../databases/schemas/functions/tests/utils.py     | 120 +++++++++++++++++++++
web/pgadmin/browser/utils.py                       |   7 +-
web/pgadmin/tools/debugger/__init__.py             |  18 +++-
.../templates/debugger/sql/execute_plpgsql.sql     |   4 +-
.../debugger/sql/get_function_debug_info.sql       |   8 +-
web/pgadmin/utils/versioned_template_loader.py     |   3 +-
54 files changed, 1717 insertions(+), 182 deletions(-)