def _run_scheduled_monthly_tasks():
""" create thread to execute monthly tasks """
today = datetime.date.today()
if today.day == cfg.MONTHLY_JOB_START_DAY:
worker.add_task(monthly.run)
def _run_scheduled_weekly_tasks():
""" create thread to execute weekly tasks """
worker.add_task(weekly.run)
def put_task_to_actionlog(prev_syscfg):
"""
:type prev_syscfg: pyticas_tetres.ttypes.SystemConfigInfo
"""
da_config = ConfigDataAccess()
syscfg = da_config.get_by_name(cfg.OPT_NAME_SYSCONFIG)
if not syscfg:
getLogger(__name__).warning('Cannot find the updated system configuration from `config` table')
da_config.close_session()
return
should_run_actionlog_handler = False
da_actionlog = ActionLogDataAccess()
is_data_archive_start_year_extended = False
is_data_archive_start_year_shrinked = False
if cfg.DATA_ARCHIVE_START_YEAR != prev_syscfg.data_archive_start_year:
if cfg.DATA_ARCHIVE_START_YEAR < prev_syscfg.data_archive_start_year:
is_data_archive_start_year_extended = True
elif cfg.DATA_ARCHIVE_START_YEAR > prev_syscfg.data_archive_start_year:
is_data_archive_start_year_shrinked = True
# cancled already posted action logs
if is_data_archive_start_year_shrinked or is_data_archive_start_year_extended:
ex_logs = da_actionlog.search(
searches=[('target_datatype', ActionLogDataAccess.DT_SYSTEMCONFIG), ('handled', False)],
op='and',
cond='match',
as_model=True)
for a_log in ex_logs:
a_log.handled = True
a_log.handled_date = datetime.datetime.now()
a_log.status = 'Cancled due to another action'
a_log.status_updated_date = datetime.datetime.now()
da_actionlog.commit()
if is_data_archive_start_year_extended:
should_run_actionlog_handler = True
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'DATA_ARCHIVE_START_YEAR_EXTENDED: %d -> %d' % (
prev_syscfg.data_archive_start_year, cfg.DATA_ARCHIVE_START_YEAR),
handled=False)
elif is_data_archive_start_year_shrinked:
# add log for re-calculation
should_run_actionlog_handler = True
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'DATA_ARCHIVE_START_YEAR_SHRINKED: %d -> %d' % (
prev_syscfg.data_archive_start_year, cfg.DATA_ARCHIVE_START_YEAR),
handled=False)
if (cfg.INCIDENT_DOWNSTREAM_DISTANCE_LIMIT != prev_syscfg.incident_downstream_distance_limit
or cfg.INCIDENT_UPSTREAM_DISTANCE_LIMIT != prev_syscfg.incident_upstream_distance_limit):
should_run_actionlog_handler = True
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
ActionLogDataAccess.DT_INCIDENT,
handled=False)
if (cfg.WZ_DOWNSTREAM_DISTANCE_LIMIT != prev_syscfg.workzone_downstream_distance_limit
or cfg.WZ_UPSTREAM_DISTANCE_LIMIT != prev_syscfg.workzone_upstream_distance_limit):
should_run_actionlog_handler = True
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
ActionLogDataAccess.DT_WORKZONE,
handled=False)
if (cfg.SE_ARRIVAL_WINDOW != prev_syscfg.specialevent_arrival_window
or cfg.SE_DEPARTURE_WINDOW1 != prev_syscfg.specialevent_departure_window1
or cfg.SE_DEPARTURE_WINDOW2 != prev_syscfg.specialevent_departure_window2):
should_run_actionlog_handler = True
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
ActionLogDataAccess.DT_SPECIALEVENT,
handled=False)
# restart scheduler
if (cfg.DAILY_JOB_START_TIME != prev_syscfg.daily_job_start_time
or cfg.DAILY_JOB_OFFSET_DAYS != prev_syscfg.daily_job_offset_days
or cfg.WEEKLY_JOB_START_WEEKDAY != prev_syscfg.weekly_job_start_day
or cfg.WEEKLY_JOB_START_TIME != prev_syscfg.weekly_job_start_time
or cfg.MONTHLY_JOB_START_DAY != prev_syscfg.monthly_job_start_date
or cfg.MONTHLY_JOB_START_TIME != prev_syscfg.monthly_job_start_time):
scheduler.restart()
if cfg.DAILY_JOB_START_TIME != prev_syscfg.daily_job_start_time:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'DAILY_JOB_START_TIME is updated : %s -> %s' % (
prev_syscfg.daily_job_start_time, cfg.DAILY_JOB_START_TIME),
handled=True)
if cfg.DAILY_JOB_OFFSET_DAYS != prev_syscfg.daily_job_offset_days:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'DAILY_JOB_OFFSET_DAYS is updated: %s -> %s' % (
prev_syscfg.daily_job_offset_days, cfg.DAILY_JOB_OFFSET_DAYS),
handled=True)
if cfg.WEEKLY_JOB_START_WEEKDAY != prev_syscfg.weekly_job_start_day:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'WEEKLY_JOB_START_WEEKDAY is updated: %s -> %s' % (
prev_syscfg.weekly_job_start_day, cfg.WEEKLY_JOB_START_WEEKDAY),
handled=True)
if cfg.WEEKLY_JOB_START_TIME != prev_syscfg.weekly_job_start_time:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'WEEKLY_JOB_START_TIME is updated: %s -> %s' % (
prev_syscfg.weekly_job_start_time, cfg.WEEKLY_JOB_START_TIME),
handled=True)
if cfg.MONTHLY_JOB_START_DAY != prev_syscfg.monthly_job_start_date:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'MONTHLY_JOB_START_DAY is updated: %s -> %s' % (
prev_syscfg.monthly_job_start_date, cfg.MONTHLY_JOB_START_DAY),
handled=True)
if cfg.MONTHLY_JOB_START_TIME != prev_syscfg.monthly_job_start_time:
actionlog.add(ActionLogDataAccess.UPDATE,
ActionLogDataAccess.DT_SYSTEMCONFIG,
Config.__tablename__,
syscfg.id,
'MONTHLY_JOB_START_TIME is updated: %s -> %s' % (
prev_syscfg.monthly_job_start_time, cfg.MONTHLY_JOB_START_TIME),
handled=True)
if not should_run_actionlog_handler:
unhandled = da_actionlog.list(target_datatypes=[ActionLogDataAccess.DT_SYSTEMCONFIG], handled=False)
if unhandled:
should_run_actionlog_handler = True
da_actionlog.close_session()
da_config.close_session()
# add actionlog handler to the task queue in the worker process
if should_run_actionlog_handler:
getLogger(__name__).debug('System configurations are updated and the handler process is posted')
worker.add_task(actionlog_proc.run)
else:
getLogger(__name__).debug('System configurations are updated and the handler process is NOT posted')
def _run_scheduled_daily_tasks():
""" execute all daily tasks """
worker.add_task(daily.run)
def tetres_actionlog_proceed():
worker.add_task(actionlog_processor.run)
return prot.response_success()