import { drizzle } from "drizzle-orm/libsql";
import { createClient } from "@libsql/client";
import { resolveSqliteDatabaseUrl } from "./resolve-sqlite-url";
import { env } from "../../env";

if (env.NODE_ENV === "production") {
  // 打包时需要保证migrator被引入
  import("drizzle-orm/libsql/migrator");
}

const resolvedUrl = resolveSqliteDatabaseUrl(env.DATABASE_URL);
process.env.DATABASE_URL = resolvedUrl;

const client = createClient({ url: resolvedUrl });

// Enable foreign key constraints — SQLite requires this PRAGMA per connection
client.execute("PRAGMA foreign_keys = ON");

const _db = drizzle(client);

export { _db as dbGlobal };