Clear artifacts when creating new session

Each new session now starts with empty research.md and plan.md files,
preventing stale content from previous sessions appearing.

1 files changed, 28 insertions, 0 deletions

diff --git a/dist/main/db/projects.js b/dist/main/db/projects.js
new file mode 100644
index 0000000..af36cc0
--- /dev/null
+++ b/dist/main/db/projects.js
@@ -0,0 +1,28 @@
+"use strict";
+Object.defineProperty(exports, "__esModule", { value: true });
+exports.listProjects = listProjects;
+exports.getProject = getProject;
+exports.createProject = createProject;
+exports.deleteProject = deleteProject;
+const index_1 = require("./index");
+const uuid_1 = require("uuid");
+function listProjects() {
+    return (0, index_1.getDb)()
+        .prepare("SELECT * FROM projects ORDER BY updated_at DESC")
+        .all();
+}
+function getProject(id) {
+    return (0, index_1.getDb)()
+        .prepare("SELECT * FROM projects WHERE id = ?")
+        .get(id);
+}
+function createProject(name, projectPath) {
+    const db = (0, index_1.getDb)();
+    const id = (0, uuid_1.v4)();
+    const now = Math.floor(Date.now() / 1000);
+    db.prepare("INSERT INTO projects (id, name, path, created_at, updated_at) VALUES (?, ?, ?, ?, ?)").run(id, name, projectPath, now, now);
+    return { id, name, path: projectPath, created_at: now, updated_at: now };
+}
+function deleteProject(id) {
+    (0, index_1.getDb)().prepare("DELETE FROM projects WHERE id = ?").run(id);
+}