-
-
Notifications
You must be signed in to change notification settings - Fork 202
/
drizzle.config.ts
69 lines (57 loc) · 1.88 KB
/
drizzle.config.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
import { config } from "dotenv";
import { defineConfig } from "drizzle-kit";
import {
databaseDialect,
databasePrefix,
databaseProvider,
} from "./reliverse.config";
/* eslint-disable no-restricted-properties */
config({ path: ".env" });
// Determine the output path based on the database provider
const outNeonOrPg = `drizzle/${databasePrefix}/pgsql`;
const outSqlite = `drizzle/${databasePrefix}/sqlite`;
const outMysql = `drizzle/${databasePrefix}/mysql`;
const outElse =
databaseProvider === "neon" || databaseProvider === "private-pg"
? outNeonOrPg
: databaseProvider === "private-sqlite"
? outSqlite
: outMysql;
const outRailwayMysql = `drizzle/${databasePrefix}/mysql`;
const outRailwayPg = `drizzle/${databasePrefix}/pgsql`;
const outRailway =
databaseProvider === "railway-mysql" ? outRailwayMysql : outRailwayPg;
const out = databaseProvider.startsWith("railway") ? outRailway : outElse;
// Determine the schema path based on the database provider
const schemaPg = "src/db/schema/pgsql.ts";
const schemaSqlite = "src/db/schema/sqlite.ts";
const schemaMysql = "src/db/schema/mysql.ts";
const schemaElse =
databaseProvider === "neon" || databaseProvider === "private-pg"
? schemaPg
: databaseProvider === "private-sqlite"
? schemaSqlite
: schemaMysql;
const schemaRailway =
databaseProvider === "railway-mysql" ? schemaMysql : schemaPg;
const schema = databaseProvider.startsWith("railway")
? schemaRailway
: schemaElse;
// Export the configuration
// consola.info("Database configuration loading...");
// @see https://orm.drizzle.team/learn/tutorials/drizzle-with-neon
export default defineConfig({
dbCredentials: {
url: process.env.DATABASE_URL! || "",
},
dialect: databaseDialect,
migrations: {
schema: "public",
table: out,
},
out,
schema,
strict: true,
tablesFilter: [`${databasePrefix}_*`],
verbose: false,
});