DT
Drizzle Team•10mo ago
sevenwestonroads

Psql Array of text and `createSelectSchema`, `createInsertSchema`

It seems that drizzle-zod - createInsertSchema and createSelectSchema cannot infer correctly an array of text. My column; 
colName: text('col_name').array()
colName: text('col_name').array()
Indeed, the type of the corresponding column of createSelectSchema or createInsertSchema results as z.ZodString instead of z.ZodArray<z.ZodString>. My workaround is to overwrite the inferred string of the corresponding column with an augment from zod. Any idea?
4 Replies
sevenwestonroads
sevenwestonroads•10mo ago
Thanks !!!
ByteBender
ByteBender•9mo ago
whom did you thanked?
sevenwestonroads
sevenwestonroads•9mo ago
I was thanking in advance @ByteBender 😂😂🙏
ByteBender
ByteBender•9mo ago
your thank wasted btw did you find any solution? I am thinking to join(',') and split(',') every time SkullPixel
Want results from more Discord servers?
Add your server
More Posts
Migration struggled at some snapshot (existed table), Can I skip it?As my understanding, Drizzle generate each database changes as snapshot. In my case migrate function`db:push` with `customType` causes data lossRunning db:push consecutively without changing the schema causes alterations and truncation, only foQuery depth issue Cloudflare D1I am encountering `Expression tree is too large (maximum depth 20)` issue mostly with relation queriupdate incrementing value (postgres)So, i have a table: ```javascript export const VisitorCount = pgTable('visitor-count', { id: bigseNull fields not working as expectedHi all, I am using Drizzle ORM with Zod validation for useForm, and I am running into issues with fType Generated from $inferInsert does not change after column type updateI have a table called `identities` in a schema called `identity`. When I changed the `phone_countryIs it possible to use INSERT statements inside a CTE (WITH query) +++ another question?In PostgreSQL, you're allowed to use other DML statements (e.g., insert, update, delete) inside a CTSQL_PARSE_ERROR with Turso + Drizzlegetting ```SQL string could not be parsed: near MINUS, "None"``` when running a push in development onConflictDoNothing is not returning valuesHey, Given the following query: ```javascript const competition = await db .insert(competitions)push:sqlite cannot find module 'better-sqlite3'im trying to hook up turso wind drizzle, and encounter thi error,