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