import type { Database } from "bun:sqlite"; import type { CommandIndex } from "../command_index"; import { setMetaValue } from "./meta"; export function syncCommands(database: Database, index: CommandIndex): void { const existingRows = database .query("SELECT name, command_path AS commandPath, path_order AS pathOrder FROM commands") .all() as { name: string; commandPath: string; pathOrder: number }[]; const existing = new Map(existingRows.map((row) => [row.name, row])); const seen = new Set(); const upsert = database.query( `INSERT INTO commands (name, command_path, path_order, indexed_at) VALUES (?1, ?2, ?3, ?4) ON CONFLICT(name) DO UPDATE SET command_path = excluded.command_path, path_order = excluded.path_order, indexed_at = excluded.indexed_at`, ); const remove = database.query("DELETE FROM commands WHERE name = ?1"); database.transaction(() => { index.commands.forEach((command, pathOrder) => { const previous = existing.get(command.name); seen.add(command.name); if ( previous && previous.commandPath === command.resolvedPath && previous.pathOrder === pathOrder ) { return; } upsert.run(command.name, command.resolvedPath, pathOrder, now()); }); for (const row of existingRows) { if (!seen.has(row.name)) { remove.run(row.name); } } setMetaValue(database, "last_scanned_at", String(now())); setMetaValue(database, "source", "linux_path"); })(); } export function commandsDifferFromIndex( database: Database, index: CommandIndex, ): boolean { const existingRows = database .query("SELECT name, command_path AS commandPath, path_order AS pathOrder FROM commands ORDER BY path_order ASC") .all() as { name: string; commandPath: string; pathOrder: number }[]; if (existingRows.length !== index.commands.length) { return true; } for (const [pathOrder, command] of index.commands.entries()) { const existing = existingRows[pathOrder]; if (!existing) { return true; } if ( existing.name !== command.name || existing.commandPath !== command.resolvedPath || existing.pathOrder !== pathOrder ) { return true; } } return false; } function now(): number { return Math.floor(Date.now() / 1000); }