DT
Drizzle Team•16mo ago
tacomanator

createInsertSchema wrong type (drizzle-zod 0.3.1, sqlite))

After upgrading to 0.3.1, all of the fields changed to ZodTypeAny
6 Replies
bloberenober
bloberenober•16mo ago
did you update drizzle-orm as well?
tacomanator
tacomanator•16mo ago
Yes, to 0.24.1
bloberenober
bloberenober•16mo ago
could you post your table definition?
tacomanator
tacomanator•16mo ago
export const StatusUpdate = sqliteTable("StatusUpdate", { id: cuid2("id").primaryKey(), author: text("author") .notNull() .references(() => User.id), createDate: now("date").notNull(), applicationId: text("applicationId") .notNull() .references(() => Application.id), type: text("type", { enum: statusUpdateTypes }).notNull(), statusDate: text("statusDate").notNull(), note: text("note").notNull(), }); export const statusUpdateInsertSchema = createInsertSchema(StatusUpdate).omit({ id: true, author: true, createDate: true, });
bloberenober
bloberenober•16mo ago
yep, confirmed the issue happens in mysql, too tests were too broad and didn't catch this working on the fix @tacomanator fixed in 0.3.2
tacomanator
tacomanator•16mo ago
confirmed, thank you!
Want results from more Discord servers?
Add your server
More Posts
How do I get the values of an insert inside a transaction?I have this transaction where I create a project and add variables and a history of those variables.Raw sql`` quoting issueHi, I doing a work around until Drizzle supports generated columns. I have a manual script that addsNuxt3 type errorHello, is there somebody who used Drizzle in Nuxt3 project? I have problem with inheriting types froSyntax error mysql migration using composite primary key```sql --> statement-breakpoint CREATE TABLE `member_to_address` ( `member_id` varchar(32) NOT Nwhen using planetscale, using the `.$with()` and `.with()` clauses causes errorIs it not possible to use `$with()` and `with()` with planetscale? it gives the following error: `DaZod prototype mismatchEven though the Zod object constructor name created by Drizzle is ZodObject, it is not an instanceofunrecognized_keysGetting the following error when running generate:pg ``` ZodError: [ { "code": "unrecognized_kRaw SQL / Postgres stored generated column in schemaIs it possibile to add raw sql, or more specifically stored generated columns to the schema? Trying I think i have found another bugtypescript complaining when there's no overridingCustom getter/setter for model's propertyHi, are there any plans for custom getters? (like in TypeORM `transformer`)