def addNewAlert():
if request.method == 'POST':
dbConnection = DatabaseConnection.getDBCursor()
cursor = dbConnection.cursor()
message = request.form['message']
duration = request.form['duration']
query = "insert into alerts values (%s, %s, 1)"
cursor.execute(query, (message, duration))
dbConnection.commit()
dbConnection.close()
return jsonify({}), 201
def invalidateAlert():
if request.method == 'POST':
dbConnection = DatabaseConnection.getDBCursor()
cursor = dbConnection.cursor()
_id = request.form['id']
print("invalidating alert with id")
print(_id)
query = "update alerts set valid = 0 where id = %s"
cursor.execute(query, (_id,))
dbConnection.commit()
dbConnection.close()
return jsonify({}), 201
def pollNewMessage():
dbConnection = DatabaseConnection.getDBCursor()
cursor = dbConnection.cursor()
query = "select * from alerts order by id desc"
cursor.execute(query,)
result = cursor.fetchone()
dbConnection.close()
if result:
message = result[0]
duration = result[1]
valid = result[2]
_id = result[3]
if valid == 1:
return jsonify({"message": message, "duration": duration, "id": _id}), 200
else:
return jsonify({}), 202
else:
return jsonify({}), 202
