DT
Drizzle TeamKeith

Setting triggers with drizzle

Hey, good day guys. I'm a web developer who recently picked up mysql and drizzle. Going through the drizzle docs now and I was wondering if there was a way I could set stored procedures and triggers in my sql database using drizzle?
evoshall
evoshall•18d ago
you can use the --custom flag to generate a blank SQL script that you can put stored procedures/triggers into https://orm.drizzle.team/kit-docs/commands#generate-migrations
Drizzle ORM - List of commands
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Keith
Keith•17d ago
Alright, I'll check it out. Thanks It worked, thanks mate
Want results from more Discord servers?
Add your server
More Posts
Multiple Where ClausesI need to filter my data based on various filters but only if they are not null. How can I do this, Enum as primary key for roles (sqlite)I'm pretty new to Drizzle and database schemas in general so bear with me if this is stupid. I'm crHow can I get a better structured response when querying a table (many to many)?Hi, I am new to sql. This might be obvious, but I'm not sure how to go about this. Below is a simplisql where column md5Hey, how can I achieve the following statement in drizzle? ```sql -- mysql SELECT * FROM podcasts_Error on Query Filter: Types of property 'table' are incompatible.I'm currently trying to filter a query as [explained in on the docs](https://orm.drizzle.team/docs/rHow to do Computed Fields / Manipulate data at Query Level?I'm looking for something like this, on prisma we can validate fields when querying the model. I coupgEnum conversion not working as expectedI have the following pgEnum defined: ``` export const ApprovalRequestTypePgEnum = pgEnum('approval_Filtering a jsonb with the shape Array<{id:string,name:string}>Hi. I have a query that returns all the posts with it's categories like this, ```typescript type Pos