내 PC를 인증된 조합으로 공유하기 기능

공유하기 UUID 생성하기: POST /api/my/pc/:combinationId/uuid

UUID를 통해서 정보 가져오기: GET /api/parts/combination/by-uuid/:uuid

src/repositories/shareRepository.js

+import pool from '../db.js';
+
+const ShareRepository = {
+  async createCombinationUuid(combinationId) {
+    const resp = await pool.query(
+      `INSERT INTO shares (combination_id) 
+      VALUES ($1)
+      RETURNING uuid;`,
+      [combinationId]
+    );
+    const [uuid] = resp.rows;
+    return uuid;
+  },
+  async getCombinationByUuid(uniqueId) {
+    const resp = await pool.query(
+      `SELECT
+        shares.combination_id,
+        array(SELECT relations.part_id FROM relations WHERE relations.combination_id = shares.combination_id) as parts,
+        shares.created_at,
+        (SELECT created_at FROM combinations WHERE combinations.id = shares.combination_id) as verified_at
+        FROM shares
+        WHERE uuid=$1;`,
+      [uniqueId]
+    );
+    const [row] = resp.rows;
+    return row;
+  },
+};
+
+export default ShareRepository;