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 <khushboo.va...@enterprisedb.com> 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(-)
