import sqlite3,json
ids=['41222120-fb41-4fb1-ad14-c8a873b9a0a4','9209fbfd-38c5-4b8c-bddb-745934197ce7','adc7afba-6db2-4871-b290-af785cfea824','b08a26eb-05a8-452c-853d-ff6f54f8ad42','c8a6ae27-9202-4393-a998-809f61a4ad06','6c6af3da-6368-4be6-87e3-b817dbdc6117','ee60e889-b69e-4551-91de-e2e8c3bc50bf','3347c2ed-4191-43d4-88e0-4617266d7b3a','919a871d-7de7-4335-897f-1e0411b87c42','50bcc526-4d5e-4f38-b20e-9143cfcccbde']
c=sqlite3.connect('file:/var/lib/sma-data/signals.db?mode=ro',uri=True); c.row_factory=sqlite3.Row
rows=[]
for sid in ids:
 r=c.execute('select signal_id,topic,source_type,source_name,image_url,image_source,image_found,cached_image_path,observed_at from signals where signal_id=?',(sid,)).fetchone(); rows.append(dict(r) if r else {'signal_id':sid})
c.close(); print(json.dumps(rows,ensure_ascii=False))