import { sql } from 'drizzle-orm';
import { check, int, sqliteTable, text } from 'drizzle-orm/sqlite-core';
const SOME_KIND_ENUM = ["win", "sbst", "tbst", "chop"] as const;
export const someTable = sqliteTable("some_table", {
id: int().primaryKey({ autoIncrement: true }),
kind: text({ enum: SOME_KIND_ENUM }).notNull(),
}, (table) => [
check(
"is_valid",
sql`${table.kind} IN ('${SOME_KIND_ENUM.join(`', '`)}')`
),
]);
import { sql } from 'drizzle-orm';
import { check, int, sqliteTable, text } from 'drizzle-orm/sqlite-core';
const SOME_KIND_ENUM = ["win", "sbst", "tbst", "chop"] as const;
export const someTable = sqliteTable("some_table", {
id: int().primaryKey({ autoIncrement: true }),
kind: text({ enum: SOME_KIND_ENUM }).notNull(),
}, (table) => [
check(
"is_valid",
sql`${table.kind} IN ('${SOME_KIND_ENUM.join(`', '`)}')`
),
]);