Svante Bengtson
03/04/2022, 12:33 AMprisma chobo
03/04/2022, 5:47 AMprisma.user.create({ ... })
it gives me Property 'id' is missing in type
error.
model User {
email String @unique
password String?
roles Role[]
tokenVersion Int @default(0)
username String
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
deletedAt DateTime?
provider String?
providerId String?
id String @id
@@unique([provider, providerId])
}
prisma chobo
03/04/2022, 5:48 AMThe data needed to create a User.
prisma chobo
03/04/2022, 5:49 AMprisma chobo
03/04/2022, 5:50 AM@default(cuid())
this. But why prisma db pull does not generae @default(cuid())
??prisma chobo
03/04/2022, 5:53 AMmodel User {
id String @id @default(cuid())
email String @unique
password String?
provider String?
providerId String?
roles Role[]
tokenVersion Int @default(0)
username String
// *************** RELATIONS *****************
// *******************************************
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
deletedAt DateTime?
@@unique([provider, providerId])
}
and when i prisma db pull, it generates the following schema:
model User {
email String @unique
password String?
roles Role[]
tokenVersion Int @default(0)
username String
createdAt DateTime @default(now())
updatedAt DateTime @default(now())
deletedAt DateTime?
provider String?
providerId String?
id String @id
@@unique([provider, providerId])
}
which either I have to manually add @default(cuid())
or i have to insert ID manually when I create user object. Am I missing something here ? is it expected outcome?YeonHoPark
03/04/2022, 7:33 AMJosh
03/04/2022, 8:34 AMuser
03/04/2022, 9:02 AMLucas Souza
03/04/2022, 1:28 PMManikanta Talluri
03/04/2022, 5:00 PMDATABASE_URL=sqlserver://<HOST>:<PORT>;database=<DB_NAME>;user={<USERNAME>@<AD_DOMAIN>};password={PASSWORD};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.<http://database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword|database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword>
Juan Orellana
03/04/2022, 8:42 PMuser
03/05/2022, 9:01 AMPhilipp Minder
03/05/2022, 10:52 AMdevabd
03/05/2022, 9:33 PMEnvironment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Error: Get config: Schema Parsing P1012
error: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`.
--> schema.prisma:10
|
9 | provider = "postgresql"
10 | url = env("DATABASE_URL")
|
Validation Error Count: 1
Jonas
03/06/2022, 9:49 AMorderBy
a date field?Jonas
03/06/2022, 9:50 AMorderBY
a date field? Because it doesn't seem to work right now for me.user
03/06/2022, 10:00 AMSteven
03/06/2022, 10:21 AMEdwinJr
03/06/2022, 11:07 AMEdwinJr
03/06/2022, 11:10 AMMuhammad Ameer Hamza
03/06/2022, 1:33 PMJakub Figlak
03/06/2022, 3:39 PMmodel ExampleModel {
id String @id @default(cuid())
someValue Int
otherValue Int
}
how can I query for entities where
someValue === otherValue
?Gonzalo iniguez
03/06/2022, 5:05 PMGonzalo iniguez
03/06/2022, 5:05 PMGonzalo iniguez
03/06/2022, 5:05 PMGonzalo iniguez
03/06/2022, 5:05 PMBernat Jufré
03/06/2022, 9:28 PMJonas Rothmann
03/07/2022, 12:59 AMJijin P
03/07/2022, 3:23 AMError: Invalid `prisma_1.default.ads.findMany()` invocation in /usr/src/app/dist/api/offerwall/getClickCampaigns.js:16:50
Attempted to serialize scalar ‘null’ with incompatible type ‘Decimal’ for field points.
at Object.request (/usr/src/app/node_modules/@prisma/client/runtime/index.js:39813:15)
at async PrismaClient._request (/usr/src/app/node_modules/@prisma/client/runtime/index.js:40637:18)
at async getClickCampaigns (/usr/src/app/dist/api/offerwall/getClickCampaigns.js:16:23)