import type { Database } from "bun:sqlite";import type { Rig } from "@local-studio/contracts/rigs";import { openSqliteDatabase } from "./sqlite";type RigRow = { data: string;};export class RigStore { private readonly db: Database; public constructor(dbPath: string) { this.db = openSqliteDatabase(dbPath); this.db.run(` CREATE TABLE IF NOT EXISTS rigs ( id TEXT PRIMARY KEY, data TEXT NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP, updated_at TEXT DEFAULT CURRENT_TIMESTAMP ) `); } public list(): Rig[] { const rows = this.db.query("SELECT data FROM rigs ORDER BY created_at").all() as RigRow[]; const rigs: Rig[] = []; for (const row of rows) { try { rigs.push(JSON.parse(row.data) as Rig); } catch { continue; } } return rigs; } public get(rigId: string): Rig | null { const row = this.db.query("SELECT data FROM rigs WHERE id = ?").get(rigId) as RigRow | null; if (!row) return null; try { return JSON.parse(row.data) as Rig; } catch { return null; } } public save(rig: Rig): void { this.db .query( `INSERT INTO rigs (id, data, updated_at) VALUES (?, ?, CURRENT_TIMESTAMP) ON CONFLICT(id) DO UPDATE SET data = excluded.data, updated_at = CURRENT_TIMESTAMP`, ) .run(rig.id, JSON.stringify(rig)); } public delete(rigId: string): boolean { const result = this.db.query("DELETE FROM rigs WHERE id = ?").run(rigId); return result.changes > 0; }}
import type { Database } from "bun:sqlite";
import type { Rig } from "@local-studio/contracts/rigs";
import { openSqliteDatabase } from "./sqlite";
type RigRow = {
data: string;
};
export class RigStore {
private readonly db: Database;
public constructor(dbPath: string) {
this.db = openSqliteDatabase(dbPath);
this.db.run(`
CREATE TABLE IF NOT EXISTS rigs (
id TEXT PRIMARY KEY,
data TEXT NOT NULL,
created_at TEXT DEFAULT CURRENT_TIMESTAMP,
updated_at TEXT DEFAULT CURRENT_TIMESTAMP
)
`);
}
public list(): Rig[] {
const rows = this.db.query("SELECT data FROM rigs ORDER BY created_at").all() as RigRow[];
const rigs: Rig[] = [];
for (const row of rows) {
try {
rigs.push(JSON.parse(row.data) as Rig);
} catch {
continue;
}
}
return rigs;
}
public get(rigId: string): Rig | null {
const row = this.db.query("SELECT data FROM rigs WHERE id = ?").get(rigId) as RigRow | null;
if (!row) return null;
try {
return JSON.parse(row.data) as Rig;
} catch {
return null;
}
}
public save(rig: Rig): void {
this.db
.query(
`INSERT INTO rigs (id, data, updated_at) VALUES (?, ?, CURRENT_TIMESTAMP)
ON CONFLICT(id) DO UPDATE SET data = excluded.data, updated_at = CURRENT_TIMESTAMP`,
)
.run(rig.id, JSON.stringify(rig));
}
public delete(rigId: string): boolean {
const result = this.db.query("DELETE FROM rigs WHERE id = ?").run(rigId);
return result.changes > 0;
}
}