Columns that not allowed to updated

Hi guys, I'm looking for a proper way to declare SQL schema and its InferModel types when there're columns that are not allowed to update programmatically. Will there be sth like uuid().const() or text().static(),... for that type of columns? and then InferModel will only accept updatable column. I'm new to SQL and drizzleORM, below is my current implementation. eg: one of that type of column is updated_at on attached image 1. I have a trigger & function to auto-update the updated_at column (img 2) that execute with the migrate script. For now, Im using Omit to InferModel to remove those columns from the update & insert types. Its quite inefficient if there are many such columns tho.
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server