Prisma schema and client queries
| Command | Description |
|---|---|
model User { id Int @id } | Define model |
posts Post[] | Relation field |
@default(autoincrement()) | Directive |
@unique | Unique constraint |
| Command | Description |
|---|---|
prisma.user.findMany() | Get all |
prisma.user.findUnique({ where }) | Get one |
prisma.user.create({ data }) | Create |
prisma.user.update({ where, data }) | Update |
prisma.user.delete({ where }) | Delete |
| Command | Description |
|---|---|
where: { age: { gt: 18 } } | Filter condition |
include: { posts: true } | Eager load relation |
select: { name: true } | Select specific fields |