DT
Drizzle Teamistorry

Issue with drizzle-zod?

Schema 
export const testinArray = pgTable("testing_array", {
  id: varchar("id", { length: 14 })
    .primaryKey()
    .$defaultFn(() => nanoid(14)),
  names: text("names").array(),
});
export const testinArray = pgTable("testing_array", {
  id: varchar("id", { length: 14 })
    .primaryKey()
    .$defaultFn(() => nanoid(14)),
  names: text("names").array(),
});
const testingSchema = createInsertSchema(testinArray);
const data = { names: ["test1", "test2"] };
const newData = testingSchema.parse({ ...data });
db.insert(testinArray).values(newData).execute();
const testingSchema = createInsertSchema(testinArray);
const data = { names: ["test1", "test2"] };
const newData = testingSchema.parse({ ...data });
db.insert(testinArray).values(newData).execute();
No overload matches this call.
  Overload 1 of 2, '(value: { id?: string | SQL<unknown> | Placeholder<string, any> | undefined; names?: string[] | SQL<unknown> | Placeholder<string, any> | null | undefined; }): PgInsert<...>', gave the following error.
      Type '{ id?: string | undefined; names?: string | null | undefined; }' is missing the following properties from type '{ id?: string | SQL<unknown> | Placeholder<string, any> | undefined; names?: string[] | SQL<unknown> | Placeholder<string, any> | null | undefined; }[]': length, pop, push, concat, and 35 more.ts(2769)
const newData: {
    id?: string | undefined;
    names?: string | null | undefined;
}
No overload matches this call.
  Overload 1 of 2, '(value: { id?: string | SQL<unknown> | Placeholder<string, any> | undefined; names?: string[] | SQL<unknown> | Placeholder<string, any> | null | undefined; }): PgInsert<...>', gave the following error.
      Type '{ id?: string | undefined; names?: string | null | undefined; }' is missing the following properties from type '{ id?: string | SQL<unknown> | Placeholder<string, any> | undefined; names?: string[] | SQL<unknown> | Placeholder<string, any> | null | undefined; }[]': length, pop, push, concat, and 35 more.ts(2769)
const newData: {
    id?: string | undefined;
    names?: string | null | undefined;
}
istorry
istorry•247d ago
const newData: { id?: string | undefined; names?: string | null | undefined; } names should be names?: string[], instead of string?
istorry
istorry•247d ago
No description
Want results from more Discord servers?
Add your server
More Posts
Optional One-to-One RelationCurrently it's possible to define only a One-to-One relation (https://orm.drizzle.team/docs/rqb#one-Having Issues Pushing Database SchemaHi I am getting this issue whenever I am trying to push the database schema. Any help would be greatmigration failedcode: ```js const migrationClient = postgres("postgresql://jer:admin@localhost:5432/test", { max: 1TypeError: Cannot read properties of undefined (reading 'compositePrimaryKeys')I am attempting to run db push, but I am getting this error above^^ does anyone know what might be Nesting sqlite drizzle into a deeper location in my ts app, difficulties with src/ vs dist/Hey! I'm very new to drizzle and trying to set up a very small drizzle instance for a service that rsyntax highlighting not workingI reinstalled the node_modules multiple times and it didnt fix my problem. This isnt suposed to look