// Sequelize 
Product.findAll({ 
group: ['date', Sequelize.json(`type.warranty`)],
attributes: [
      'date',
      [Sequelize.json(`type.warranty`), 'warranty'],
      [Sequelize.fn('sum', Sequelizer.col('cost')), 'price ']
    ],
})

VACUUM

tag: String?

tags: String[]

import { PrismaClient } from '@prisma/client'

input UserUpdateInput {
  firstName: String
  lastName: String
  shippingAddress: AddressInput
  phone: String
}

updateUser(where: UserWhereUniqueInput!, data: UserUpdateInput!): User!

firstName

phone

firstName

phone

*setNull

input UserUpdateInput {
  firstName: String
  lastName: String
  shippingAddress: AddressInput
  shippingAddress_setNull: Boolean
  phone: String
  phone_setNull: Boolean
}

null

null

null

model match {
  id                Int                 @id @default(autoincrement())
  session_id        BigInt              @unique
  arbitrated        arbitrated?
}

model arbitrated {
  id                Int                 @id @default(autoincrement())
  match             match               @relation(fields: [matchId], references: [id])
  matchId           Int
  arbitrated_session_id       BigInt              @unique
}

const match = await prisma.match.findUnique({
        where: {
            session_id: 1234
        }
    });

    const arbitrated = await prisma.arbitrated.create({
        data: {
            match: {
                connect: {
                    id: match.id
                }
            },
            arbitrated_session_id: 5678
        }
    });

Query engine binary for current platform "linux-arm-openssl-1.1.x" could not be found.

class MyUserCustomRepo extends PrismaClient<User> {
  customMethod() {
    // implement the function
  }
}

const application = await prisma.application.findFirst({
    where: {
      id: applicationId,
      tasks: {
        array_contains: [{ keyName: taskKeyName }],
      },
    },
  });

tasks

keyName

array_contains

equals

npx prisma migrate dev --name name-migration

applied_steps_count

_prisma_migrations

Null

"@types/node": "^16.3.0"

import { PrismaClient } from "@prisma/client";

// add prisma to the NodeJS global type
interface CustomNodeJsGlobal extends NodeJS.Global {
  prisma: PrismaClient;
}

// Prevent multiple instances of Prisma Client in development
declare const global: CustomNodeJsGlobal;

const prisma = global.prisma || new PrismaClient();

if (process.env.NODE_ENV === "development") global.prisma = prisma;

export default prisma;

error TS2694: Namespace 'NodeJS' has no exported member 'Global'.
4 interface CustomNodeJsGlobal extends NodeJS.Global

@types/node