ca:*

.prisma

model PostLevel {
  postLevelCode String
  countryCode   String
  languageCode  String
  postLevelName String

  @@id([postLevelCode, countryCode, languageCode])
  @@unique([postLevelCode, countryCode, languageCode])
}

model Profile {
  id          String @id
  countryCode String
  user        User?
}

model User {
  id           String  @id
  languageCode String
  profileId    String
  profile      Profile @relation(fields: [profileId], references: [id])
  posts        Post[]
}

model Post {
  id            String    @id
  postedById    String
  postedBy      User      @relation(fields: [postedById], references: [id])
  postLevelCode String
  postLevel     PostLevel @relation(fields: [postLevelCode], references: [postLevelCode, countryCode, languageCode])
}

postLevelName

Post

$queryRaw

INNER JOIN

const update = await prisma.user.update({
  where: {
    id: 6,
  },
  data: {
    posts: {
      updateMany: {
        where: {
          published: true,
        },
        data: {
          published: false,
        },
      },
    },
  },
})

published: false

updateMany

where

data

const update = await prisma.user.update({
  where: {
    id: 6,
  },
  data: {
    posts: {
      updateMany: {
        data: [
          { id: 5, published: false }, { id: 6, published: true }
        ],
      },
    },
  },
})

User

InternalUserProfile

User.type = INTERNAL

model User {
  id                  Int                  @id @default(autoincrement())
  type                UserType
  internalUserProfile InternalUserProfile?
}

model InternalUserProfile {
  user   User @relation(fields: [userId = User.id AND User.type = 'INTERNAL'], references: [id])
  userId Int
}

enum UserType {
  INTERNAL
  EXTERNAL
}

context.prisma.model.upsert({
      where: { id: undefined },
      update: args.data,
      create: args.data,
    })

{"error":{"clientVersion":"3.5.0"}}

Null constraint violation on the (not available)

(not available)

model User {
  id            String       @id @default(uuid())
  email         String?      @unique
  emailVerified DateTime?
  isPresenter   Boolean      @default(false)
  bio           String?      @db.LongText
  cellPhone     String?
  homePhone     String?
  firstName     String?
  middleName    String?
  lastName      String?
  permissions   Permission[]
  street        String?
  unit          String?
  city          String?
  state         State?
  zip           String?
  createdAt     DateTime     @default(now())
  updatedAt     DateTime     @updatedAt
  tickets       Ticket[]
  sessions      Session[]
  orders        Order[]
}

const user = await prisma.user.upsert({
  where: { email: '<mailto:your.email+fakedata47684@gmail.com|your.email+fakedata47684@gmail.com>' },
  update: {},
  create: {
    email: '<mailto:your.email+fakedata47684@gmail.com|your.email+fakedata47684@gmail.com>',
    firstName: 'Stan',
    lastName: 'Schamberger',
    street: '2100 Maymie Bridge',
    city: 'Stromanport',
    state: 'OR',
    zip: '17083'
  }
});

"prismaLayer\nodejs\node_modules\.prisma\libquery_engine-rhel-openssl-1.0.x.so.node"

"Error: Query engine library for current platform \"rhel-openssl-1.0.x\" could not be found.",
            "You incorrectly pinned it to rhel-openssl-1.0.x",
            "",
            "This probably happens, because you built Prisma Client on a different platform.",
            "(Prisma Client looked in \"/var/task/src/libquery_engine-rhel-openssl-1.0.x.so.node\")",
            "",
            "Searched Locations:",
            "",
            "  /.prisma/client",
            "  /home/runner/work/.../node_modules/@prisma/client",
            "  /var/task",
            "  /var/task/node_modules/.prisma/client",
            "  /var/task/node_modules/.prisma/client",
            "  /tmp/prisma-engines",
            "  /var/task/node_modules/.prisma/client",
            "",
            "You already added the platform \"rhel-openssl-1.0.x\" to the \"generator\" block",
            "in the \"schema.prisma\" file as described in <https://pris.ly/d/client-generator>,",
            "but something went wrong. That's suboptimal.",
            "",

customers

stores

schema.prisma

