def checkers_initials(row, log: ResultLog):
"""Confirm that checker initials are records"""
phase = row.phase
if phase == "inactive": return
target_date = row.targetDateEt.to_pydatetime()
checked_at = row.lastCheckEt.to_pydatetime()
if checked_at <= START_OF_TIME: return
is_near_release = phase in ["publish", "update"]
checker = row.checker.strip()
doubleChecker = row.doubleChecker.strip()
delta_hours = (target_date - checked_at).total_seconds() / (60.0 * 60.0)
if checker == "":
if 0 < delta_hours < 5:
s_checked = checked_at.strftime('%m/%d %H:%M')
log.error(row.state, f"missing checker initials but checked date set recently (at {s_checked})")
elif is_near_release:
log.error(row.state, f"missing checker initials")
else:
log.info(row.state, f"missing checker initials")
return
if doubleChecker == "":
if is_near_release:
log.error(row.state, f"missing double-checker initials")
else:
log.info(row.state, f"Missing double-checker initials")
return
def last_checked(row, log: ResultLog):
"""Data was checked within a reasonable timeframe"""
target_date = row.targetDateEt.to_pydatetime()
updated_at = row.lastUpdateEt.to_pydatetime()
checked_at = row.lastCheckEt.to_pydatetime()
if checked_at <= START_OF_TIME:
phase = row.phase
if phase == "inactive":
pass
elif phase in ["publish", "update"]:
log.error(row.state, f"check needed")
elif phase in ["prepare", "cleanup"]:
log.info(row.state, f"check needed")
return
delta = updated_at - checked_at
hours = delta.total_seconds() / (60.0 * 60)
if hours > 2.0:
s_updated = updated_at.strftime('%m/%d %H:%M')
s_checked = checked_at.strftime('%m/%d %H:%M')
log.error(row.state, f"updated since last check: {hours:.0f} hours ago at {s_updated}, checked at {s_checked}")
return
delta = target_date - updated_at
hours = delta.total_seconds() / (60.0 * 60)
if hours > 12.0:
s_checked = checked_at.strftime('%m/%d %H:%M')
log.warning(row.state, f"source has not been checked in {hours:.0f} hours at {s_checked}")
return