pgAdmin 4 commit: Added RESQL/MSQL test cases for Functions. Fixes #539 - Mailing list pgadmin-hackers
| From | Akshay Joshi |
|---|---|
| Subject | pgAdmin 4 commit: Added RESQL/MSQL test cases for Functions. Fixes #539 |
| Date | |
| Msg-id | E1kPlip-0007lR-R4@gothos.postgresql.org Whole thread Raw |
| List | pgadmin-hackers |
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(-)
pgadmin-hackers by date: