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