Skip to content
Snippets Groups Projects

fix: response 의 구조와 맞지 않는 곳 수정

Merged Eunhak Lee requested to merge fix/share into main
2 files
+ 12
8
Compare changes
  • Side-by-side
  • Inline

Files

+ 10
6
@@ -14,12 +14,16 @@ const ShareRepository = {
@@ -14,12 +14,16 @@ const ShareRepository = {
async getCombinationByUuid(uniqueId) {
async getCombinationByUuid(uniqueId) {
const resp = await pool.query(
const resp = await pool.query(
`SELECT
`SELECT
shares.combination_id,
shares.combination_id,
array(SELECT relations.part_id FROM relations WHERE relations.combination_id = shares.combination_id) as parts,
users.nickname,
shares.created_at,
array(SELECT relations.part_id FROM relations WHERE relations.combination_id = shares.combination_id) as parts,
(SELECT created_at FROM combinations WHERE combinations.id = shares.combination_id) as verified_at
shares.created_at,
FROM shares
(SELECT created_at FROM combinations WHERE combinations.id = shares.combination_id) as verified_at
WHERE uuid=$1;`,
FROM shares
 
LEFT JOIN combinations ON shares.combination_id = combinations.id
 
LEFT JOIN users ON combinations.owner_id = users.id
 
WHERE uuid=$1
 
;`,
[uniqueId]
[uniqueId]
);
);
const [row] = resp.rows;
const [row] = resp.rows;
Loading