조합 API 추가

src/repositories/partRepository.js

@@ -57,6 +57,36 @@ const PartRepository = {
     const result = await pool.query(query, queryValues);
     return result.rows;
   },
+
+  async getAllCombinations() {
+    const query = `
+    SELECT array_agg(r.part_id) AS partIds
+    FROM combinations c
+    LEFT JOIN relations r ON c.id = r.combination_id
+    GROUP BY c.id;
+  `;
+
+    const result = await pool.query(query);
+    return result.rows;
+  },
+
+  async getFilteredCombinations(queryValues) {
+    const query = `
+    SELECT 
+      c.id AS combination_id,
+      array_agg(r.part_id) AS partIds
+    FROM combinations c
+    LEFT JOIN relations r ON c.id = r.combination_id
+    WHERE r.combination_id IN (
+      SELECT DISTINCT combination_id
+      FROM relations
+      WHERE part_id = ANY($1::int[])
+    )
+    GROUP BY c.id;
+  `;
+    const result = await pool.query(query, queryValues);
+    return result.rows;
+  },
 };
 
 export default PartRepository;