DT
Drizzle Team•16mo ago
NeonCop

uuid's being inferred as strings

When I use InferModel on a table that has a uuid type, I see that the column gets inferred as a string instead of as a uuid type. Seems like the migrations are correctly using the native postgres uuid type, so confused why it's not being returned as a UUID
3 Replies
bloberenober
bloberenober•16mo ago
TypeScript doesn't have a dedicated type for UUID, so it's represented as a string.
NeonCop
NeonCop•16mo ago
hmmm so the right way to do it would be to use something like zod to validate / generate the typescript types? guessing this will make sense once Select schema goes live
bloberenober
bloberenober•16mo ago
It depends on your use case, but in general yes, the ORM doesn't validate the values you pass to it at runtime, only on type level
Want results from more Discord servers?
Add your server
More Posts
Any easy way to create a typescript ENUM type from pgEnum?Prisma used to auto-gen all the enum types as well which are heavily used in our application.Plans to add array related support for Postgres?+ features to append an object to an array field in postgres?Migrating from PrismaHi, I have an existing project already in production built using prisma and postgres (supabase). I aNumeric // Decimal Postgres types are inferred as strings and expect string as an input as wellCannot read properties of undefined (reading '0')What is the expected behavior when using `get()` when there would be no matching results for a giveIs it recommended to create a SQL transaction every time we try to create a foreign relationship?prisma used to wrap every foreign upsert (2 entities) within a transaction to guarantee that both roDoesn't drizzle-kit generate:pg work yet when schema imports from esm package?``` > drizzle-kit generate:pg --out src/db/migrations --schema src/db/schemas drizzle-kit: v0.17.0 Is there `.returning()` in insert statement in MySQL like SQLite?There is `.returning()` insert statement in SQLite but MySQL not. how do I `.returning()` in insert