Changeset c4dd17d for database/drizzle/schema

Timestamp:

12/20/25 04:03:51 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

5ce5904

Parents:

37bcb87

Message:

update queries

File:

• database/drizzle/schema/components.ts (modified) (2 diffs)

database/drizzle/schema/components.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 componentsTable = pgTable("components", {
@@ -7 +8 @@
     price: numeric("price").notNull(),
     imgUrl: text("img_url"),
-});
+    type: text("type").notNull()
+    },
+    (t) => ({
+        checkType: check("check_type", sql`${t.type} in 
+      ('cpu', 'gpu', 'memory', 'storage', 'power_supply', 'motherboard', 'case', 'cooler', 'memory_card', 'optical_drive', 'sound_card', 'cables', 'network_adapter', 'network_card')`)
+    }),
+);
 
 // Base Components