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.joshi@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(-)