DROP DATABASE

CREATE DATABASE

DROP DATABASE

prisma db push

prisma db push

—-force

--accept-data-loss

—-force-reset

prisma db seed

prisma db seed

--schema

package.json

nativeTypes

prisma migrate dev

shadowDatabaseUrl

datasource db {
  provider          = "postgresql"
  url               = env("DATABASE_URL")
  shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
}

prisma introspect

prisma db pull

2.10.0

prisma db push

prisma introspect

prisma introspect

prisma db pull

prisma introspect

prisma db pull

prisma introspect

prisma introspect

prisma introspect

ts-node

package.json

ts-node

prisma db seed

{
  "name": "my-project",
  "version": "1.0.0",
  "scripts": {
    "ts-node": "ts-node --compiler-options '{\"module\":\"CommonJS\"}'"
  },
  "devDependencies": {
    "@types/node": "^14.14.21",
    "ts-node": "^9.1.1",
    "typescript": "^4.1.3"
  }
}

prisma format

npx prisma format

prisma migrate

npx prisma format

post, _ := client.Post.UpsertOne(
    // query
    Post.ID.Equals("upsert"),
).Create(
    // set these fields if document doesn't exist already
    Post.Title.Set("title"),
    Post.Views.Set(0),
    Post.ID.Set("upsert"),
).Update(
    // update these fields if document already exists
    Post.Title.Set("new-title"),
    Post.Views.Increment(1),
).Exec(ctx)

--preview-feature

npx prisma migrate <COMMAND>

const orderedUsers = await prisma.user.findMany({
  orderBy: {
    posts: {
      count: 'asc'
    }
  }
})

orderByRelation

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["orderByRelation"]
}

Transaction

_count

select

include

select

const users = await prisma.user.findMany({
  include: {
    _count: {
      select: { posts: true },
    },
  },
})

User

{
  id: 1,
  email: '<mailto:alice@prisma.io|alice@prisma.io>',
  name: 'Alice',
  _count: { posts: 2 }
}

selectRelationCount

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["selectRelationCount"]
}

napi

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["napi"]
}

push

permissions

User

model User {
  id          Int @id @default(autoincrement())
  permissions String[]
}

push

await prisma.user.update({
  where: { id: 42 },
  data: {
    permission: {
      push: "chat:read",
    },
  },
})

groupBy

createMany

groupBy

createMany

generator client {
   provider        = "prisma-client-js"
   previewFeatures = ["groupBy", "createMany"] // can be removed now
 }

BigInt

Decimal

Bytes

BigInt

Decimal

var views db.BigInt = 1
bytes := []byte("abc")
dec := decimal.NewFromFloat(1.23456789)
created, err := client.User.CreateOne(
  db.User.Picture.Set(bytes),
  db.User.Balance.Set(dec),
  db.User.Views.Set(views),
).Exec(ctx)

2.21.0

const userRatingsCount = await prisma.user.groupBy({
  by: ['city'],
  count: {
    city: true,
  },
  orderBy: {
    _count: {
      city: 'desc',
    },
  },
})

[
  { city: 'Berlin', count: { city: 3 } },
  { city: 'Paris', count: { city: 2 } },
  { city: 'Amsterdam', count: { city: 1 } },
]

orderByAggregateGroup

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["orderByAggregateGroup"]
}

2.22.0

prisma db push

prisma db push

prisma db push

provider

provider

datasource

AND

OR

AND

first, err := client.User.FindFirst(
	User.Or(
		User.Email.Equals("<mailto:john@example.com|john@example.com>"),
		User.And(
			User.Name.Equals("John"),
			User.Username.Equals("johno"),
		),
	),
).Exec(ctx)

Json

filterJson

generator

prisma db seed

prisma db seed

node ./prisma/seed.js

ts-node ./prisma/seed.ts

groupBy

const result = await prisma.user.groupBy({
  by: ['name'],
   count: true,
})

2.23.0

const result = await prisma.user.groupBy({
  by: ['name'],
    _count: true,
})

Json

Enum

Json

enum

provider

prisma
datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["mongodb"]
}