model Customer {
  id                     BigInt         @id @default(autoincrement())
  email                  String         @db.VarChar(255)
  encrypted_password     String
  first_name             String?        @default("") @db.VarChar(255)
  last_name              String?        @default("") @db.VarChar(255)
  reset_password_sent_at DateTime?
  reset_password_token   String?        @db.VarChar(16)
  status                 CustomerStatus @default(ACTIVE)
  created_at             DateTime       @default(now())
  updated_at             DateTime       @updatedAt
  store                  Store          @relation(fields: [store_id], references: [id])
  store_id               BigInt

  @@index([email, store_id])
  @@index([reset_password_token])
  @@index([email])
  @@index([store_id])

  @@map("customers")
}

model Store {
  id                 BigInt     @id @default(autoincrement())
  customer           Customer[]
  domain             String     @default("") @db.VarChar(255)
  locale             Locale     @default(US)
  region             String?    @db.VarChar(255)
  sender             String     @default("") @db.VarChar(255)
  shopify_store_name String?    @db.VarChar(255)
  created_at         DateTime   @default(now())
  updated_at         DateTime   @updatedAt

  @@map("stores")
}

enum CustomerStatus {
  ACTIVE      @map("active")
  ACTIVATING  @map("activating")
}

enum Locale {
  US  @map("en-US")
  UK  @map("en-GB")
}

npx prisma migrate dev --name  <migration name>

/*
  Warnings:

  - You are about to drop the `customer` table. If the table is not empty, all the data it contains will be lost.

*/
-- CreateEnum
CREATE TYPE "CustomerStatus" AS ENUM ('active', 'activating');

-- CreateEnum
CREATE TYPE "Locale" AS ENUM ('en-US', 'en-GB');

-- DropTable
DROP TABLE "customer";

-- CreateTable
CREATE TABLE "customers" (
    "id" BIGSERIAL NOT NULL,
    "email" VARCHAR(255) NOT NULL,
    "encrypted_password" TEXT NOT NULL,
    "first_name" VARCHAR(255) DEFAULT E'',
    "last_name" VARCHAR(255) DEFAULT E'',
    "reset_password_sent_at" TIMESTAMP(3),
    "reset_password_token" VARCHAR(16),
    "status" "CustomerStatus" NOT NULL DEFAULT E'active',
    "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" TIMESTAMP(3) NOT NULL,
    "store_id" BIGINT NOT NULL,

    CONSTRAINT "customers_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "stores" (
    "id" BIGSERIAL NOT NULL,
    "domain" VARCHAR(255) NOT NULL DEFAULT E'',
    "locale" "Locale" NOT NULL DEFAULT E'en-US',
    "region" VARCHAR(255),
    "sender" VARCHAR(255) NOT NULL DEFAULT E'',
    "shopify_store_name" VARCHAR(255),
    "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "stores_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE INDEX "customers_email_store_id_idx" ON "customers"("email", "store_id");

-- CreateIndex
CREATE INDEX "customers_reset_password_token_idx" ON "customers"("reset_password_token");

-- CreateIndex
CREATE INDEX "customers_email_idx" ON "customers"("email");

-- CreateIndex
CREATE INDEX "customers_store_id_idx" ON "customers"("store_id");

store_id

customers

CONSTRAINT FOREIGN KEY ("store_id") REFERENCES "public"."stores" (id)

store_id

id

Query interpretation error. Error for binding '6': Error occurred during query execution:
InterpretationError("Unable to convert expression result into a set of selection results", None)

First Model
Model A
 id
 name
 email
 description
 value1
 value2
 value3

Updated Model
Model A
 id
 name

Model B
 modelA_id
 modelB_id
 value

Model C
 id
 description
 label

export async function findUserByEmailAndPassword<
  Select extends Prisma.UserSelect,
>({ email, password }: UserData, select: Subset<Select, Prisma.UserSelect>) {
  const user = await findUserByEmail(email, { ...select, passwordHash: true })

  if (!user) {
    return null
  }

  const { passwordHash, ...userWithoutPasswordHash } = user

  if (!(await compareHash(password, passwordHash))) {
    return null
  }

  return userWithoutPasswordHash
}

type Subset<T, U> = {
  [Key in keyof T]: Key extends keyof U ? T[Key] : never
}

user

passwordHash

{ ...select, passwordHash: true }

Datasource "db": PostgreSQL database "sampletext", schema "public" at "loremipsum thisisntactuallythetextfromtheerror",
No migration found in prisma/migrations
Error: P3005
The database schema for `some string of database characters` is not empty. Read more about how to baseline an existing production database: <https://pris.ly/d/migrate-baseline>