def handler(self, data):
database.connect()
clientID = data['clientID']
try:
client = Client.get(Client.id == clientID)
except DoesNotExist:
print("Client does not exist")
return
for userID in client.subscriber_list:
user = User.get(User.id == userID)
if data['status']:
email = {
"dst":
user.email,
"subject":
"high {}".format(clientID),
"msg":
"Client {} has high value readings, which indicates bad air quality."
.format(clientID)
}
else:
email = {
"dst": user.email,
"subject": "low {}".format(clientID),
"msg":
"Client {} readings has gone normal.".format(clientID)
}
sendQueue("mail", json.dumps(email))
email['dst'] = user.phone
sendQueue("sms", json.dumps(email))
database.close()
def joinAllPrivateRooms(user):
database.connect()
clients = (Client.select().where((Client.owner == user)
& (Client.private)))
for client in clients:
socketio.join_room("client_{}".format(client.id))
database.close()
def handler(self, data):
clientID = data['clientID']
database.connect()
client = Client.get(Client.id == clientID)
with database.atomic():
LastEvent.delete().where(LastEvent.client_id == client).execute()
Event.delete().where(Event.client_id == client).execute()
client.delete_instance()
database.close()
def getRecentPrivate(user):
database.connect()
last_events = (LastEvent.select(LastEvent, Event, Client).join(Event).join(
Client).where((Event.timestamp >= timeSubtract(minutes=15))
& (Client.owner == user)))
response = [
last_event.event_id.toFrontendObject(include_geo=True)
for last_event in last_events
]
database.close()
return response
def deinitDatabase(_):
if 'hasdb' in g:
database.close()
del g.hasdb