lawrencecchen · April 2, 2023 10:09 · Apr 2, 2023 · Apr 2, 2023 · Apr 2, 2023 · Apr 2, 2023
diff --git a/db.ts b/db.ts
@@ -11,6 +11,8 @@ export type Database = {
 
 export const db = new Kysely<Database>({
   dialect: new PlanetScaleDialect({
-    url: process.env.DATABASE_URL,
+    host: process.env.DATABASE_HOST,
+    username: process.env.DATABASE_USERNAME,
+    password: process.env.DATABASE_PASSWORD,
   }),
 });
diff --git a/db.ts b/db.ts
@@ -1,6 +1,6 @@
 import { Kysely } from "kysely";
 import { PlanetScaleDialect } from "kysely-planetscale";
-import { z } from "zod";
+import { type z } from "zod";
 
 import * as Models from "./prisma/generated/zod/modelSchema";
 

diff --git a/db.ts b/db.ts
@@ -0,0 +1,16 @@
+import { Kysely } from "kysely";
+import { PlanetScaleDialect } from "kysely-planetscale";
+import { z } from "zod";
+
+import * as Models from "./prisma/generated/zod/modelSchema";
+
+type RemoveSchema<S extends string> = S extends `${infer Prefix}Schema` ? Prefix : S;
+export type Database = {
+  [K in keyof typeof Models as RemoveSchema<K>]: z.infer<(typeof Models)[K]>;
+};
+
+export const db = new Kysely<Database>({
+  dialect: new PlanetScaleDialect({
+    url: process.env.DATABASE_URL,
+  }),
+});
diff --git a/schema.prisma b/schema.prisma
@@ -0,0 +1,4 @@
+generator zod {
+  provider         = "zod-prisma-types"
+  useMultipleFiles = true
+}