TTC
Theo's Typesafe Cult•7mo ago
Jim

enum status table schema

Hey all, using drizzle + pscale + next. I'm making a CRM which has a status field for all records which are predefined (e.g. "verified", "shipped", "complete", "rejected".etc). I'm having trouble getting my head around how to get my zod schema to match up with these possible statuses. In drizzle and mysql there is an ENUM column type, but I would prefer to keep the possible statuses in a table. Does anyone know a good approach for this? Thanks!
1 Reply
Jim
Jim•7mo ago
I suppose im looking for a way to treat data on the table as a schema, with the source of truth in a schema file, which would need to be migrated if anything changed. Drizzle for data... Is this silly? ENUM looks like its the way, cheers
Want results from more Discord servers?
Add your server
More Posts
CSP with NextJs 14 and expressHello, I am having a problem with CSP when using NExtjs with custom express server. I use app routerWebSocket Reverse proxyI am using this library `http-proxy-middleware` to hide my actual websocket server. Proxy url = 'wsCode structure and system designHi, I'm have a application building with Nextjs that have 3 site: customer admin agent. Currently I'how to revalidate data?Router.refresh() purges all the caches if I understand correctly. How would you invalidate a cache aSitemaps - Is there something fundamental i'm misunderstanding about sitemaps?Hello! I'm currently exploring how to best generate dynamic sitemaps for a Next.js-powered website.useRouter import not working?just following the docs and trying to add shallow routing. In my app/page.tsx i have the following use query on success/error/settled are being deprecated.Since the above call backs are being deprecated, I'm attempting to implement the suggested solution TRPC pass res to ctx using app routerI used the template provided by trpc, ctx doesn't contain req or res. I managed to pass the req but