drizzle-orm [FEATURE]: Add check support in drizzle-kit

trafficstars

Describe what you want

This issue is a part of https://github.com/drizzle-team/drizzle-orm/issues/229

Jul 11 '23 22:07 AndriiSherman

+1 to CHECK support.

Jul 25 '23 18:07 SebastianGarces

+1 to Check support.

Jul 25 '23 18:07 dcchrispen

checks would be great, i need it for my code

Jul 29 '23 18:07 nairol203

+1 to CHECK support

Sep 07 '23 06:09 harrispap03

+1

Sep 21 '23 21:09 itsyoboieltr

any update for this feature? Check constraint is one of the core feature of any RDBMS. It should be implemented with higher priority.

Oct 16 '23 16:10 md-redwan-hossain

Is there a workaround for this with Drizzle's sql operator ?

Oct 16 '23 21:10 efkann

Ditto what @efkann said. Is there a workaround with the sql method?

Nov 01 '23 03:11 arxpoetica

@efkann @arxpoetica I found a workaround when defining a default. It may not work for all use cases but it's working for me.

schema:

export const exampleTable = schema.table('example_table', {
  // ... other columns not included
  status: text('status', {
    enum: ['pending', 'active', 'suspended', 'archived'],
  })
    .notNull()
    // HACK: Drizzle does not yet support check constraints as of writing this
    .default(
      sql`'pending' CHECK (status IN ('pending', 'active', 'suspended', 'archived'))`,
    ),
});

generates:

CREATE TABLE IF NOT EXISTS "my_schema"."example_table" (
	"status" text DEFAULT 'pending' CHECK (status IN ('pending', 'active', 'suspended', 'archived')) NOT NULL
);

Nov 16 '23 17:11 austincm

💎 $20 bounty created by @rvaidun 👉 To claim this bounty, submit your pull request on Algora 📝 Before proceeding, please make sure you can receive payouts in your country 💵 Payment arrives in your account 2-5 days after the bounty is rewarded 💯 You keep 100% of the bounty award 🙏 Thank you for contributing to drizzle-team/drizzle-orm!