gt/gte

lt/lte

let result = await prisma.post.findMany({
    where: {
      updatedAt: {
        gte: '2020-03-19T00:00:00+00:00',
        lte: '2020-03-19T23:59:59+00:00'
      }
    }
  })

organizationId String?

name String

@@unique([name, organizationId])

pg

pg

NOT/not/notIn

export const getUser = (id) => {
    return prisma.User.findUnique({
        where: { authId: id },
    });
};

include

select

include

select

export interface FindQuizzesByStatusInput {
  status: Status;
  take: number;
  after?: string | null;
  include?: { [key: string]: any }; // not great for type-safety!!!
}

export const findQuizzesByStatus = async (
  input: FindQuizzesByStatusInput
): Promise<Quiz[]> => {
  // ...
}

prisma.ts

declare global {
    var prisma: PrismaClient; // This must be a `var` and not a `let / const`
  }

import { PrismaClient } from '@prisma/client'
 let prisma: PrismaClient;
 if(process.env.NODE_ENV === 'production'){
    prisma = new PrismaClient();
}
 else{
    if(!global.prisma){
        global.prisma = new PrismaClient();
    }
    prisma = global.prisma
}  
 
export default prisma;  




graphl.ts

import { createServer , createPubSub } from '@graphql-yoga/node'
import { User } from '@prisma/client'
import type { NextApiRequest, NextApiResponse } from 'next'
import prisma from '../../lib/prisma'

const schema = {schema: {
    typeDefs: /* GraphQL */ `
    
      type User {
        lname: String
        fname: String
     }
   
    type Mutation{
      addUser(lname: String, fname: String): User!
    }
    `,
    resolvers: {
    
         Mutation: {
         addUser: async(parent: any,_: any) => {
           return await prisma.user.create(
            data:{
              lname:"coucou",
              fname:"salut"
            }
       )}  

    },
    
  }
}

i just want to add a new user in graphql with prisma but the resolver don't work                  <https://github.com/doddynicolas/try-prisma.git>

model Sale {

id        String            @id @default(uuid())

createdAt DateTime          @default(now())

updatedAt DateTime          @updatedAt

name      String

date      String

time      String

revenue   Int

amount    Int

invoice   String

}

prisma.sale.findMany({})

type Sale = Prisma.SaleGetPayload<{

include: {

commission: float

}

}>

model User {
  id      Int      @id @default(autoincrement())
  profile Profile?
}

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

PrismaClient

string

const sqlThatWouldHaveBeenExecuted: string = stringifyQueryAndDontExecute(await prisma.user.create({
  data: {
    name: 'Alice',
    email: '<mailto:alice@prisma.io|alice@prisma.io>',
  },
}))

model Stage {
  id        String    @id @default(cuid())
  code      String    @unique
  createdAt DateTime? @default(now())

  rewards Reward[]
}

type Reward {
  item_code String
  count Int
}

Error validating: Composite types are not supported on Postgres.

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

generator client {
  provider = "prisma-client-js"
}

Reward

model Stage {
  id        String    @id @default(cuid())
  code      String    @unique
  createdAt DateTime? @default(now())

  reward_item_codes String[]
  reward_item_counts Int[]
}

model Stage {
  id        String    @id @default(cuid())
  code      String    @unique
  createdAt DateTime? @default(now())

  rewards Json
}

pg_trgm

ftsIndexes: {
  "base.prisma:Post": {
     type: "GIN",
     indexes: [{ language: "english", field: "title", weight: "A"}]
  }
}

onDelete: Cascade

model Sale {

id        String            @id @default(uuid())

createdAt DateTime          @default(now())

updatedAt DateTime          @updatedAt

index     Int               @unique @default(autoincrement())

rank      Rank              @default(ROOKIE)

services  ServicesOnSales[]

}

model Service {

id        Int               @id @default(autoincrement())

createdAt DateTime          @default(now())

updatedAt DateTime          @updatedAt

name      String

provision String

sales     ServicesOnSales[]

}

model ServicesOnSales {

saleId       Int

serviceId    Int

createdAt    DateTime @default(now())

updatedAt    DateTime @updatedAt

subscription String

sale         Sale     @relation(fields: [saleId], references: [index], onDelete: Cascade)

service      Service  @relation(fields: [serviceId], references: [id], onDelete: Cascade)

@@id([saleId, serviceId])

}

enum Rank {

ROOKIE

MASTER

VETERAN

}

await prisma.sale.delete({

where: {

id

}

})

Generic type 'UserDelegate<GlobalRejectSettings>' requires 1 type argument(s).

BigInt.prototype.toJSON = () => {
  return this.toString();
};

message: "const result = await prisma.product.findMany(Inconsistent column data. Conversion failed: Value does not fit in an INT column, try migrating the 'revenue' column type to BIGINT"

[
   {
      "id": 1,
      "revenue": "[object Object]",
      ...
   }
   ...
]