DT
Drizzle Team•4mo ago
swiecki

CI/CD check if schema matches database

Hi, is there a way use drizzle-kit or drizzle itself to check if the database structure matches the schema. Right now I'm posting a comment if schema.ts is changed reminding my team to submit a planetscale deploy request, but if they update the PR the comment gets posted again. I'd like to only post it if the deploy database isn't updated yet. Is this possible?
2 Replies
MAST
MAST•4mo ago
Does drizzle-kit check do what you're looking for?
MAST
MAST•4mo ago
https://orm.drizzle.team/kit-docs/commands#check
Drizzle ORM - List of commands
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Want results from more Discord servers?
Add your server
More Posts
'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")When I use , it generates my schema.ts file, but includes syntax that is invalid, such as: ``` expoCan I create a one to one relationship that would actually fetch the last item?The relationship is actually a one to many but only want to retrieve the last one. goal: one(goalclasses to access dbIs this code possible? Copilot says it's valid but I cannot find it in the documentation ``` importQuery "with" not populatedI have a collection relation and a file relation. I want to query a collection and all their files. Duplicate parentHey, I have a large schema with many tables and many relations. I would like to duplicate a parent rDynamic read replicasI have a use case that read replicas are dynamically located using Service Discovery and I need to s