import path from "node:path";
import { createFileDb } from "../src/infra/db/pglite";
import { createPostgresDb } from "../src/infra/db/postgres";

const workspaceId = process.argv[2];
const enabled = process.argv[3] !== "off";
if (!workspaceId) {
  console.error("uso: npm run flag -- <workspace_id> on|off");
  process.exit(1);
}
const databaseUrl = process.env.DATABASE_URL;
const db = databaseUrl ? createPostgresDb(databaseUrl) : await createFileDb(path.join(process.cwd(), ".data", "pglite"));
await db.withService(async (query) => {
  await query.query(
    `insert into public.workspace_module_flags (workspace_id, module_key, enabled)
     values ($1, 'spreadsheet_adapter', $2)
     on conflict (workspace_id, module_key) do update set enabled = excluded.enabled, updated_at = now()`,
    [workspaceId, enabled],
  );
  await query.query(
    `insert into public.audit_log (workspace_id, actor_id, action, resource_type, resource_id, result, metadata)
     select $1, m.user_id, 'module.flag_changed', 'workspace', $1, 'success', jsonb_build_object('enabled', $2::boolean)
     from public.workspace_members m
     where m.workspace_id = $1 and m.role = 'owner'
     limit 1`,
    [workspaceId, enabled],
  );
});
console.log(`spreadsheet_adapter ${enabled ? "ligado" : "desligado"}`);
await db.close();