electron/ipc.ts - dev - 45case/ptable

import { ipcMain } from "electron";
import { getDb } from "./database";

export function registerIpcHandlers() {
  ipcMain.handle("elements:search", (_event, query: string) => {
    const db = getDb();
    const stmt = db.prepare(`
      SELECT * FROM elements
      WHERE name LIKE ? OR nameEn LIKE ? OR symbol LIKE ? OR slug LIKE ?
      LIMIT 20
    `);
    const q = `%${query}%`;
    stmt.bind([q, q, q, q]);
    const results: Record<string, unknown>[] = [];
    while (stmt.step()) {
      results.push(stmt.getAsObject());
    }
    stmt.free();
    return results;
  });

  ipcMain.handle("elements:getBySlug", (_event, slug: string) => {
    const db = getDb();
    const stmt = db.prepare("SELECT * FROM elements WHERE slug = ?");
    stmt.bind([slug]);
    if (stmt.step()) {
      const result = stmt.getAsObject();
      stmt.free();
      return result;
    }
    stmt.free();
    return null;
  });

  ipcMain.handle("elements:getByAtomicNumber", (_event, n: number) => {
    const db = getDb();
    const stmt = db.prepare("SELECT * FROM elements WHERE atomicNumber = ?");
    stmt.bind([n]);
    if (stmt.step()) {
      const result = stmt.getAsObject();
      stmt.free();
      return result;
    }
    stmt.free();
    return null;
  });
}