schema.prisma

Error parsing attribute "default": The 'autoincrement()' default function is defined only on BigInt fields on CockroachDB. Use sequence() if you want an autoincrementing Int field.

autoincrement

npx prisma migrate dev --name init
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": CockroachDB database "undefined", schema "public" at "localhost:26257"

Error: P1000: Authentication failed against database server at `localhost`, the provided database credentials for `(not available)` are not valid.

Please make sure to provide valid database credentials for the database server at `localhost`.

gte

lte

The following migration(s) have been created and applied from new schema changes:

migrations/
  └─ 20220629115129_init/
    └─ migration.sql

Your database is now in sync with your schema.

Running generate... (Use --skip-generate to skip the generators)
Error: Get DMMF: Schema parsing - Error while interacting with query-engine-node-api library
Error code: P1012
error: Datasource provider not known: "cockroachdb".
  -->  schema.prisma:6
   | 
 5 | datasource db {
 6 |   provider = "cockroachdb"
   | 

Validation Error Count: 1

npx prisma generate
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Error: Get DMMF: Schema parsing - Error while interacting with query-engine-node-api library
Error code: P1012
error: Datasource provider not known: "cockroachdb".
  -->  schema.prisma:6
   | 
 5 | datasource db {
 6 |   provider = "cockroachdb"
   | 

Validation Error Count: 1

Prisma CLI Version : 4.0.0

@prisma/client

4.0.0

model ServiceMembership {
  service             Service    @relation(fields: [serviceId], references: [serviceId])
  serviceId           Int        @map("service_id")
  membership          Membership @relation(fields: [membershipId], references: [membershipId], onDelete: Cascade)
  membershipId        Int        @map("membership_id")
  assignedAt          DateTime   @default(now()) @map("assigned_at")
  prices              Price[]

  @@id([serviceId, membershipId])
  @@map(name: "service_membership")
}

model Price {
  priceId             Int               @id @default(autoincrement()) @map("price_id")
  serviceMembership   ServiceMembership @relation(fields: [serviceMembershipId], references: [serviceId, membershipId])
  serviceMembershipId Int               @map("service_membership_id")

prisma db seed

select
  ra.company_id as company_id,
  ra.user_id as user_id,
from companies as cs
join users as us  on cs.id = us.company_id
where 
  user.score >= ${score}
  ${replacableCondition}
;

@unique

@unique

String

mode

@unique

<mailto:ceo@corp.com|ceo@corp.com>

<mailto:CeO@corp.com|CeO@corp.com>

jack

jaCk

citext

citext

const types = [
  'model1',
  'model2',
] as const;


return client[field].findMany({
  where: {
    verified: true,
  },
});

error TS2349: This expression is not callable.
  Each member of the union type '(<T extends SkillTagFindManyArgs>(args?: SelectSubset<T, SkillTagFindManyArgs>) => CheckSelect<T, PrismaPromise<SkillTag[]>, PrismaPromise<...>>) | ... 4 more ... | (<T extends InterestFindManyArgs>(args?: SelectSubset<...>) => CheckSelect<...>)' has signatures, but none of those signatures are compatible with each other.

brands

image

image_id

const options = {
  image: {
    select: {
      id: true,
      source: true,
      dtype: true,
     },
   },
}

const brands = await PrismaService.brand.findMany(options);

brands

brand[]

image

export type brand = {
  id: string
  name: string | null
  image_id: string | null
  created_at: Date | null
  updated_at: Date | null
  deleted_at: Date | null
}

b.image

Property 'image' does not exist on type 'brand'.

brands.forEach((b) => console.log(b.image))