import Database from "better-sqlite3";

const DB_PATH = "/var/www/html/bots/bots_policia_capital/shared/database.db";

export function getOficialByRG(rg: string) {
  const db = new Database(DB_PATH, { readonly: true });
  const row = db.prepare("SELECT discordId, nome, idCidade, patente, batalhao, status FROM membros WHERE idCidade = ? AND status = 'ativo' LIMIT 1").get(rg) as Record<string, string> | undefined;
  db.close();
  return row || null;
}

export function getOficialByDiscord(discordId: string) {
  const db = new Database(DB_PATH, { readonly: true });
  const row = db.prepare("SELECT discordId, nome, idCidade, patente, batalhao, status FROM membros WHERE discordId = ? AND status = 'ativo' LIMIT 1").get(discordId) as Record<string, string> | undefined;
  db.close();
  return row || null;
}