[도서 쇼핑몰] Node.js - 좋아요 API 구현

좋아요 추가

const addLike = (req, res) => {
  const { userId, likedBookId } = req.body;

  const sql = `INSERT INTO likes (user_id, liked_book_id) VALUES (?, ?);`;
  const values = [userId, likedBookId];

  conn.query(sql, values, (err, results) => {
    if (err) {
      return res.status(StatusCodes.BAD_REQUEST).json({
        msg: `Error: ${err.code}`,
      });
    }
    return res.status(StatusCodes.CREATED).json(results);
  });
};

좋아요 삭제

const removeLike = (req, res) => {
  const { userId, likedBookId } = req.body;

  const sql = `DELETE FROM likes where user_id=? AND liked_book_id=?;`;
  const values = [userId, likedBookId];

  conn.query(sql, values, (err, results) => {
    if (err) {
      return res.status(StatusCodes.BAD_REQUEST).json({
        msg: `Error: ${err.code}`,
      });
    }
    return res.status(StatusCodes.OK).json(results);
  });
};