const test = await prisma.user.findMany();

# To reduce the image size we use a multi-stage build approach, see <https://bit.ly/3vMZjNu>.
### First stage ###
FROM node:lts AS builder

RUN apt-get install -y curl openssl

WORKDIR /app

COPY ./yarn.lock ./package.json ./

RUN yarn install --frozen-lockfile

COPY . .

RUN yarn prisma:generate
RUN yarn build

RUN npm prune --production

####################

### Second stage ###
FROM alpine:3.14.0

RUN apk add --update nodejs

RUN addgroup -S node && adduser -S node -G node

USER node

WORKDIR /home/node/app

COPY --from=builder --chown=node:node /app ./

EXPOSE 3000

CMD ["node", "dist/src/main.js"]

UnhandledPromiseRejectionWarning: Error: Unknown PRISMA_QUERY_ENGINE_LIBRARY undefined. Possible binaryTargets: darwin, darwin-arm64, debian-openssl-1.0.x, debian-openssl-1.1.x, rhel-openssl-1.0.x, rhel-openssl-1.1.x, linux-arm64-openssl-1.1.x, linux-arm64-openssl-1.0.x, linux-arm-openssl-1.1.x, linux-arm-openssl-1.0.x, linux-musl, linux-nixos, windows, freebsd11, freebsd12, openbsd, netbsd, arm, native or a path to the query engine library.
You may have to run prisma generate for your changes to take effect.
    at Object.getPlatform (/home/node/app/node_modules/@prisma/client/runtime/index.js:36103:13)
    at async Object.instantiateLibrary (/home/node/app/node_modules/@prisma/client/runtime/index.js:36094:21)

binaryTargets

debian-openssl-1.1.x

const usersWithCount = await prisma.user.findMany({
  select: {
    _count: {
      select: { posts: true },
    },
  },
})

prisma.create

createdBy

owner

select id, name, "categoryId", a."createdAt" from forum_post fp 
inner join (select "postId", max("createdAt") as "createdAt" from forum_post_reply group by "postId") a on a."postId" = fp.id 
order by a."createdAt" desc;

maxWait

timeout

maxWait

timeout

Object[ ]

unique field identifier

npx prisma studio

model.schema

Message: Error in Prisma Client request: 

Could not parse URL of the datasource
  
Query:
{
  "modelName": "User",
  "operation": "findMany",
  "args": {
    "take": 100,
    "skip": 0,
    "select": {
      "id": true,
      "name": true,
      "email": true,
      "image": true,
      "emailVerified": true,
      "Role": true,
      "accounts": true,
      "profile": true,
      "Program": true,
      "sessions": true,
      "profileId": true,
      "Announcement": true,
      "announcementId": true
    }
  }
}

//.env (data proxy setup)
MIGRATE_DATABASE_URL='<postgresql://me>...'
DATABASE_URL='<prisma://aws-us-east>...'

npx prisma db push

npx prisma studio

CREATE TABLE color (
    color_id INT GENERATED BY DEFAULT AS IDENTITY 
    (START WITH 10 INCREMENT BY 10), // <- this column
    color_name VARCHAR NOT NULL
);

model User {
  id         String  @id @default(cuid())
  name       String

}

model Chat {
  id String @id @default(cuid())

  user_id String
  user    User   @relation(fields: [user_id], references: [id])

  to_user_id String
  to_user    User   @relation(fields: [to_user_id], references: [id], name: "toUser")

  created_at DateTime @default(now())
  updated_at DateTime @updatedAt
}