sequelize用法-前言

sequence是nodejs操作数据库的orm

前言主要是搭建express的框架是尝试sequelize的功能
我搭建的express的目录结构

zengwe@zengwe-PC:nodeser$ tree -I 'node_modules'
.
├── app.js
├── config
│   └── config.js
├── controllers
│   └── login.js
├── models
│   ├── baseModel
│   │   ├── group.js
│   │   ├── group_permission.js
│   │   ├── info.js
│   │   ├── init.js
│   │   ├── permission.js
│   │   ├── user_group.js
│   │   └── user.js
│   └── user.js
├── package.json
└── router.js

app.js 为入口文件

let express = require('express');
let path = require('path');
let cookieParser = require('cookie-parser');
let bodyParser = require('body-parser');
let app = express();
let router = require('./router');
let serverConf = require('./config/config').server;

app.set('views', path.join(__dirname, 'views'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
app.use('/', router);
app.use(function (req, res, next) {
    let err = new Error('Not Found');
    err.status = 404;
    next(err);
});
app.use(function (err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
        message: err.message,
        error: (app.get('env') === 'development') ? err : {}
    });
});

app.listen(serverConf.port, serverConf.host, function () {
    console.log('-------------------------------');
    console.log('server is run;http://' + serverConf.host + ':' + serverConf.port);
    console.log('-------------------------------');
});

路由文件routerjs

let express = require('express');
let router = express.Router();
let controller = require('./controllers/login');
router.get('/login', function (req, res, next) {
    console.log('login middle');
    next();
}, (req, res) => controller.login(req, res));
router.get('/insert', (req, res) => controller.insert(req, res));
module.exports = router;

controllser

let userModel = require('../models/user');
class loginController{
    constructor(){
        console.log("loginController constructor");
    }
    login(req,res){
        let data= userModel.getModel().findAll().spread(function(item,created){
              //console.log(item);
              //return item.dataValues;
              return item;
        });
        data.then((mydata)=>{
            console.log(mydata);
            //console.log(JSON.stringify(mydata));
            //JSON()
            res.send(JSON.stringify(mydata));
        });
        //res.send('loginController');
    }
    insert(req,res){
        userModel.getModel().create({changeName:'dfads',password:'123456',age:19}).then(function(success){
            console.log('success');
            console.dir(arguments);
            res.send(success);
        },function(err){
            console.log('error');
            console.log(err);
            //res.send(err);
            res.send(err.errors[0].message);
            console.dir(JSON.stringify(arguments));
        });
    }
}
module.exports =new loginController();

链接数据库

let Sequelize = require('sequelize');
let mysqlCfg = require('../../config/config').mysql;
let sequelize = new Sequelize(mysqlCfg.database, mysqlCfg.username, mysqlCfg.password, {
    host: mysqlCfg.host,
    dialect: 'mysql',
    pool: {
        max: 5,
        min: 0,
        idle: 10000
    }
});
module.exports = sequelize;

基础的环境大概就是这样了