Fix syntax error when creating new pgAgent schedules with a start date/time and exception. Fixes #3638
- Fixed syntax error. - Update/Delete exceptions are not working, SQL is wrong. - Wrong exception time is shown, it should shown in UTC as datatype of the column is timestamp with out timezone. - Added test cases for Schedule and Steps of pgAgent Job. Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=50738db2b8c871869a37c0b7617687bd4efd9da3 Author: Akshay Joshi <akshay.jo...@enterprisedb.com> Modified Files -------------- .../pgagent/schedules/static/js/pga_schedule.js | 14 +- .../pgagent/templates/macros/pga_exception.macros | 8 +- .../pgagent/templates/macros/pga_schedule.macros | 2 +- .../templates/pga_schedule/sql/pre3.4/create.sql | 6 + .../pgagent/tests/tests_pgagent_add_schedule.py | 80 +++++++ .../pgagent/tests/tests_pgagent_add_steps.py | 69 ++++++ .../pgagent/tests/tests_pgagent_delete_schedule.py | 52 +++++ .../pgagent/tests/tests_pgagent_delete_steps.py | 52 +++++ .../pgagent/tests/tests_pgagent_put_schedule.py | 131 ++++++++++++ .../pgagent/tests/tests_pgagent_put_step.py | 67 ++++++ .../server_groups/servers/pgagent/tests/utils.py | 235 ++++++++++++++++++++- 11 files changed, 703 insertions(+), 13 deletions(-)