def getAllUnitsFromDB():
sql = """
SELECT units_run.lastValue,
units_run.id,
units_run.unid,
units_run.setid,
units_run.lastTime,
units_run.needSetValue,
units_run.name,
units_def.description,
units_def.units,
units_def.direction,
units_def.valueType,
units_def.timeout
FROM `units_run`
LEFT OUTER JOIN units_def ON units_def.unid = units_run.unid
"""
#print(sql)
data = DB.sqlSelect(sql)
if len(data) == 0:
print("NOTE: No any devices where registed yet!")
else:
for row in data:
unid = row['unid']
setid = row['setid']
device = Device(unid, setid, None, False)
device.id = row['id']
device.lastTime = row['lastTime']
device.lastValue = row['lastValue']
device.needSetValue = int(row['needSetValue']) == 1
device.name = row['name']
device.desc = row['description']
device.units = row['units']
device.valueType = row['valueType']
device.direction = row['direction']
device.timeout = row['timeout']
allId = unid + '' + setid
device.isOnline = False
SocketWrap.allUnits[allId] = device
