def sql_load(sql, signal_id = None, order_by = None):
Signal.sql_create(sql)
if signal_id != None:
sql.execute("SELECT id, dev_name, name, vendor, description, delay "
"FROM signals WHERE id=? LIMIT 0,1", (signal_id,))
else:
if order_by == None: order_by = "name"
sql.execute("SELECT id, dev_name, name, vendor, description, delay "
"FROM signals ORDER BY ?", (order_by,))
result = sql.fetchall()
if signal_id != None and len(result) == 0:
raise Exception("Could not find signal id \"%s\"" % signal_id)
return None
signals = []
for data in result:
signal = Signal()
signal.id = get_value(data[0], "id", int, optional = True)
signal.dev_name = get_value(data[1], "dev_name", str, optional = True)
signal.name = get_value(data[2], "name", str, optional = True)
signal.vendor = get_value(data[3], "vendor", str, optional = True)
signal.description = get_value(data[4], "description", str, optional = True)
signal.delay = get_value(data[5], "delay", int, optional = True)
for e in Event.sql_load(sql, signal_id = signal.id):
signal.add_event(e)
if signal_id != None: return signal
signals.append(signal)
return signals
