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()
