Prismaの使い方を学ぶ

1
DATABASE_URL="postgres://POSTGRES_USER:POSTGRES_PASSWORD@localhost:5432/POSTGRES_DB"
2
POSTGRES_USER=
3
POSTGRES_PASSWORD=
4
POSTGRES_DB=

1
DATABASE_URL="postgres://root:prisma@localhost:5432/prisma"
2
POSTGRES_USER=root
3
POSTGRES_PASSWORD=prisma
4
POSTGRES_DB=prisma

1
model User {
2
  // Fields
3
}

1
model Comment {
2
  // Fields
3

4
  @@map("comments")
5
}

1
model Comment {
2
  id      Int    @id @default(autoincrement())
3
  title   String
4
  content String
5
}

1
model Post {
2
  id       Int       @id @default(autoincrement())
3
  // Other fields
4
  comments Comment[] // A post can have many comments
5
}
6

7
model Comment {
8
  id     Int
9
  // Other fields
10
  Post   Post? @relation(fields: [postId], references: [id]) // A comment can have one post
11
  postId Int?
12
}

1
model User {
2
  // Int型で自動でインクリメントされる, プライマリキーなので重複不可
3
  id        Int     @id @default(autoincrement())
4
  firstName String
5
  lastName  String
6
  // ユニークインデックスなので重複不可
7
  email     String  @unique
8
  // 何もしなければfalseが設定される
9
  isAdmin   Boolean @default(false)
10

11
  // 名字と名前の組み合わせはユニーク制約, 同姓同名を許可しない
12
  @@unique([firstName, lastName])
13
}

1
model User {
2
  firstName String
3
  lastName  String
4
  email     String  @unique
5
  isAdmin   Boolean @default(false)
6

7
  @@id([firstName, lastName])
8
}

1
model User {
2
  email   String   @unique
3
  name    String?
4
  // これはEnum, 詳細は後述
5
  role    Role     @default(USER)
6
  // 配列
7
  posts   Post[]
8
  // オプショナル,  これも後述
9
  profile Profile?
10
}

1
model Product {
2
  id     String  @id @default(auto()) @map("_id") @db.ObjectId
3
  name   String
4
  photos Photo[]
5
}
6

7
type Photo {
8
  height Int
9
  width  Int
10
  url    String
11
}

1
model User {
2
  id    Int    @id @default(autoincrement())
3
  posts Post[]
4
}
5

6
model Post {
7
  id       Int  @id @default(autoincrement())
8
  author   User @relation(fields: [authorId], references: [id])
9
  authorId Int // relation scalar field  (used in the `@relation` attribute above)
10
}

1
model User {
2
  id      Int      @id @default(autoincrement())
3
  profile Profile?
4
}
5

6
model Profile {
7
  id     Int  @id @default(autoincrement())
8
  user   User @relation(fields: [userId], references: [id])
9
  userId Int // relation scalar field (used in the `@relation` attribute above)
10
}

1
model User {
2
  firstName String
3
  lastName  String
4
  profile   Profile?
5

6
  @@id([firstName, lastName])
7
}
8

9
model Profile {
10
  id            Int    @id @default(autoincrement())
11
  user          User   @relation(fields: [userFirstName, userLastName], references: [firstName, lastName])
12
  userFirstName String // relation scalar field (used in the `@relation` attribute above)
13
  userLastName  String // relation scalar field (used in the `@relation` attribute above)
14
}

1
model User {
2
  id    Int    @id @default(autoincrement())
3
  posts Post[]
4
}
5

6
model Post {
7
  id       Int  @id @default(autoincrement())
8
  author   User @relation(fields: [authorId], references: [id])
9
  authorId Int
10
}

1
model User {
2
  firstName String
3
  lastName  String
4
  post      Post[]
5

6
  @@id([firstName, lastName])
7
}
8

9
model Post {
10
  id              Int    @id @default(autoincrement())
11
  author          User   @relation(fields: [authorFirstName, authorLastName], references: [firstName, lastName])
12
  authorFirstName String // relation scalar field (used in the `@relation` attribute above)
13
  authorLastName  String // relation scalar field (used in the `@relation` attribute above)
14
}

1
model Post {
2
  id         Int                 @id @default(autoincrement())
3
  title      String
4
  categories CategoriesOnPosts[]
5
}
6

7
model Category {
8
  id    Int                 @id @default(autoincrement())
9
  name  String
10
  posts CategoriesOnPosts[]
11
}
12

13
model CategoriesOnPosts {
14
  post       Post     @relation(fields: [postId], references: [id])
15
  postId     Int // relation scalar field (used in the `@relation` attribute above)
16
  category   Category @relation(fields: [categoryId], references: [id])
17
  categoryId Int // relation scalar field (used in the `@relation` attribute above)
18
  assignedAt DateTime @default(now())
19
  assignedBy String
20

21
  @@id([postId, categoryId])
22
}

1
model User {
2
  id          Int     @id @default(autoincrement())
3
  name        String?
4
  successorId Int?
5
  successor   User?   @relation("BlogOwnerHistory", fields: [successorId], references: [id])
6
  predecessor User?   @relation("BlogOwnerHistory")
7
}