model Log {
  id      String @id @default(dbgenerated()) @map("_id")
  message String
  level   Level  @default(Info)
  meta    Json
}

enum Level {
  Info
  Warn
  Error
}

mongodb

prisma migrate dev

prisma migrate dev

[*] Changed the `Color` enum
  [+] Added variant `TRANSPARENT`
  [-] Removed variant `RED`

[*] Changed the `Cat` table
  [-] Removed column `color`
  [+] Added column `vaccinated`

[*] Changed the `Dog` table
  [-] Dropped the primary key on columns (id)
  [-] Removed column `name`
  [+] Added column `weight`
  [*] Altered column `isGoodDog` (arity changed from Nullable to Required, default changed from `None` to `Some(Value(Boolean(true)))`)
  [+] Added unique index on columns (weight)

.env

.env

example/
├── .env
├── main.go
└── schema.prisma

.env

model User {
  id    String @id
  posts Post[]
}

model Post {
  id       String @id
  authorId String
  author   User   @relation(fields: [authorId], onDelete: Cascade, onUpdate: Cascade)
}

referentialActions

generator

generator client {
  provider = "prisma-client-js"
  previewFeatures = ["referentialActions"]
}

prisma init

--datasource-provider

datasource

prisma init

nApi

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["nApi"]
}

schema.prisma

mongodb

mongoDb

previewFeatures

generator

// Set the database provider to "mongodb"
datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

// We want to generate a Prisma Client
// Since mongodb is a preview feature, we need to enable it.
generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["mongoDb"]
}

// Create our Post model which will be mapped to a collection in the database.
// The id attributes tell Prisma it's a primary key and to generate 
// object ids by default when inserting posts.
model Post {
  id    String @id @default(dbgenerated()) @map("_id") @db.ObjectId
  slug  String @unique
  title String
  body  String
}

.env

interactiveTransactions

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["interactiveTransactions"]
}

namedConstraints

@@unique

@@index

namedConstraints

namedConstraints

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["namedConstraints"]
}

prisma db pull

fullTextSearch

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextSearch"]
}

search

String

// returns all posts that contain the words cat *or* dog.
const result = await prisma.post.findMany({
  where: {
    body: {
      search: 'cat | dog',
    },
  },
})

prisma introspect

prisma db pull

prisma introspect

prisma db pull

schema.prisma

prisma db pull

prisma introspect

User:Post

@relation()

referentialIntegrity

2.24.0

planetScaleMode

referentialIntegrity

referentialIntegrity = "prisma"

prisma

referentialIntegrity

datasource db {
  provider             = "mysql"
  url                  = env("DATABASE_URL")
  referentialIntegrity = "prisma"
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["referentialIntegrity"]
}

prisma

fullTextSearch

// Fetch all drafts with a title that contains the words fox or dog
posts, _ := client.Post.FindMany(
  db.Post.Title.Search("fox | dog"),
  db.Post.Status.Equals("Draft"),
).Exec(context.Background())

// Loop over the posts and print the title
for _, post := range posts {
  fmt.Println(post.Title)
}

prisma db pull

mongoDb

datasource

prisma db pull

const userWithPostsCount = await prisma.user.findMany({
  include: {
    _count: {
      select: { posts: true },
    },
  },
})

// => [
//      { 
//        email: "<mailto:alice@prisma.io|alice@prisma.io>",
//        _count: { posts: 3 }
//      }
//    ]

3.3.0

import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()

addEventListener('fetch', (event) => {
  event.respondWith(handleRequest(event.request))
})

async function handleRequest(request: Request): Promise<Response> {
  await prisma.log.create({
    data: {
      level: 'Info',
      message: `${request.method} ${request.url}`,
    },
  })
  return new Response(`request method: ${request.method}!`)
}

2.16.0

ts
// Return a list of posts ordered by the author's email address
// in ascending order.
await prisma.post.findMany({
  orderBy: {
    author: {
      email: "asc",
    },
  },
})

3.3.0

model User {
  id   Int      @id @default(autoincrement())
  name String
  pets String[]
}

user, err := client.User.FindFirst(
  db.User.Pets.HasSome([]string{"Fido", "Scooby"}),
).Exec(ctx)

