2. nodejs 라이브러리 sequelize의 쿼리 명령문

    반응형

    1. Insert 문

    SQL문법

    INSERT INTO nodejs.users (name, age, married, comment) VALUES ('zero', 24, 0, '자기소개1');

    sequelize 문법

    const { User } = require('../models')
    User.create({
    name: 'zero',
    age: 24,
    married: false,
    comment: '자기소개1',
    });

     

    이하 아래부터는 위는 SQL문 아래는 seq문법이다.

     

     

     

    - SELECT * FROM nodejs.users;

    - User.findALL({});

     

    - SELECT * FROM nodejs.users LIMIT 1;

    - User.findOne({});

     

    - SELECT name, married FROM nodejs.users;

    - User.findALL({

      attributes: ['name', 'married'],

    });

     

    - SELECT name, age FROM nodejs.users WHERE married =1 AND age > 30;

     

    - const { User, Sequelize : {Op}} = require('../models');

    User.findAll({

      attributes: ['name', 'age'],

    where: {

      married: 1,

    age: { [Op.gt]: 30 },

    },

    });

     

    - SELECT id, name FROM users ORDER BY age DESC;

    - User.findAll({

      attributes: ['id', 'name'],

    order: [[ 'age', 'DESC']],

    });

     

    - UPDATE nodejs.users SET comment = '바꿀 내용' WHERE id = 2;

    - User.update({

      comment: '바꿀 내용',

    }, {

      where : { id : 2 },

    });

     

    - DELETE FROM nodejs.users WHERE id = 2;

    - User.destroy({

     where: { id : 2},

    });

     

    반응형

    댓글