nodejs sqlクエリー


ルーティングクエリ
const query = 'insert into comments (comment, postId, userId) values(:comment, :postId ,:userId);';
      await sequelize.query(query, {
        replacements: { 
            comment: comment,
            postId : postId,
            userId : user.userId},
            type: sequelize.QueryTypes.INSERT
        }
        );
市場照会
const post = await posts.findAll(
      { include: [{model :comments, attributes: ['comment']},
      { model : users , attributes: ['userId','email','profile']},
      { model : likes }] },
      );
サブクエリ
DELETE FROM items WHERE id = (SELECT id) FROM products);

INSERT INTO items (SELECT * FROM products);