user, err := client.User.FindUnique(
  db.User.Name.Equals(1),
).Update(
  db.User.Items.Push([]string{"Charlemagne"}),
).Exec(ctx)

3.4.0

3.4.0

ORDER BY

city

const groupBy = await prisma.user.groupBy({
  by: ['city'],
  _count: {
    city: true,
  },
  orderBy: {
    _count: {
      city: 'desc',
    },
  },
})

prisma db push

prisma db push

@unique

@@unique

@@index

prisma db push

logs, _ := client.Log.FindMany(
  db.Log.Meta.Path([]string{"service"}),
	db.Log.Meta.Equals(db.JSON("\"api\"")),
).Exec(ctx)

3.5.0

search

where

const query = "node.js developer"
const developers = await prisma.people.findMany({
  where: {
    bio: {
      // Only select people whose bio's contain "node.js developer"
      search: query,
    },
  },
  orderBy: {
    // Order that selection by query relevance.
    _relevance: {
      fields: ["bio"],
      search: query,
      sort: "desc",
    },
  },
})

sort

length

model Post {
    title       String @db.VarChar(300)
    abstract    String @db.VarChar(3000)
    slug        String @db.VarChar(3000) @unique(sort: Desc, length: 42)
    author      String
    created_at  DateTime

    @@id([title(length: 100, sort: Desc), abstract(length: 10)])
    @@index([author, created_at(sort: Desc)])
}

users, err := client.User.FindMany(
    User.Email.Equals("prisMa"),
    User.Email.Mode(QueryModeInsensitive), // sets case insensitivity
).Exec(ctx)

db pull+

db push

migrate

fullTextIndex

@@fulltext

generator js {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextIndex"]
}

model A {
  id      Int    @id
  title   String @db.VarChar(255)
  content String @db.Text
  
  @@fulltext([title, content])
}

db pull

extendedIndexes

Hash

BTree

generator js {
  provider        = "prisma-client-js"
  previewFeatures = ["extendedIndexes"]
}

model A {
  id    Int @id
  value Int  
  
  @@index([value], type: Hash)
}

3.6.0

Bytes

in

notIn

in

notIn

Bytes

const audioTracks = raws.map(raw => {
  return Buffer.from(raw)
})

const result = await prisma.audio.find({
  where: {
    track: 
      in: audioTracks
    }
  }
})

Json

Json

audit

Json

const trail = [
  { event: "signup" },
  { event: "subscribe" },
  { event: "invite friend" }
] as const

await prisma.user.create({
  data: {
    audit: trail
  }
})

3.7.0

3.7.0

onDelete

onUpdate

model User {
   id    String @id @default(dbgenerated()) @map("_id") @db.ObjectId
   posts Post[]
   name  String
 }

 model Post {
   id     String @id @default(dbgenerated()) @map("_id") @db.ObjectId
   author User   @relation(fields: [userId], references: [id], *onDelete: Cascade*)
   title  String
   userId String @db.ObjectId
 }

onDelete: Cascade

onDelete

onUpdate

mongodb

Error parsing attribute "@relation": Reference causes a cycle.

type

3.7.0

type

type MyId = String @id @default(dbgenerated(new_uuid()))

model A {
  id MyId
}

BigInt

3.8.0

fullTextIndex

fullTextSearch

@@fulltext()

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextIndex", "fullTextSearch"]
}

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model Post {
  id     Int    @id @default(autoincrement())
  title  String @unique
  @@fulltext([title])
}

prisma db push

prisma migrate dev

// search for titles that contain cat, but not fox
await prisma.post.findMany({
  where: {
    title: {
      search: "+cat -fox",
    },
  },
})

dataProxy

interactiveTransactions

3.8.0

push

3.8.0

push

model Course {
  id          String   @id @default(dbgenerated()) @map("_id") @db.ObjectId
  title       String
  students    String[] @db.Array(ObjectId)
}

// Add a new student to the course
await prisma.course.update({
  where: {
    id: 1
  },
  data: {
    students: {
      push: new ObjectID("...")
    }
  }
})