import * as Effect from "effect/Effect";
import * as SqlClient from "effect/sql/SqlClient";
export default Effect.gen(function* () {
const sql = yield* SqlClient.SqlClient;
yield* sql`
CREATE TABLE IF NOT EXISTS scheduled_tasks (
task_id TEXT PRIMARY KEY,
title TEXT NOT NULL,
prompt TEXT NOT NULL,
enabled INTEGER NOT NULL,
schedule_json TEXT NOT NULL,
project_id TEXT NOT NULL,
thread_id TEXT,
workspace_strategy_json TEXT NOT NULL,
model_selection_json TEXT NOT NULL,
runtime_mode TEXT NOT NULL,
interaction_mode TEXT NOT NULL,
created_by TEXT NOT NULL,
creation_source TEXT NOT NULL,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL,
next_run_at TEXT,
last_run_at TEXT,
last_run_status TEXT NOT NULL,
last_run_error TEXT,
run_count INTEGER NOT NULL
)
`;
yield* sql`
CREATE INDEX IF NOT EXISTS idx_scheduled_tasks_due
ON scheduled_tasks(enabled, next_run_at)
WHERE enabled = 1 AND next_run_at IS NOT NULL
`;
yield* sql`
CREATE INDEX IF NOT EXISTS idx_scheduled_tasks_project
ON scheduled_tasks(project_id, updated_at)
`;
});