pgAdmin 4 commit: Added RESQL/MSQL test cases for Functions. Fixes #539

Added RESQL/MSQL test cases for Functions. Fixes #5395

Initial patch sent by Nikhil Mohite.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6c4049f29a36e2193aca786c5f7db5c2fe997939

Modified Files
--------------
docs/en_US/release_notes_4_27.rst | 1 +
.../templates/functions/pg/sql/11_plus/create.sql | 69 ------
.../templates/functions/pg/sql/12_plus/create.sql | 11 +-
.../templates/functions/pg/sql/9.6_plus/create.sql | 7 +-
.../functions/ppas/sql/12_plus/create.sql | 23 +-
.../functions/ppas/sql/9.6_plus/create.sql | 19 +-
.../functions/ppas/sql/9.6_plus/properties.sql | 35 +++
.../templates/functions/ppas/sql/default/acl.sql | 3 +-
.../tests/pg/11_plus/alter_function_add_acl.msql | 1 +
.../tests/pg/11_plus/alter_function_add_acl.sql | 24 ++
.../pg/11_plus/alter_function_add_parameter.msql | 13 +
.../pg/11_plus/alter_function_add_parameter.sql | 20 ++
.../tests/pg/11_plus/alter_function_comment.msql | 2 +
.../tests/pg/11_plus/alter_function_comment.sql | 22 ++
.../pg/11_plus/alter_function_delete_acl.msql | 3 +
.../tests/pg/11_plus/alter_function_delete_acl.sql | 19 ++
.../11_plus/alter_function_delete_parameter.msql | 2 +
.../pg/11_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/pg/11_plus/alter_function_rename.msql | 2 +
.../tests/pg/11_plus/alter_function_rename.sql | 19 ++
.../tests/pg/11_plus/create_function.msql | 14 ++
.../functions/tests/pg/11_plus/create_function.sql | 20 ++
.../pg/11_plus/create_function_for_alter.msql | 14 ++
.../tests/pg/11_plus/create_function_for_alter.sql | 19 ++
.../functions/tests/pg/11_plus/test_function.json | 260 ++++++++++++++++++++
.../tests/pg/12_plus/alter_function_add_acl.msql | 1 +
.../tests/pg/12_plus/alter_function_add_acl.sql | 24 ++
.../pg/12_plus/alter_function_add_parameter.msql | 14 ++
.../pg/12_plus/alter_function_add_parameter.sql | 20 ++
.../tests/pg/12_plus/alter_function_comment.msql | 2 +
.../tests/pg/12_plus/alter_function_comment.sql | 22 ++
.../pg/12_plus/alter_function_delete_acl.msql | 3 +
.../tests/pg/12_plus/alter_function_delete_acl.sql | 19 ++
.../12_plus/alter_function_delete_parameter.msql | 2 +
.../pg/12_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/pg/12_plus/alter_function_rename.msql | 2 +
.../tests/pg/12_plus/alter_function_rename.sql | 19 ++
.../tests/pg/12_plus/alter_proc_comment.sql | 15 ++
.../tests/pg/12_plus/alter_proc_comment_msql.sql | 2 +
.../tests/pg/12_plus/alter_proc_param.sql | 16 ++
.../tests/pg/12_plus/alter_proc_param_msql.sql | 2 +
.../tests/pg/12_plus/alter_ptrig_comment.sql | 20 ++
.../tests/pg/12_plus/alter_ptrig_set_1.sql | 20 ++
.../tests/pg/12_plus/alter_ptrig_set_2.sql | 22 ++
.../tests/pg/12_plus/alter_ptrig_set_3.sql | 23 ++
.../tests/pg/12_plus/create_event_trigger_full.sql | 26 ++
.../tests/pg/12_plus/create_function.msql | 14 ++
.../functions/tests/pg/12_plus/create_function.sql | 20 ++
.../pg/12_plus/create_function_for_alter.msql | 14 ++
.../tests/pg/12_plus/create_function_for_alter.sql | 19 ++
.../tests/pg/12_plus/create_plain_trigger.sql | 17 ++
.../tests/pg/12_plus/create_plain_trigger_full.sql | 27 ++
.../tests/pg/12_plus/create_procedure.sql | 12 +
.../functions/tests/pg/12_plus/test_function.json | 260 ++++++++++++++++++++
.../tests/pg/12_plus/test_procedures.json | 58 +++++
.../tests/pg/12_plus/test_trigger_functions.json | 191 +++++++++++++++
.../tests/pg/9.5_plus/alter_function_add_acl.msql | 1 +
.../tests/pg/9.5_plus/alter_function_add_acl.sql | 26 ++
.../pg/9.5_plus/alter_function_add_parameter.msql | 12 +
.../pg/9.5_plus/alter_function_add_parameter.sql | 20 ++
.../tests/pg/9.5_plus/alter_function_comment.msql | 2 +
.../tests/pg/9.5_plus/alter_function_comment.sql | 22 ++
.../pg/9.5_plus/alter_function_delete_acl.msql | 3 +
.../pg/9.5_plus/alter_function_delete_acl.sql | 19 ++
.../9.5_plus/alter_function_delete_parameter.msql | 2 +
.../9.5_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/pg/9.5_plus/alter_function_rename.msql | 2 +
.../tests/pg/9.5_plus/alter_function_rename.sql | 19 ++
.../tests/pg/9.5_plus/alter_ptrig_comment.sql | 20 ++
.../tests/pg/9.5_plus/alter_ptrig_set_1.sql | 20 ++
.../tests/pg/9.5_plus/alter_ptrig_set_2.sql | 22 ++
.../tests/pg/9.5_plus/alter_ptrig_set_3.sql | 23 ++
.../pg/9.5_plus/create_event_trigger_full.sql | 26 ++
.../tests/pg/9.5_plus/create_function.msql | 14 ++
.../tests/pg/9.5_plus/create_function.sql | 20 ++
.../pg/9.5_plus/create_function_for_alter.msql | 14 ++
.../pg/9.5_plus/create_function_for_alter.sql | 19 ++
.../tests/pg/9.5_plus/create_plain_trigger.sql | 17 ++
.../pg/9.5_plus/create_plain_trigger_full.sql | 27 ++
.../functions/tests/pg/9.5_plus/test_function.json | 259 ++++++++++++++++++++
.../tests/pg/9.5_plus/test_trigger_functions.json | 191 +++++++++++++++
.../tests/pg/9.6_plus/alter_function_add_acl.msql | 1 +
.../tests/pg/9.6_plus/alter_function_add_acl.sql | 24 ++
.../pg/9.6_plus/alter_function_add_parameter.msql | 13 +
.../pg/9.6_plus/alter_function_add_parameter.sql | 20 ++
.../tests/pg/9.6_plus/alter_function_comment.msql | 2 +
.../tests/pg/9.6_plus/alter_function_comment.sql | 22 ++
.../pg/9.6_plus/alter_function_delete_acl.msql | 3 +
.../pg/9.6_plus/alter_function_delete_acl.sql | 19 ++
.../9.6_plus/alter_function_delete_parameter.msql | 2 +
.../9.6_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/pg/9.6_plus/alter_function_rename.msql | 2 +
.../tests/pg/9.6_plus/alter_function_rename.sql | 19 ++
.../tests/pg/9.6_plus/alter_ptrig_comment.sql | 20 ++
.../tests/pg/9.6_plus/alter_ptrig_set_1.sql | 20 ++
.../tests/pg/9.6_plus/alter_ptrig_set_2.sql | 22 ++
.../tests/pg/9.6_plus/alter_ptrig_set_3.sql | 23 ++
.../pg/9.6_plus/create_event_trigger_full.sql | 26 ++
.../tests/pg/9.6_plus/create_function.msql | 14 ++
.../tests/pg/9.6_plus/create_function.sql | 20 ++
.../pg/9.6_plus/create_function_for_alter.msql | 14 ++
.../pg/9.6_plus/create_function_for_alter.sql | 19 ++
.../tests/pg/9.6_plus/create_plain_trigger.sql | 17 ++
.../pg/9.6_plus/create_plain_trigger_full.sql | 27 ++
.../functions/tests/pg/9.6_plus/test_function.json | 260 ++++++++++++++++++++
.../tests/pg/9.6_plus/test_trigger_functions.json | 191 +++++++++++++++
.../tests/ppas/11_plus/alter_function_add_acl.msql | 3 +
.../tests/ppas/11_plus/alter_function_add_acl.sql | 24 ++
.../ppas/11_plus/alter_function_add_parameter.msql | 13 +
.../ppas/11_plus/alter_function_add_parameter.sql | 20 ++
.../tests/ppas/11_plus/alter_function_comment.msql | 2 +
.../tests/ppas/11_plus/alter_function_comment.sql | 22 ++
.../ppas/11_plus/alter_function_delete_acl.msql | 3 +
.../ppas/11_plus/alter_function_delete_acl.sql | 19 ++
.../11_plus/alter_function_delete_parameter.msql | 2 +
.../11_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/ppas/11_plus/alter_function_rename.msql | 2 +
.../tests/ppas/11_plus/alter_function_rename.sql | 19 ++
.../tests/ppas/11_plus/create_function.msql | 14 ++
.../tests/ppas/11_plus/create_function.sql | 19 ++
.../ppas/11_plus/create_function_for_alter.msql | 14 ++
.../ppas/11_plus/create_function_for_alter.sql | 19 ++
.../tests/ppas/11_plus/test_function.json | 272 +++++++++++++++++++++
.../tests/ppas/12_plus/alter_function_add_acl.msql | 3 +
.../tests/ppas/12_plus/alter_function_add_acl.sql | 24 ++
.../ppas/12_plus/alter_function_add_parameter.msql | 13 +
.../ppas/12_plus/alter_function_add_parameter.sql | 20 ++
.../tests/ppas/12_plus/alter_function_comment.msql | 2 +
.../tests/ppas/12_plus/alter_function_comment.sql | 22 ++
.../ppas/12_plus/alter_function_delete_acl.msql | 3 +
.../ppas/12_plus/alter_function_delete_acl.sql | 19 ++
.../12_plus/alter_function_delete_parameter.msql | 2 +
.../12_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/ppas/12_plus/alter_function_rename.msql | 2 +
.../tests/ppas/12_plus/alter_function_rename.sql | 19 ++
.../tests/ppas/12_plus/alter_proc_comment.sql | 15 ++
.../tests/ppas/12_plus/alter_proc_comment_msql.sql | 2 +
.../tests/ppas/12_plus/alter_proc_param.sql | 16 ++
.../tests/ppas/12_plus/alter_proc_param_msql.sql | 2 +
.../tests/ppas/12_plus/alter_ptrig_comment.sql | 20 ++
.../tests/ppas/12_plus/alter_ptrig_set_1.sql | 20 ++
.../tests/ppas/12_plus/alter_ptrig_set_2.sql | 22 ++
.../tests/ppas/12_plus/alter_ptrig_set_3.sql | 23 ++
.../ppas/12_plus/create_event_trigger_full.sql | 26 ++
.../tests/ppas/12_plus/create_function.msql | 14 ++
.../tests/ppas/12_plus/create_function.sql | 19 ++
.../ppas/12_plus/create_function_for_alter.msql | 14 ++
.../ppas/12_plus/create_function_for_alter.sql | 19 ++
.../tests/ppas/12_plus/create_plain_trigger.sql | 17 ++
.../ppas/12_plus/create_plain_trigger_full.sql | 27 ++
.../tests/ppas/12_plus/create_procedure.sql | 12 +
.../tests/ppas/12_plus/test_function.json | 272 +++++++++++++++++++++
.../tests/ppas/12_plus/test_procedures.json | 58 +++++
.../tests/ppas/12_plus/test_trigger_functions.json | 191 +++++++++++++++
.../ppas/9.5_plus/alter_function_add_acl.msql | 3 +
.../tests/ppas/9.5_plus/alter_function_add_acl.sql | 24 ++
.../9.5_plus/alter_function_add_parameter.msql | 13 +
.../ppas/9.5_plus/alter_function_add_parameter.sql | 20 ++
.../ppas/9.5_plus/alter_function_comment.msql | 2 +
.../tests/ppas/9.5_plus/alter_function_comment.sql | 22 ++
.../ppas/9.5_plus/alter_function_delete_acl.msql | 3 +
.../ppas/9.5_plus/alter_function_delete_acl.sql | 19 ++
.../9.5_plus/alter_function_delete_parameter.msql | 2 +
.../9.5_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/ppas/9.5_plus/alter_function_rename.msql | 2 +
.../tests/ppas/9.5_plus/alter_function_rename.sql | 19 ++
.../tests/ppas/9.5_plus/create_function.msql | 14 ++
.../tests/ppas/9.5_plus/create_function.sql | 19 ++
.../ppas/9.5_plus/create_function_for_alter.msql | 14 ++
.../ppas/9.5_plus/create_function_for_alter.sql | 19 ++
.../tests/ppas/9.5_plus/test_function.json | 271 ++++++++++++++++++++
.../ppas/9.6_plus/alter_function_add_acl.msql | 3 +
.../tests/ppas/9.6_plus/alter_function_add_acl.sql | 24 ++
.../9.6_plus/alter_function_add_parameter.msql | 13 +
.../ppas/9.6_plus/alter_function_add_parameter.sql | 20 ++
.../ppas/9.6_plus/alter_function_comment.msql | 2 +
.../tests/ppas/9.6_plus/alter_function_comment.sql | 22 ++
.../ppas/9.6_plus/alter_function_delete_acl.msql | 3 +
.../ppas/9.6_plus/alter_function_delete_acl.sql | 19 ++
.../9.6_plus/alter_function_delete_parameter.msql | 2 +
.../9.6_plus/alter_function_delete_parameter.sql | 19 ++
.../tests/ppas/9.6_plus/alter_function_rename.msql | 2 +
.../tests/ppas/9.6_plus/alter_function_rename.sql | 19 ++
.../tests/ppas/9.6_plus/create_function.msql | 14 ++
.../tests/ppas/9.6_plus/create_function.sql | 19 ++
.../ppas/9.6_plus/create_function_for_alter.msql | 14 ++
.../ppas/9.6_plus/create_function_for_alter.sql | 19 ++
.../tests/ppas/9.6_plus/test_function.json | 272 +++++++++++++++++++++
188 files changed, 5504 insertions(+), 94 deletions(-)