import sys
if sys.path and sys.path[0] == "":
del sys.path[0]
import json
import math
import os
import queue
import signal
import threading
def plain(value):
if value is None or isinstance(value, (bool, int, str)):
return value
if isinstance(value, float):
return value if math.isfinite(value) else str(value)
if isinstance(value, (list, tuple)):
return [plain(item) for item in value]
return str(value)
def main():
replies = os.fdopen(os.dup(1), "wb", buffering=0)
os.dup2(2, 1)
sys.stdout = sys.stderr
signal.signal(signal.SIGINT, signal.SIG_IGN)
lock = threading.Lock()
def reply(message):
line = json.dumps(message, ensure_ascii=True, allow_nan=False).encode("ascii") + b"\n"
with lock:
replies.write(line)
def failed(request, error):
reply({"id": request.get("id"), "ok": False, "error": str(error), "type": type(error).__name__})
database = None
cursors = {}
def serve(work):
cursor = None
while True:
request = work.get()
if request is None:
break
try:
if cursor is None:
cursor = database.cursor()
cursor.execute(request["sql"], request.get("params") or None)
rows = cursor.fetchall() if cursor.description else []
reply({"id": request["id"], "ok": True, "rows": [[plain(value) for value in row] for row in rows]})
except BaseException as error: failed(request, error)
if cursor is not None:
cursor.close()
for line in sys.stdin.buffer:
request = json.loads(line)
op = request.get("op")
if op == "open":
try:
import duckdb
database = duckdb.connect(request["database"], config=request.get("config") or {})
reply({"id": request["id"], "ok": True, "duckdb": duckdb.__version__, "python": sys.version.split()[0]})
except Exception as error: failed(request, error)
elif op == "run":
work = cursors.get(request["cursor"])
if work is None:
work = cursors[request["cursor"]] = queue.Queue()
threading.Thread(target=serve, args=(work,), daemon=True).start()
work.put(request)
elif op == "close":
work = cursors.pop(request["cursor"], None)
if work is not None:
work.put(None)
else:
failed(request, ValueError(f"unknown op {op!r}"))
replies.flush()
os._exit(0)
main()