def update_alertlog_with_user_response(alert_id, user_response):
""" User response will be recorded to the designated alertlog entry. """
# Function will only be run when user responds.
alertlog_id = most_recent_alertlog_id_given_alert_id(alert_id)
update_alertlog = update(
AlertLog.__table__).where(AlertLog.id == alertlog_id).values({
AlertLog.action_taken:
user_response,
AlertLog.response_timestamp:
datetime.datetime.now(),
AlertLog.updated_at:
datetime.datetime.now()
})
db.session.execute(update_alertlog)
db.session.commit()
return alertlog_id, user_response
def update_alertlog_with_user_response(alert_id, user_response):
""" User response will be recorded to the designated alertlog entry. """
# Function will only be run when user responds.
alertlog_id = most_recent_alertlog_id_given_alert_id(alert_id)
update_alertlog = (
update(AlertLog.__table__)
.where(AlertLog.id == alertlog_id)
.values(
{
AlertLog.action_taken: user_response,
AlertLog.response_timestamp: datetime.datetime.now(),
AlertLog.updated_at: datetime.datetime.now(),
}
)
)
db.session.execute(update_alertlog)
db.session.commit()
return alertlog_id, user_response
def schedule_alert(alert_id, scheduled_alert_datetime, secondary_contact=None):
"""Creates an alertlog entry given alert_id and scheduled_alert_datetime obj from form."""
scheduled_alert = {}
scheduled_alert["alert_id"] = alert_id
scheduled_alert["scheduled_alert_datetime"] = scheduled_alert_datetime
scheduled_alert["alert_issued"] = None
scheduled_alert["created_at"] = datetime.datetime.now()
scheduled_alert["updated_at"] = None
if secondary_contact:
scheduled_alert["recipient"] = "secondary"
else:
scheduled_alert["recipient"] = "primary"
scheduled_alert = AlertLog(**scheduled_alert)
db.session.add(scheduled_alert)
db.session.commit()
# Returns the alertlog_id of scheduled alert.
alertlog_id = most_recent_alertlog_id_given_alert_id(alert_id)
return alertlog_id
def schedule_alert(alert_id, scheduled_alert_datetime, secondary_contact=None):
"""Creates an alertlog entry given alert_id and scheduled_alert_datetime obj from form."""
scheduled_alert = {}
scheduled_alert["alert_id"] = alert_id
scheduled_alert["scheduled_alert_datetime"] = scheduled_alert_datetime
scheduled_alert["alert_issued"] = None
scheduled_alert["created_at"] = datetime.datetime.now()
scheduled_alert["updated_at"] = None
if secondary_contact:
scheduled_alert["recipient"] = "secondary"
else:
scheduled_alert["recipient"] = "primary"
scheduled_alert = AlertLog(**scheduled_alert)
db.session.add(scheduled_alert)
db.session.commit()
# Returns the alertlog_id of scheduled alert.
alertlog_id = most_recent_alertlog_id_given_alert_id(alert_id)
return alertlog_id
