Support db schema for users

nooobcoder · nooobcoder · commit d3f82bb259d3 · 2022-05-26T10:40:16.000Z
diff --git a/remix-jokes/package.json b/remix-jokes/package.json
@@ -16,13 +16,15 @@
 		"@remix-run/node": "^1.5.1",
 		"@remix-run/react": "^1.5.1",
 		"@remix-run/serve": "^1.5.1",
+		"bcrypt": "^5.0.1",
 		"prisma": "^3.14.0",
 		"react": "^17.0.2",
 		"react-dom": "^17.0.2"
 	},
 	"devDependencies": {
 		"@remix-run/dev": "^1.5.1",
 		"@remix-run/eslint-config": "^1.5.1",
+		"@types/bcrypt": "^5.0.0",
 		"@types/node": "^17.0.35",
 		"@types/react": "^17.0.45",
 		"@types/react-dom": "^17.0.17",
diff --git a/remix-jokes/prisma/schema.prisma b/remix-jokes/prisma/schema.prisma
@@ -10,10 +10,21 @@ datasource db {
   url      = env("DATABASE_URL")
 }
 
+model User {
+  id           String   @id @default(uuid())
+  createdAt    DateTime @default(now())
+  updatedAt    DateTime @updatedAt
+  username     String   @unique
+  passwordHash String
+  jokes        Joke[]
+}
+
 model Joke {
-  id        String   @id @default(uuid())
-  createdAt DateTime @default(now())
-  updatedAt DateTime @updatedAt
-  name      String
-  content   String
+  id         String   @id @default(uuid())
+  jokesterId String
+  jokester   User     @relation(fields: [jokesterId], references: [id], onDelete: Cascade)
+  createdAt  DateTime @default(now())
+  updatedAt  DateTime @updatedAt
+  name       String
+  content    String
 }
diff --git a/remix-jokes/prisma/seed.ts b/remix-jokes/prisma/seed.ts
@@ -1,4 +1,5 @@
 import { PrismaClient } from "@prisma/client";
+import bcrypt from "bcrypt";
 
 const db = new PrismaClient();
 
@@ -42,7 +43,20 @@ const getJokes = () => [
 ];
 
 const seed = async () => {
-	await Promise.all(getJokes().map((joke) => db.joke.create({ data: joke })));
+	// Hash a password
+	const password = await bcrypt.hash("ankurpaul", 10);
+	const kody = await db.user.create({
+		data: {
+			username: "ankurpaul",
+			passwordHash: password,
+		},
+	});
+
+	await Promise.all(
+		getJokes().map((joke) =>
+			db.joke.create({ data: { jokesterId: kody.id, ...joke } })
+		)
+	);
 };
 
 seed();
diff --git a/remix-jokes/yarn.lock b/remix-jokes/yarn.lock
