TIL - Sequelize

1. SELECT * FROM node.users;

User.findAll({});

2. SELECT name, age FROM node.users;

User.findAll({
	attribute:['name', 'age'],
});

3. SELECT name, age From node.users WHERE role =1 AND age>30;

const {OP} = require('sequelize');
const {User} = require('../models');
User.findAll({
	attribute :['name', 'age'],
    where :{
    	role:1,
        age:{[Op,gt]:30},
      },
   });

4. SELECT id, name FROM users WHERE role =0 OR age>30;

const {OP} = require('sequelize');
const {User} = require('../models');
User.findAll({
	attribute :['name', 'age'],
    where :{
    	[Op.or]: [{role:0}, {age :{[Op.gt]:30}}],
      },
   });