Good morning y’all. Can you tell me why I am getti...
# orm-help
c
Good morning y’all. Can you tell me why I am getting ‘missing’ for all these scalar fields even though I used “?” to make them optional? Schema:
Copy code
model Campaign {
  id                   Int      @id @default(autoincrement())
  campaign_name        String   @unique @default(uuid())
  campaign_type        String   @default("direct")
  owner_id             Int      @unique @default(1)
  start_date           DateTime @default(now())
  sponsor_id           String?  @default(cuid())
  campaign_details     String?
  campaign_budget      Int?
  point_value          Int?
  s1_points            Int?
  s2_points            Int?
  s3_points            Int?
  s4_points            Int?
  s1_heading           Int?
  s2_heading           Int?
  s3_heading           Int?
  s4_heading           Int?
  website_click_points Int?
  email_lead_points    Int?
  grouping             String?
  campaign_header      String?
  campaign_thumb       String?
  web_click            Int?
  email_lead           String?
  password             String?
  a_or_b               String?
  sibling_id           String?  @default(cuid())
  h                    Int?
  createdAt            DateTime @default(now())
  updatedAt            DateTime @updatedAt
}
Error:
Copy code
32     const campaign = await prisma.campaign.create({
           data: {
             campaign_name: 'This is Test Campaign',
             campaign_type: 'Test type',
         +   campaign_details: String,
         +   campaign_budget: Int,
         +   point_value: Int,
         +   s1_points: Int,
         +   s2_points: Int,
         +   s3_points: Int,
         +   s4_points: Int,
         +   s1_heading: Int,
         +   s2_heading: Int,
         +   s3_heading: Int,
         +   s4_heading: Int,
         +   website_click_points: Int,
         +   email_lead_points: Int,
         +   grouping: String,
         +   campaign_header: String,
         +   campaign_thumb: String,
         +   web_click: Int,
         +   email_lead: String,
         +   password: String,
         +   a_or_b: String,
         +   h: Int,
         ?   owner_id?: String,
         ?   sponsor_id?: String,
         ?   sibling_id?: String,
         ?   createdAt?: DateTime,
         ?   updatedAt?: DateTime
           }
         })

Argument campaign_details for data.campaign_details is missing.
Argument campaign_budget for data.campaign_budget is missing.
Argument point_value for data.point_value is missing.
Argument s1_points for data.s1_points is missing.
Argument s2_points for data.s2_points is missing.
Argument s3_points for data.s3_points is missing.
Argument s4_points for data.s4_points is missing.
Argument s1_heading for data.s1_heading is missing.
Argument s2_heading for data.s2_heading is missing.
Argument s3_heading for data.s3_heading is missing.
Argument s4_heading for data.s4_heading is missing.
Argument website_click_points for data.website_click_points is missing.
Argument email_lead_points for data.email_lead_points is missing.
Argument grouping for data.grouping is missing.
Argument campaign_header for data.campaign_header is missing.
Argument campaign_thumb for data.campaign_thumb is missing.
Argument web_click for data.web_click is missing.
Argument email_lead for data.email_lead is missing.
Argument password for data.password is missing.
Argument a_or_b for data.a_or_b is missing.
Argument h for data.h is missing.

Note: Lines with + are required, lines with ? are optional.