JS/TS 로 데이터베이스를 연결한다!
yarn add -D prisma
npx prisma init
Next steps:
1. Set the DATABASE_URL in the .env file to point to your existing database. If your database has no tables yet, read <https://pris.ly/d/getting-started>
2. Set the provider of the datasource block in schema.prisma to match your database: postgresql, mysql, sqlite, sqlserver or mongodb (Preview).
3. Run prisma db pull to turn your database schema into a Prisma schema.
4. Run prisma generate to generate the Prisma Client. You can then start querying your database.
schema.prisma
provide = "mysql"
prisma가 model를 읽고 DB에 적용한다.
model User {
id Int @id @default(autoincrement())
name String
phone String? @unique
email String? @unique
avata String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}