DT
Drizzle Team•3mo ago
TJBlackman

Make varchar field one of string union

I know that CHECK constraint hasn't been implemented yet, but I want to implement a Role field that is a varchar that can only be set to "user", "paid-user", or "admin" and I want the schema definition in TS to reflect this. I know this wont set the constraint at the DB level, but I want to TS definition to reflect that only the above union of strings are valid. How can I tell drizzle that this field should be this specific TS type? 
 role: varchar("role", { length: 50 }).notNull(), // user|paid-user|admin
 role: varchar("role", { length: 50 }).notNull(), // user|paid-user|admin
4 Replies
megamindat
megamindat•3mo ago
You can declare enum for that. https://orm.drizzle.team/docs/sql-schema-declaration
Drizzle ORM - Overview
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
⚡Z.E.U.S⚡
⚡Z.E.U.S⚡•3mo ago
Yes, you can add enum field for varchar, but it won’t throw an error(only types) when you inserting if the value is wrong. https://orm.drizzle.team/docs/column-types/pg#varchar Or you can create pgEnum/mysqlEnum https://orm.drizzle.team/docs/column-types/pg#enum https://orm.drizzle.team/docs/column-types/mysql#enumcolumn
Drizzle ORM - PostgreSQL column types
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Drizzle ORM - MySQL column types
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
TJBlackman
TJBlackman•3mo ago
Thank you both! I am choosing to use the pgEnum feature. An enum is saved in the DB as an integer, correct? I'm using postgres...
megamindat
megamindat•3mo ago
That's saved as a string.
Want results from more Discord servers?
Add your server
More Posts
base generic repositoryHey guys! I'm really struggling to create a base crud repository which i can use as a base class forone-to-many self referenceHello guys, this is a simplified section of my schema: ``` typescript export const contacts = mysqlTEnforcing DB level foreign keysHey guys, I've read the docs on the relation key word and the docs note that the relations are only Nested SQL select returning [x: string]: unknown typeThis may also be delving into SQL-specific questions, but I have a complex query where I'm joining tdrizzle-graphql - buildSchema doesn't support `ApolloFederationDriver`**Context** I'm building a NestJS microservice application with GraphQL using `ApolloFederationDriveFetching id from recently inserted dataDoes Drizzle return the insertId if it is a UUID or a nanoid, and not a number, if not how do I get Subquery in Deletewhat is the correct way to write a delete statement with a subquery? example not working: ``` uuid becomes text in migrationIn my schema i have a user table (based on auth.js requirements): ```ts export const users = pgTableany idea of how to implement sqlcommenter like functionality?Want to use with cloudsql something like this any hint is helpful: https://google.github.io/sqlcommeNot enough information to infer relationI've defined these relation between section and item, and I'm getting "Error: There is not enough in