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