def get_all(cls, session): """Iterate over all the FSObjects available in the database. """ if cls.__table__.exists(): return session.query(cls) else: return []
def detect_users(): user_addrs = session.query(HHUserBTAddr) addr_list = [u.btaddr for u in user_addrs] ddict = BluetoothDeviceDetector.detect_dict(addr_list) if ddict: for ua in user_addrs: if ua.btaddr in ddcit.keys: x = BluetoothDeviceDetector('BluetoothDeviceDetect', ua.btaddr, ddict[ua.btaddr] ) session.add(x) session.commit()
def getEventType(tbl): return session.query(EventType) \ .join(EventFamily) \ .filter(EventType.name == tbl) \ .filter(EventFamily.name == 'macquarium') \ .first()
def getEventType(tbl): return session.query(EventType) \ .join(EventFamily) \ .filter(EventType.name == __tablename__) \ .filter(EventFamily.name == 'door') \ .first()