model Organization {
  id        String   @id @default(cuid())
  name      String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  // Relation fields
  members User[]
}

name: string
memberIds: string[]

many

many-to-one

CREATE TABLE [Movie] (
  [id] int PRIMARY KEY,
  [title] nvarchar(255)
)

CREATE TABLE [User] (
  [id] int PRIMARY KEY,
  [username] nvarchar(255)
)

CREATE TABLE [Theater] (
  [id] int PRIMARY KEY,
  [theatre_name] nvarchar(255)
)

CREATE TABLE [Schedule] (
  [id] int PRIMARY KEY,
  [sdt] datetime,
  [movieId] int REFERENCES Movie (id),
  [userId] int REFERENCES User (id),
  [theatreId] int REFERENCES Theater (id)
)

model Movie {
  id       Int        @id @default(autoincrement())
  title    String
  Schedule Schedule[]
}

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

model Theatre {
  id       Int        @id @default(autoincrement())
  name     String
  Schedule Schedule[]
}

model Schedule {
  id        Int      @id @default(autoincrement())
  movieId   Int
  theatreId Int
  userId    Int
  date      DateTime
  movie     Movie    @relation(fields: [movieId], references: [id])
  theatre   Theatre  @relation(fields: [theatreId], references: [id])
  user      User     @relation(fields: [userId], references: [id])
}

dev

Uncaught TypeError: Failed to resolve module specifier ".prisma/client/index-browser". Relative references must start with either "/", "./", or "../".

$lib/prisma.ts

import Prisma, * as PrismaAll from '@prisma/client'
const pc = Prisma?.PrismaClient || PrismaAll?.PrismaClient
export const prisma = new pc()

adapter_vercel

vercel

createdAt

DATE_TRUNC('month', createdAt)

Prisma.WorkerScalarFieldEnum

Invalid `prisma.book.findMany()` invocation:

{
  include: {
    moods: true,
    ~~~~~
?   pairings?: true,
?   _count?: true
  }
}


Unknown field `moods` for include statement on model Book. Available options are listed in green. Did you mean `_count`?

npx prisma migrate dev

Mood

select
    user_id,
    sum(coalesce((properties->>'duration')::integer, 0)) as connection_duration
from
    events
where
    doc_id = '123'
    and event = 'disconnect'
group by
    user_id

const events = await this.prisma.event.groupBy({
  by: ['userId'],
  where: {
    docId: '123',
    event: 'disconnect',
  },
  _sum: {
    'properties->>duration': true
  },
})

(user, team)

memberships

INSERT IGNORE INTO ....

await prisma.membership.create({
      data: {
        permission: membership.permission.toUpperCase() as any,
        role: membership.role,
        state: MembershipState.JOINED,
        joinedAt: membership.createdAt,
        requestedAt: membership.updatedAt,
        user: {
          connect: {
            username: membership.user.username
          }
        },
        team: { connect: { slug: membership.team.slug } }
      }

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

model User {
  username            String?
  email               String?

  @@fulltext([username, email])
  @@fulltext([username])
  @@fulltext([email])
}

-- CreateIndex
CREATE INDEX `User_username_email_idx` ON `User`(`username`, `email`);

-- CreateIndex
CREATE INDEX `User_username_idx` ON `User`(`username`);

-- CreateIndex
CREATE INDEX `User_email_idx` ON `User`(`email`);

yarn prisma db push

Cannot find a fulltext index to use for the search

return await prisma.user.findMany({
    where: {
      username: input?.username && { search: input.username },
      email: input?.email && { search: input.email },
      type: input?.type,
    },
    select: {
      ...getSharedSelectableFields(),
    },
    take: input?.take,
    skip: input?.skip,
  });

db-testing-pool

https://youtu.be/vdYf_hv60h0▾

ts-node ./script.ts

type: 'module'

import

module: "CommonJS"

model Order {

id             Int         @id @unique @default(autoincrement())

products       Product[]   @relation(references: [id])

}

model Product {

id             Int         @id @unique @default(autoincrement())

orders         Order[]     // Why do I need this here? I don't really care about this, I only care about the above, products in an order. Can I get rid of this line somehow?

}

Other side is closed

$disconnect

$disconnect

Other side is closed