DT
Drizzle Team•16mo ago
McLean 25

Return first or throw

I have a hard time believing this hasn't been asked yet, but my search results have yet to yield anything. Is it not possible (or planned) to do something like: 
const firstItem = db.select().from(users).where(eq(users.id, userId)).takeFirstOrThrow()
const firstItem = db.select().from(users).where(eq(users.id, userId)).takeFirstOrThrow()
2 Replies
McLean 25
McLean 25•16mo ago
The idea here being, that firstItems type will be User, and not User[] OK, finally found what I was looking for here: https://discord.com/channels/1043890932593987624/1085317796654764092
bloberenober
bloberenober•16mo ago
Not planned in the core library, but will probably be present in the convenience API layer on top.
Want results from more Discord servers?
Add your server
More Posts
Can't find meta/_journal.json file when running migrateTrying to run `migrate()` from a lambda function and I can't figure out why it's unable to find the Wrong type on decimalsHello, I have encountered something interesting. The first screenshot shows what I'm inserting into CheckHello there, from this discussion: https://discord.com/channels/1043890932593987624/1090486363251544cascadesI know you can add `.references()` to set up foreign keys in a table definition, but how do you set jsonb field definition.What's the right way to define a jsonb field? I have a type `type MetaData = {keywords?: string[];}"Extend" tables by other tablesHey all, first of all great work with drizzle. Haven't had the time to play around with it so far. Bmaximum call stack exceededWeird bug where whenever I add a `where` `eq` clause getting maximum call stack exceededDrizzle recommended way to migrate resetApologies if this is a stupid question, I just recently migrated out of prisma and into drizzle. One