homeio

1import type { Config } from "drizzle-kit";
2import fs from "node:fs";
3import path from "node:path";
4import { parseEnvFileContent } from "./lib/shared/env-file";
5
6const DEFAULT_DATABASE_URL =
7  "postgresql://postgres:postgres@127.0.0.1:5432/home_server";
8
9function readDatabaseUrlFromEnvFile(filePath: string) {
10  if (!fs.existsSync(filePath)) return null;
11
12  const env = parseEnvFileContent(fs.readFileSync(filePath, "utf8"));
13  return env.DATABASE_URL || null;
14}
15
16function resolveDatabaseUrl() {
17  if (process.env.DATABASE_URL) return process.env.DATABASE_URL;
18
19  const cwd = process.cwd();
20  const envCandidates = [".env.local", ".env"];
21  for (const envFile of envCandidates) {
22    const resolved = readDatabaseUrlFromEnvFile(path.join(cwd, envFile));
23    if (resolved) return resolved;
24  }
25
26  return DEFAULT_DATABASE_URL;
27}
28
29export default {
30  schema: "./lib/server/db/schema.ts",
31  out: "./drizzle",
32  dialect: "postgresql",
33  schemaFilter: ["public"],
34  dbCredentials: {
35    url: resolveDatabaseUrl(),
36  },
37} satisfies Config;
38