글 조회

// 글 조회하기
const { Users, Posts, Posts_comments } = require('../../models');

module.exports = async (req, res) => {
  try {
    const postsData = await Posts.findAll({
      attributes: [
        "id",
        "user_id",
        "message",
        "email",
        "total_comments",
      ],
      include: [
        // { model: Users, attributes: ["id"] },
        // { model: Users, attributes: ["email"] },
        { model: Posts_comments, attributes: ["id"] }
      ]
    })
    // console.log('postsData', postsData)
    let postsList = postsData.map(el => {
      // console.log('post 데이터', el)
      return {
        "id": el.id,
        "user_id": el.user_id,
        "email": el.email,
        "message": el.message,
        "total_comments": el.Posts_comments.length,
      }
    })

    console.log('postList', postsList)
    return res.status(200).json({ data: postsList, message: "successfully posts show all" })
  }
  catch (err) {
    return res.status(500).json({ data: null, message: "server error" })
  }
}

댓글 불러오기

const { Users, Posts, Posts_comments } = require('../../models');

module.exports = async (req, res) => {

  try {
    const postsCommentsData = await Posts_comments.findAll({
      attributes: [
        "id",
        "user_id",
        "post_id",
        "comment",
      ],
      include: [
        // { model: Users, attributes: ["id"] },
        // { model: Posts, attributes: ["id"] }
      ]
    })

    // console.log('postsCommentsData', postsCommentsData)

    let postsCommentsList = postsCommentsData.map(el => {

      return {
        "id": el.id,
        "user_id": el.user_id,
        "post_id": el.post_id,
        "comment": el.comment,
      }
    })

    // console.log('postsCommentsList', postsCommentsList)

    return res.status(200).json({ data: postsCommentsList, message: "successfully posts show all" })
  }
  catch (err) {
    return res.status(500).json({ data: null, message: "server error" })
  }
}