Closed youngsupchoi closed 1 year ago
프리티어때문에 변경내역이 이렇게 나오네요 한번 날잡고 프리티어 형식 통일해야겠네요 일단 급한대로 commit했습니다. 답변리스트 불러오기 구현했고 구현코드는 아래와 같습니다.
router: router.get("/answer/:question", questionMid.questionAnswerGetMid);
controller: exports.questionAnswerGetMid = async (req, res) => { try { const answers = await Question.getQuestionsAnswer(req.params.question);
res.status(200).send({ success: true, message: "답변을 조회하였습니다.", data: answers, });
} catch (err) { console.error(err); res.status(500).send({ success: false, message: "오류가 발생하였습니다." }); } };
model: Question.getQuestionsAnswer = async (question_id) => { const rows = await pool.query( SELECT answers.*, wiki_history.user_id, users.nickname, users.rep_badge, badges.image AS badge_image FROM wiki_history INNER JOIN answers ON wiki_history.id = answers.wiki_history_id INNER JOIN users ON wiki_history.user_id = users.id INNER JOIN badges ON users.rep_badge = badges.id WHERE answers.question_id = ? ORDER BY created_at ASC;, [question_id] ); return rows[0]; };
SELECT answers.*, wiki_history.user_id, users.nickname, users.rep_badge, badges.image AS badge_image FROM wiki_history INNER JOIN answers ON wiki_history.id = answers.wiki_history_id INNER JOIN users ON wiki_history.user_id = users.id INNER JOIN badges ON users.rep_badge = badges.id WHERE answers.question_id = ? ORDER BY created_at ASC;
프리티어때문에 변경내역이 이렇게 나오네요 한번 날잡고 프리티어 형식 통일해야겠네요 일단 급한대로 commit했습니다. 답변리스트 불러오기 구현했고 구현코드는 아래와 같습니다.
router: router.get("/answer/:question", questionMid.questionAnswerGetMid);
controller: exports.questionAnswerGetMid = async (req, res) => { try { const answers = await Question.getQuestionsAnswer(req.params.question);
} catch (err) { console.error(err); res.status(500).send({ success: false, message: "오류가 발생하였습니다." }); } };
model: Question.getQuestionsAnswer = async (question_id) => { const rows = await pool.query(
SELECT answers.*, wiki_history.user_id, users.nickname, users.rep_badge, badges.image AS badge_image FROM wiki_history INNER JOIN answers ON wiki_history.id = answers.wiki_history_id INNER JOIN users ON wiki_history.user_id = users.id INNER JOIN badges ON users.rep_badge = badges.id WHERE answers.question_id = ? ORDER BY created_at ASC;
, [question_id] ); return rows[0]; };