Topics

Theo's Typesafe Cult•8mo ago

Drizzle Schema Boolean

Hi everyone, I'm trying to create a schema in Drizzle but my SQL knowledge is pretty limited. I want to have a boolean like isProtected and if this is true then store some other information in other columns. I dont know how to handle a situation like this.

  isProtected: boolean('is_protected').default(false).notNull(),
  contentType: mysqlEnum('content_type', [
    'application/vnd.apple.mpegurl',
    'text/xml',
  ]),
  contentUrl: text('content_url'),

  isProtected: boolean('is_protected').default(false).notNull(),
  contentType: mysqlEnum('content_type', [
    'application/vnd.apple.mpegurl',
    'text/xml',
  ]),
  contentUrl: text('content_url'),

I want to have these contentType and contentUrl columns to contain value only when isProtected is true. Basically, Is there a way to make sure that when I set to isProtected true Typescript will force me to add other related columns ?

Solution:

Generated columns are just made from combining data already in the table, https://stackoverflow.com/questions/10273750/sql-conditional-not-null-constraint should answer your question as far as i can tell

Stack Overflow

Sql Conditional Not Null Constraint

I am curious to know is it possible to create a conditional not null constraint in sql? In otherwords is it possible to create a constraint such that a column B can be null as long column A contain...

Jump to solution

6 Replies

Efkan•8mo ago

I've heard about generated columns but not sure if its what I need

Solution

Arctic•8mo ago

Generated columns are just made from combining data already in the table, https://stackoverflow.com/questions/10273750/sql-conditional-not-null-constraint should answer your question as far as i can tell

Stack Overflow

Sql Conditional Not Null Constraint

I am curious to know is it possible to create a conditional not null constraint in sql? In otherwords is it possible to create a constraint such that a column B can be null as long column A contain...

Efkan•8mo ago

Thank you, I guess its not implemented in Drizzle ORM yet https://orm.drizzle.team/docs/indexes-constraints#check

Indexes & Constraints - DrizzleORM

Drizzle ORM | %s

Josh•8mo ago

Just use the SQL operator that drizzle provides

Efkan•8mo ago

I'll try to do that, thank you.

Efkan•8mo ago

@Josh I couldnt find any example for defining a column using the Drizzle's SQL operator and not giving away type-safety

Theo's Typesafe Cult Join

21KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Nextjs build fails on Docker due to env amid SKIP_ENV_VALIDATIONHey, I'm building an app with nodemailer inside the nextjs app and trying to build it with docker. TS build errors prevent buildIn a T3 app I need to build and do not have the time to fix some Typescript Errors. I tried basic N Headless CMS for Notion like knowledge base ?Hello! I have a, potential, upcoming consulting gig where a company that publishes books, tv shows How to generate GeoGrids?Hi, I wanted to know how does one make a website that generates GeoGrids for Local SEO, I know there Getting 401 error code with public procedureHi, I'm working on a project using t3 stack with clerk. I'm trying to get `posts` from prisma to sho Technology to store Html files with image/base64 srcsI was making a discord ticket bot, we have store these tickets transcripts. I got a discord-html-tra Is my backend team right?🤔So I'm working on an AI image gen app and I proposed a full text search feature that would allow use How to invalidate trpc queries in Next13The code speaks for itself. I want to invalidate a trpc query in a server action but I get a super w Any color picker vscode Extension with support for shadcn-ui css variables?Does anyone know about a vs code extension that adds a color picker which supports CSS HSL color var Is it idiomatic TypeScript: using as const?Hi, this is typescript related. Is there a way to avoid <const> or as const hell? I have an object