what do folks do about reference data? like standard lists of things in tables etc.. do you just hack your migration.sql to add the necessary insert/updates or is there a better way to do it?

Hey folks, I have User model with nullable “name” How to query for Users that defined their names?

const users = await prisma.users.findMany({
    where: {
      name: // not null
    }
  })

For @autoincrement(), can i select a starting value?

Hey folks, what would be the right way to instantiate Prisma Client in NestJs while running in AWS Lambda? Please suggest.

I have a schema that looks like this:

model User {
  id          Int       @id @default(autoincrement())
  createdAt   DateTime  @default(now())
  username    String    @unique
  password    String
  userUUID    UserUUID?
}

model UserUUID {
  id     String @id @default(uuid())
  user   User   @relation(fields: [userId], references: [id])
  userId Int    @unique
}

I want to add an entry to UserUUID if one is not present for the provided username, how can i achieve that? I tried with the following but it complains about not being able to uniquely identify a user.

await prisma.userUUID.upsert({
        where: {
            user: {
                username: username.toLowerCase()
            }
        },
        update: {},
        create: {
            user: {
                connect: {
                    username: username.toLowerCase()
                }
            }
        }            
    });

Anyone knows how i can acheive this? Reason for having a UserUUID is that it should not always be present for every user, only users that have activated that feature.

is the

transaction

comparable with

Promise.all()

, if yes, does multiple prisma queries with with

Promise.all()

?

Why is a model required to have an @id or @unique constraint?

Shouldn't developer be able to choose whether they want such a constraint on their model?

hi, can someone tell me where i can look up @db decorators? I'm trying to upgrade from 27 to 28, have mongodb and @db.array is no more

Hey, what can I do about this error?

Hey all. Is it possible to have where params like ? I'm looking at the docs and it seems I can only have 1 of AND, OR, NOT, etc and not more complex logic.

{
  parentId: null,
  userId: 1234
  deletedAt: null,
  filterSize: {
    { filterSize: { lte: 199 }, },
    OR: { filterSize: { gte: 200 } }, { filterSize: { lte: 799 } },
    OR: { filterSize: { gte: 800 } }
  }
}

Docs: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#and Maybe something like:

AND: {
   OR: [
      { filterSize: { lte: 199 }, },
      { filterSize: { gte: 200 } }, { filterSize: { lte: 799 } },
      { filterSize: { gte: 800 } }
   ]
}

Just trying to get help from community.

hi, if i have a schema and a database login, how can i automatically generate a blank database from my table schema using prisma?

i tried doing an initial migration but it didn’t save anything

never mind think i got it

Hello guys! I want to search through a DateTime for a specific date in Date format, in SQL I should do it with a between, how can I do it with the ORM?

Trying to filter on a subarray where both are true.

License: {
              some: {
                AND: [
                  {
                    LicenseTypeID: 2
                  },
                  {
                    LicenseTypeID: 3
                  }
                ]  
              }

There are records that meet the criteria, but this returns nothing. Any suggestions how to get the "some" to work with the AND?

Hey is 2.29.0 tomorrow? Can someone pls confirm? Thanks

Can

include

return an object instead of an array of objects?

i get this warning….

warn(prisma-client) Already 10 Prisma Clients are actively running.

What's new in Prisma (v2.29.0) Daniel from the Prisma team discusses news in the Prisma ecosystem. Tune in to learn about new releases, planned features, and other interesting bits from the Prisma world. Learn more about Prisma: ◭ Website: https://www.prisma.io​​​​ ◭ Docs: https://www.prisma.io/docs​​​​ ◭ Quickstart:https://www.prisma.io/docs/getting-started/quickstart

Does the Prisma team have a relationship with the typescript team? I've got an issue that is probably more of a typescript performance issue than an actual Prisma issue. Trying to figure out if I should just open an issue in the TS repo, or if it would have more weight coming from someone working on Prisma.

Hello, I need more recent examples of Prisma, Nestjs, AppolloServer , GraphQL

hi please, I am trying to create a 1-to-1 relationship between two tables Traveler and Passport, and this is my schema.

model Passport {
  passportId        Int      @id @default(autoincrement())
  passportNo        String
  nationality       String
  issuingCountry    String
  expiryDate        DateTime
  gender            String
  firstName         String
  lastName          String
  otherNames        String
  dateOfBirth       String
  isTravelCompanion Boolean?
  userId            Int? // relation scalar field  (used in the `@relation` attribute below)
  user              User?    @relation(fields: [userId], references: [id])

  //Passport relation
  traveller Traveller?

  @@map(name: "passport")
}

model Traveller {
  travellerId   Int          @id @default(autoincrement())
  title         String
  firstName     String
  lastName      String
  countryCode   String
  phoneNo       String
  address       String
  state         String
  country       String
  bookingRef    String
  travellerType String?      @default("adult")
  price         String
  currency      String
  isUser        Boolean      @default(false)
  userId        Int? // relation scalar field (used in the '@relation()` attribute below)
  user          User?        @relation(fields: [userId], references: [id])
  flightBooking FlighBooking @relation(fields: [bookingRef], references: [bookingRef])

  // passport relations
  passportId Int
  passport   Passport @relation(fields: [passportId], references: [passportId])

  @@map(name: "traveller")
}

but it shows this error when i run migrate,

Error:

:warning: We found changes that cannot be executed:

`• Step 1 Added the required column

passportId

to the

traveller

table without a default value. There are 15 rows in this table, it is not possible to execute this step.` can someone please tell where I went wrong ?

This message was deleted.

Hi, can someone explain what the name does on @relation ? Is it a naming of the relation? Can it be anything, why is it even needed?

I'm trying to simulate this query:

select * from DamFile
where deletedAt is null
and (filterSize between 1 and 199 or filterSize between 200 and 799 or filterSize >= 800);

With this JS Object:

AND: [
   { OR: [{ AND: [{ filterSize: { gt: 0 } }, { filterSize: { lte: 199 } }] }] },
   { OR: [{ AND: [{ filterSize: { gte: 200 } }, { filterSize: { lte: 799 } }] }] },
   { OR: [{ filterSize: { gte: 800 } }] },
],

Unfortunately I'm not getting any results. Am I able to do complex queries like this using nested conditionals? Thanks

Is it possible to pass in a single value to createMany and it'll still work ?

how to filter null property inside where?

const id = req.user.id;

        const myBookings = await prisma.traveller.findMany({
            where: {
                userId: id
            },
            select: {
                flightBooking: true
            }
        });

Hi pls I have this query, but there are multiple

travellers

that may have the same

flightBooking

, so it would return the same

flightBooking

details multiple times if different travellers have it. Is there a way I can optimize this query to return just one instance of

flightBooking

or not duplicate it if it has already returned it?