53 lines
1.3 KiB
TypeScript
53 lines
1.3 KiB
TypeScript
import Database from "better-sqlite3";
|
|
import path from "path";
|
|
|
|
const DB_PATH = path.join(process.cwd(), "data", "demo-requests.db");
|
|
|
|
let db: Database.Database | null = null;
|
|
|
|
function getDb(): Database.Database {
|
|
if (!db) {
|
|
// Ensure data directory exists
|
|
const fs = require("fs");
|
|
const dir = path.dirname(DB_PATH);
|
|
if (!fs.existsSync(dir)) {
|
|
fs.mkdirSync(dir, { recursive: true });
|
|
}
|
|
|
|
db = new Database(DB_PATH);
|
|
db.pragma("journal_mode = WAL");
|
|
|
|
db.exec(`
|
|
CREATE TABLE IF NOT EXISTS demo_requests (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
email TEXT NOT NULL,
|
|
name TEXT NOT NULL DEFAULT '',
|
|
company TEXT DEFAULT '',
|
|
message TEXT DEFAULT '',
|
|
created_at TEXT NOT NULL DEFAULT (datetime('now'))
|
|
)
|
|
`);
|
|
}
|
|
return db;
|
|
}
|
|
|
|
export interface DemoRequest {
|
|
email: string;
|
|
name: string;
|
|
company?: string;
|
|
message?: string;
|
|
}
|
|
|
|
export function insertDemoRequest(req: DemoRequest) {
|
|
const db = getDb();
|
|
const stmt = db.prepare(
|
|
"INSERT INTO demo_requests (email, name, company, message) VALUES (?, ?, ?, ?)"
|
|
);
|
|
return stmt.run(req.email, req.name, req.company || "", req.message || "");
|
|
}
|
|
|
|
export function getAllDemoRequests() {
|
|
const db = getDb();
|
|
return db.prepare("SELECT * FROM demo_requests ORDER BY created_at DESC").all();
|
|
}
|