zzstoatzz.io
prefect server in zig
1-- 004_log_table: add log table for persistent log storage
2-- previously logs were in-memory only
3
4CREATE TABLE IF NOT EXISTS log (
5 id TEXT PRIMARY KEY,
6 created TEXT DEFAULT TO_CHAR(NOW() AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'),
7 updated TEXT DEFAULT TO_CHAR(NOW() AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"'),
8 name TEXT NOT NULL,
9 level INTEGER NOT NULL,
10 message TEXT NOT NULL,
11 timestamp TEXT NOT NULL,
12 flow_run_id TEXT REFERENCES flow_run(id) ON DELETE CASCADE,
13 task_run_id TEXT REFERENCES task_run(id) ON DELETE CASCADE
14);
15
16CREATE INDEX IF NOT EXISTS ix_log__flow_run_id ON log(flow_run_id);
17CREATE INDEX IF NOT EXISTS ix_log__task_run_id ON log(task_run_id);
18CREATE INDEX IF NOT EXISTS ix_log__level ON log(level);
19CREATE INDEX IF NOT EXISTS ix_log__timestamp ON log(timestamp);
20CREATE INDEX IF NOT EXISTS ix_log__flow_run_id_timestamp ON log(flow_run_id, timestamp);