Changeset b615094 for database/drizzle/schema

Timestamp:

12/20/25 01:31:36 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

0d447f6

Parents:

b69759d

Message:

add constraints

Location:

database/drizzle/schema

Files:

• builds.ts (modified) (2 diffs)
• components.ts (modified) (3 diffs)
• users.ts (modified) (2 diffs)

database/drizzle/schema/builds.ts

@@ -1 @@
-import { pgTable, serial, integer, text, numeric, boolean, date, primaryKey } from "drizzle-orm/pg-core";
+import {pgTable, serial, integer, text, numeric, boolean, date, primaryKey, check} from "drizzle-orm/pg-core";
 import { usersTable } from "./users";
 import { componentsTable } from "./components";
+import {sql} from "drizzle-orm";
 
 export const buildsTable = pgTable("build", {
@@ -52 +53 @@
     (t) => ({
         pk: primaryKey({ columns: [t.buildId, t.userId] }),
+        checkValue: check("check_value", sql`${t.value} BETWEEN 1 AND 5`),
     }),
 );

database/drizzle/schema/components.ts

@@ -67 +67 @@
             .references(() => pcCasesTable.componentId, {onDelete: "cascade", onUpdate: "cascade" }),
         formFactor: text("form_factor").notNull(),
-        num_slots: integer("num_slots").notNull(),
+        numSlots: integer("num_slots").notNull(),
     },
     (t) => ({
@@ -107 +107 @@
 // Cooler multi-values
 export const coolerCPUSocketsTable = pgTable("cooler_cpu_sockets", {
-        cooler_id: integer("cooler_id")
+        coolerId: integer("cooler_id")
             .notNull()
             .references(() => coolersTable.componentId, { onDelete: "cascade", onUpdate: "cascade" }),
@@ -113 +113 @@
     },
     (t) => ({
-        pk: primaryKey({ columns: [t.cooler_id, t.socket] }),
+        pk: primaryKey({ columns: [t.coolerId, t.socket] }),
     })
 );

database/drizzle/schema/users.ts

@@ -1 @@
-import { pgTable, serial, integer, text, numeric, boolean, date, primaryKey } from "drizzle-orm/pg-core";
+import {pgTable, serial, integer, text, numeric, boolean, date, primaryKey, check} from "drizzle-orm/pg-core";
+import {sql} from "drizzle-orm";
 
 export const usersTable = pgTable("users", {
@@ -26 +27 @@
     status: text("status")
         .notNull()
-        .default("pending"), // Pending, Approved, Rejected
+        .default("pending"),
     componentType: text("component_type").notNull()
-});
+    },
+    (t) => ({
+        checkStatus: check("check_status", sql`${t.status} in ('pending', 'approved', 'rejected')`),
+    }),
+);
 
 export type userItem = typeof usersTable.$inferSelect;