Prisma - User & Token connection
ยท
๐Ÿ’Ž Prisma
โœ… Prisma ์„ค์ •generator client { provider = "prisma-client-js" previewFeatures = ["referentialIntegrity"]}datasource db { provider = "mysql" url = env("DATABASE_URL") referentialIntegrity = "prisma"} โœ… User modelmodel User { id Int @id @default(autoincrement()) phone Int? @unique email String? @unique name String avatar ..
Prisma - findUnique, create, upsert
ยท
๐Ÿ’Ž Prisma
โœ… findUniquewhere์— ์ง€์ •ํ•œ ์กฐ๊ฑด์ด ๋งž๋Š” user๋ฅผ ๊ฒ€์ƒ‰ํ•œ๋‹ค.user = await client.user.findUnique({ where: { email, }, }); โœ… createdata ๋‚ด์— ์ง€์ •ํ•œ ์ •๋ณด๋กœ user๋ฅผ ์ƒ์„ฑํ•œ๋‹ค.user = await client.user.create({ data: { name: "Anonymous", email, }, }); โœ… upsertupdate + insert๋ฅผ ํ•ฉ์นœ ๊ฒƒwhere์— ์ ์€ ์กฐ๊ฑด์„ ๋งŒ์กฑํ•˜๋Š” ์œ ์ €๊ฐ€ ์กด์žฌํ•œ๋‹ค๋ฉด update๋ฅผ ํ•˜๊ณ , ์กด์žฌํ•˜์ง€ ์•Š์œผ๋ฉด createํ•œ๋‹ค. (update๋ฅผ ํ•˜์ง€ ์•Š์„๊ฑฐ๋ฉด ๋น„์›Œ๋‘”๋‹ค.)const { phone, em..