version: '3.8'

services:
  postgres:
    container_name: test-postgres
    image: kartoza/postgis:14-3.3--v2022.08.30
    ports:
      - 15432:5432
    environment:
      - POSTGRES_USER=admin
      - POSTGRES_PASSWORD=secret
      - POSTGRES_DB=test-db
    volumes:
      - postgis-data:/var/lib/postgresql

volumes:
  postgis-data:

DATABASE_URL="<postgresql://admin:secret@localhost:15432/test-db?schema=public>"

const user = await this.prismaService.user.findUnique({
      where: {
        id: userId,
      },
      select: {
        managing: {
          select: {
            user: {
              select: {
                person: true,
              },
              include: {
                notifications: {
                  where: {
                    dismissAt: null,
                  },
                },
              },
            },
          },
        },
      },
    });

OR

await prismaClient.objective.findMany({
      where: {
        patientId: id,
        OR: { // replace with AND makes no difference
          branchingOptionId: { not: null },
          conversationItemId: { not: null },
        },
      },
    });

 // generates: SELECT Objectives.id, ... WHERE (Objectives.patientId = 1 AND Objectives.branchingOptionId IS NOT NULL AND Objectives.conversationItemId IS NOT NULL)

TS2531: Object is possibly 'null'.
TS2345: Argument of type 'JsonValue' is not assignable to parameter of type 'string'.   Type 'null' is not assignable to type 'string'.

JSON.parse(fetchedValue ?? '{}');

TS2345: Argument of type 'string | number | boolean | JsonObject | JsonArray' is not assignable to parameter of type 'string'.   Type 'number' is not assignable to type 'string'.

this.$on('query', (event) => {
  this.logger.debug(`Query: ${event.query}`, PrismaService.name);
}

DateTime

model Review {
  id          String   @id @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  comment     String
  score       Int
  wine        Wine @relation(fields: [wineId], references: [id], onDelete: Cascade)
  wineId      String
  reviewer    WineUser @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId      String
}

let db: PrismaClient;
//Prismaclient is imported from elsewhere

...

const reviews = await db.review.findMany({
    take: 1,
  });
console.log({reviews})

reviews: [
    {
      id: '00715d17-19ea-429d-8d04-cc0afe4f0b53',
      createdAt: '2022-09-27T18:46:08.953Z',
      updatedAt: '2022-09-27T18:46:08.953Z',
      comment: 'Mycket prisvärt. Viss fatkaraktär. Körsbärstoner. Inte så kraftigt.\n' +
        'Alk.: 13.50%',
      score: 7,
      wineId: '5b4fd795-4c82-4b78-b568-eb72754f6ab2',
      userId: '8a65f07b-6357-45b4-9fb7-c13ca989053a'
    }
  ]

model User {
    @ComputedProperty(firstName, lastName)
    fullName string
}

prisma generate

const website = await prisma.website.create({
      data: {
        name: name,
        domain: domain,

        users: {
          connect: {
            userId: userId,
            role: 'owner'
          }
        },
      },
    })

No cast exists, the column would be dropped and recreated, which cannot be done since the column is required and there is data in the table.

user_id

user_posts

users

model users {
  id               BigInt   @id @default(autoincrement())
  user_name        String?  @db.VarChar
  tenant_id  	   Int?
}

model user_posts {
  id                BigInt    @id @default(autoincrement())
  post_id           Int?
  user_id           Int?
  tenant_id  		Int?
}

create table todos (
  id bigint generated by default as identity primary key,
  user_id uuid references auth.users not null,
  task text check (char_length(task) > 3),
  is_complete boolean default false,
  inserted_at timestamp with time zone default timezone('utc'::text, now()) not null
);
alter table todos enable row level security;
create policy "Individuals can create todos." on todos for
    insert with check (auth.uid() = user_id);
create policy "Individuals can view their own todos. " on todos for
    select using (auth.uid() = user_id);
create policy "Individuals can update their own todos." on todos for
    update using (auth.uid() = user_id);
create policy "Individuals can delete their own todos." on todos for
    delete using (auth.uid() = user_id);

const items = await prisma.items.findMany({
    take: 12, orderBy: { title: 'asc' },
    include: {
        _count: {
            select: {
                votes: { where: { isUp: true } },
                votes: { where: { isUp: false } }, // ???
            }
        }
    }
});