danieldaum.net
kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1import { config } from "dotenv-mono";
2import { drizzle } from "drizzle-orm/node-postgres";
3import { Pool } from "pg";
4import {
5 accountTableRelations,
6 activityTableRelations,
7 apikeyTableRelations,
8 assetTableRelations,
9 columnTableRelations,
10 externalLinkTableRelations,
11 githubIntegrationTableRelations,
12 integrationTableRelations,
13 invitationTableRelations,
14 labelTableRelations,
15 notificationTableRelations,
16 projectTableRelations,
17 sessionTableRelations,
18 taskTableRelations,
19 teamMemberTableRelations,
20 teamTableRelations,
21 timeEntryTableRelations,
22 userTableRelations,
23 verificationTableRelations,
24 workflowRuleTableRelations,
25 workspaceTableRelations,
26 workspaceUserTableRelations,
27} from "./relations";
28import {
29 accountTable,
30 activityTable,
31 apikeyTable,
32 assetTable,
33 columnTable,
34 externalLinkTable,
35 githubIntegrationTable,
36 integrationTable,
37 invitationTable,
38 labelTable,
39 notificationTable,
40 projectTable,
41 sessionTable,
42 taskTable,
43 teamMemberTable,
44 teamTable,
45 timeEntryTable,
46 userTable,
47 verificationTable,
48 workflowRuleTable,
49 workspaceTable,
50 workspaceUserTable,
51} from "./schema";
52
53config();
54
55const pool = new Pool({
56 connectionString:
57 process.env.DATABASE_URL ||
58 "postgresql://kaneo_user:kaneo_password@localhost:5432/kaneo",
59});
60
61export const schema = {
62 accountTable,
63 assetTable,
64 activityTable,
65 apikeyTable,
66 columnTable,
67 externalLinkTable,
68 githubIntegrationTable,
69 integrationTable,
70 invitationTable,
71 labelTable,
72 notificationTable,
73 projectTable,
74 sessionTable,
75 taskTable,
76 teamMemberTable,
77 teamTable,
78 timeEntryTable,
79 userTable,
80 verificationTable,
81 workflowRuleTable,
82 workspaceTable,
83 workspaceUserTable,
84 accountTableRelations,
85 assetTableRelations,
86 activityTableRelations,
87 apikeyTableRelations,
88 columnTableRelations,
89 externalLinkTableRelations,
90 githubIntegrationTableRelations,
91 integrationTableRelations,
92 invitationTableRelations,
93 labelTableRelations,
94 notificationTableRelations,
95 projectTableRelations,
96 sessionTableRelations,
97 taskTableRelations,
98 teamMemberTableRelations,
99 teamTableRelations,
100 timeEntryTableRelations,
101 userTableRelations,
102 verificationTableRelations,
103 workflowRuleTableRelations,
104 workspaceTableRelations,
105 workspaceUserTableRelations,
106};
107
108const db = drizzle(pool, {
109 schema: schema,
110});
111
112export default db;