preview-1

preview-2

preview-3

preview-1

project.prisma

schema.prisma

postgres

postgresql

prisma/*

prisma-labs/*

nexus-prisma@0.4

note/prisma1

note/wontfix

nexus-prisma@0.3

nexus-prisma

nexus-prisma

nexus-prisma

Note that Prisma Migrate and Prisma Studio are not part of today's release. They're both still considered experimental.

prisma-binding

Json

Json

equal

not

PRISMA_HIDE_UPDATE_MESSAGE

"1"

"true"

"asd"

experimentalFeatures

generator

transaction

generator client {
  provider = "prisma-client-js"
  experimentalFeatures = ["connectOrCreate", "transactionApi"]
}

npx prisma generate

prisma introspect

@map

@@map

--experimental-reintrospection

prisma introspect

npx prisma introspect

datasource

provider

datasource

connectOrCreate

transactionApi

count

Int

Float

prisma introspect

2.1.0

experimentalFeatures

previewFeatures

const result = await prisma.user.findMany({
  where: {},
  distinct: ['name']
})

prisma.use(async (params, next) => {
  console.log('params', params)
  const before = Date.now()
  const result = await next(params)
  const after = Date.now()
  console.log(`Query ${params.model}.${params.action} took ${after - before}ms`)
  return result
})

orderBy

// order by `age` descending and then by `name` ascending
const users = await prisma.user.findMany({
  orderBy: {
    age: 'desc',
    name: 'asc'
  }
})

users

age

name

$

prisma.transaction()

prisma.use()

Transaction

transaction

use

Use

$

$disconnect

$connect

$on

$queryRaw

$executeRaw

$use

$transaction

connect

npx prisma studio --experimental

connectOrCreate

transactionApi

aggregateApi

distinct

middlewares

middlewares

distinct

findMany

aggregationsApi

generator

2.5.0

2.5.0

String

mode

findMany

equals

contains

startsWith

findMany

mode

mode

const result = await prisma.user.findMany({
  where: {
    email: {
      equals: '<mailto:lowercase@UPPERCASE.com|lowercase@UPPERCASE.com>',
      mode: 'insensitive',
    },
  },
})

prisma introspect

@map

@@map

--experimental-reintrospection

prisma introspect

update

Int

Float

x

x

x

x

x

increment

const result = await prisma.user.update({
  where: {
    email: '<mailto:alice@prisma.io|alice@prisma.io>',
  },
  data: {
    age: {
      increment: 1, // age = age + 1 - Happy Birthday!
    }
  },
})

prisma studio

--experimental

npx prisma studio

package.json

schema.prisma

--schema

prisma

{
  "prisma": {
    "schema": "path/to/schema.prisma"
  }
}

package.json

--schema

prisma introspect

findFirst

findMany

findMany

findOne

2.8.0

findFirst

findMany

const usersCalledAlice = await prisma.user.findMany({
  name: "Alice"	
})
const firstUserCalledAlice = usersCalledAlice[0]

const firstUserCalledAlice = await prisma.user.findFirst({
  name: "Alice"	
})

2.5.0

insensitiveFilters

previewFeatures

mode

findMany

contains

startsWith

findMany

mode

insensitive

const result = await prisma.user.findMany({
  where: {
    email: {
      equals: '<mailto:lowercase@UPPERCASE.com|lowercase@UPPERCASE.com>',
      mode: 'insensitive',
    },
  },
})

clientVersion

prisma.$transaction

prisma.$transaction

Error: All elements of the array need to be Prisma Client promises. Hint: Please make sure you are not awaiting the Prisma client calls you intended to pass in the $transaction function.

sqlserver

previewFeature

microsoftSqlServer

datasource db {
  provider = "sqlserver"
}

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

prisma db push --preview-feature

prisma db push

prisma generate

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

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

model User {
  id    Int     @id @default(autoincrement()) 
  name  String? @db.VarChar(255)
}

model Post {
  id        Int      @id @default(autoincrement()) 
  title     String   @db.VarChar(100)
  createdAt DateTime @db.Timestamp(6)
  wordCount Int      @db.SmallInt
}

nativeTypes

BigInt

Bytes

Decimal

BigInt

Bytes

Decimal

nativeTypes

connect

disconnect

await prisma.post.create({
  data: {
    // You can now set the foreign key directly...
    authorId: 1,
    // ... or connect the relationship...
    // author: {
    //   connect: {
    //     id: 1
    //   }
    // }
    // ... but not both at the same time
  },
});

uncheckedScalarInputs

$transaction

connectOrCreate

.dmg

@prisma/codemods

cd my-app
npm install @prisma/cli --save-dev
npm install @prisma/client
npx @prisma/codemods update-2.12 ./

microsoftSqlServer

nativeTypes

generator js {
  provider        = "prisma-client-js"
  previewFeatures = ["microsoftSqlServer", "nativeTypes"]
}

datasource ms {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

model User {
  id   BigInt  @id @default(autoincrement()) @ms.BigInt
  name String? @ms.VarChar(255)
}

$

$

$

$

prisma.$transaction()

prisma.$connect()

prisma.$disconnect()

npx prisma introspect

Json[]

Json[]

JSON

findOne

findUnique

@prisma/client

Prisma

groupBy

generator

groupBy

const locations = await client.agent.groupBy({
  by: ['location'],
  min: {
    rate: true
  },
})

// Result:
// [
//   { location: "Los Angeles", min: { rate: 10.00 } },
//   { location: "London", min: { rate: 20.00 } },
//   { location: "Tokyo", min: { rate: 30.00 } }
// ]

having

binaryTarget

generator

generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["linux-arm-openssl-1.1.x"]
}

select

count

select

count

uncheckedScalarInputs

connect

Json

provider

datasource

sqlite

provider

postgresql

prisma migrate reset

--force

prisma migrate reset

prisma migrate dev

Transaction

go
createA := client.User.CreateOne(
  db.User.ID.Set("c"),
  db.User.Email.Set("a"),
)
createB := client.User.CreateOne(
  db.User.ID.Set("d"),
  db.User.Email.Set("b"),
)
err := client.Prisma.Transaction(createUserA, createUserB).Exec(ctx)
if err != nil {
  return err
}

Transaction

prisma db seed

seed

prisma

prisma db seed

findFirst

findUnique

rejectOnNotFound

findFirst

findUnique

const user = await client.user.findUnique({
  where: {
    id: 10,
  },
  rejectOnNotFound: true
})
// Throws "NotFoundError: No User found" if the 
// user with id = 10 does not exist.

rejectOnNotFound

undefined

where

const admin = await prisma.user.findFirst({
  where: {
    id: 1,
    roles: {
      has: 'ADMIN'
    }
  }
})