Added job step and job schedule disable icons to identify it quickly within the browser tree. Fixes #4636
Add Reverse Engineered and Modified SQL tests for pgAgent jobs. Fixes #4623
Fixed modified SQL issue while adding an exception in pgAgent job schedule. Fixes #5356
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=07f72252d7a1d59517f2072697856630ed344db4
Author: Neel Patel <neel.patel@enterprisedb.com>
Modified Files
--------------
docs/en_US/release_notes_4_21.rst | 3 +
.../server_groups/servers/pgagent/__init__.py | 8 +-
.../servers/pgagent/schedules/__init__.py | 29 +-
.../schedules/static/img/pga_schedule-disabled.svg | 16 +
.../pgagent/schedules/static/js/pga_schedule.js | 10 +-
.../templates/pga_schedule/css/pga_schedule.css | 18 +
.../servers/pgagent/steps/__init__.py | 12 +-
.../pgagent/steps/static/img/coll-pga_jobstep.svg | 46 +-
.../steps/static/img/pga_jobstep-disabled.svg | 32 ++
.../steps/templates/pga_jobstep/css/pga_step.css | 9 +
.../alter_batch_job_schedule_all_options.sql | 54 +++
.../alter_batch_job_schedule_all_options_msql.sql | 25 +
.../default/alter_batch_job_step_all_options.sql | 33 ++
.../alter_batch_job_step_all_options_msql.sql | 11 +
.../default/alter_job_schedule_all_options.sql | 66 +++
.../alter_job_schedule_all_options_msql.sql | 37 ++
.../alter_job_schedule_remote_db_all_options.sql | 54 +++
...ter_job_schedule_remote_db_all_options_msql.sql | 25 +
.../tests/default/alter_job_step_all_options.sql | 33 ++
.../default/alter_job_step_all_options_msql.sql | 11 +
.../alter_job_step_remote_db_all_options.sql | 33 ++
.../alter_job_step_remote_db_all_options_msql.sql | 11 +
.../tests/default/alter_sql_job_all_options.sql | 24 +
.../default/alter_sql_job_all_options_msql.sql | 3 +
.../default/create_batch_job_with_all_options.sql | 45 ++
.../create_batch_job_with_all_options_msql.sql | 45 ++
.../tests/default/create_batch_job_with_step.sql | 24 +
.../default/create_batch_job_with_step_msql.sql | 24 +
.../create_sql_job_local_db_with_all_options.sql | 57 +++
...eate_sql_job_local_db_with_all_options_msql.sql | 57 +++
.../create_sql_job_remote_db_with_all_options.sql | 45 ++
...ate_sql_job_remote_db_with_all_options_msql.sql | 45 ++
.../default/create_sql_job_step_remote_db.sql | 24 +
.../default/create_sql_job_step_remote_db_msql.sql | 24 +
.../default/create_sql_job_with_step_local_db.sql | 24 +
.../create_sql_job_with_step_local_db_msql.sql | 24 +
.../pgagent/tests/default/test_pgagent.json | 503 +++++++++++++++++++++
.../tests/9.4_plus/alter_login_role_options.sql | 2 +-
.../roles/tests/9.4_plus/alter_role_options.sql | 2 +-
web/pgadmin/static/js/backgrid.pgadmin.js | 10 +-
web/regression/re_sql/tests/test_resql.py | 97 +++-
41 files changed, 1616 insertions(+), 39 deletions(-)