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