node.js学习笔记(6)_极客学院_Waterline

使用方式

var Waterline = require('waterline');
var mysqlAdaper = require('sails-mysql');
var mongoAdaper = require('sails-mongo');

// 适配器
var adapters = {
    mongo: mongoAdaper,
    mysql: mysqlAdaper,
    default: 'mongo'
};

//连接器
var connections = {
    mongo: {
        adapter: 'mongo',
        url: 'mongodb://localhost/waterline-sample'
    },
    mysql: {
        adapter: 'mysql',
        url: 'mysql://root:root@localhost/waterline_sample'
    }
};

//数据类型
var User = Waterline.Collection.extend({
    identity: 'user',
    //  connection: 'mongo', //使用mongo
    connection: 'mysql', // 使用mysql
    schema: true, //是否开启强制模式
    attributes: {
        username: {
            type: 'string',
            required: true,
        },
        birthday: {
            type: 'date',
            after: new Date('1992-10-10'),
        },
        createTime: {
            type: 'date'
        }
    },
    beforeCreate: function(value, cb) { //生命周期回调方法
        value.createTime = new Date();
        console.log('beforeCreate executed');
        return cb();
    }

});

//初始化
var orm = new Waterline();
orm.loadCollection(User);
var config = {
    adapters: adapters,
    connections: connections
}
orm.initialize(config, function(err, models) {
    if(err) {
        console.error('orm initialize failed.', err);
    }
    console.log('models', models);

    models.collections.user.create({
        username: 'linyz'
    }, function(err, user) {
        console.log('after user.create,err,user:', err, user);
    });

});