Changeset b0685a8 for database

Timestamp:

01/23/26 18:27:06 (6 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

ad211d1

Parents:

41a2f81

Message:

Allow adding multiple components per build

Location:

database

Files:

• drizzle/queries/components.ts (modified) (1 diff)
• drizzle/schema/builds.ts (modified) (2 diffs)
• migrations/0000_fancy_mojo.sql (deleted)
• migrations/meta/0000_snapshot.json (deleted)
• migrations/meta/_journal.json (deleted)

database/drizzle/queries/components.ts

@@ -959 +959 @@
         if(!build || build.isApproved) return null;
 
-        const existing = await tx
-            .select()
-            .from(buildComponentsTable)
-            .where(
-                and(
-                    eq(buildComponentsTable.buildId, buildId),
-                    eq(buildComponentsTable.componentId, componentId)
-                )
-            )
-            .limit(1);
-
-        if (existing.length) return null;
-
         await tx
             .insert(buildComponentsTable)

database/drizzle/schema/builds.ts

@@ -17 +17 @@
 
 export const buildComponentsTable = pgTable("build_component", {
+        id: serial("id").primaryKey(),
         buildId: integer("build_id")
             .notNull()
@@ -24 +25 @@
             .references(() => componentsTable.id, { onDelete: "cascade", onUpdate: "cascade" }),
     },
-    (t) => ({
-        pk: primaryKey({ columns: [t.buildId, t.componentId] }),
-    }),
 );