Sequelize[ORM] 사용하기 - 기초

■ seqeulize 설치 참고

  http://docs.sequelizejs.com/manual/installation/getting-started.html

mysql 을 사용할 경우 예제

db 연결 설정

const Sequelize = require('sequelize');

const sequelize_user = new Sequelize('user', 'root', '1234' , {
    dialect: 'mysql',
});

const sequelize_product = new Sequelize('product', 'root', '1234' , {
    dialect: 'mysql',
});


const dbs = {
    sequelize_user,
    sequelize_product
}

module.exports = dbs;

model 정의

const user = require('./databases').sequelize_user;
const Sequelize = require('sequelize')

const Users = user.define('users', {
    id : {
        type: Sequelize.STRING,
        primaryKey: true,
        autoIncrement: true
    },
    name: {
        type: Sequelize.STRING
    },
    password: {
        type: Sequelize.STRING
    },
    email: {
        type: Sequelize.STRING
    },
});

module.exports = Users;

쿼리

const Users = require('./Users')

Users.findAll({
    attributes: ['id', 'name'],

}).then(rows => {
    res.json({data: rows});
})