var writeConfig = {
dialect: "oracle",
database: 'dbName',
username: "xxx",
password: "xxx",
option: {
dialect: "oracle"
},
modelPath: path.join(__dirname, 'models')
};
var orm = require('zbmy-orm');
orm.init('mysql','read', writeConfig);
"use strict"
var Sequelize = require('sequelize');
module.exports = function(sequelize){
var Company = sequelize.define('company',{
_id: {
type: Sequelize.UUID,
primaryKey: true,
defaultValue: Sequelize.UUIDV1
},
openid: {
type: Sequelize.STRING
}
},{
freezeTableName: true,
timestamps: false,
paranoid: true,
underscored: true
});
return Company;
}
orm('gamer').findAll({where:{_id:"xxx"}}, function(err, result){
});
orm('gamer').transaction({isolationLevel: "xxxx", deferrable: "xxx", autocommit: false}, function(t){
orm('gamer').findAll({where: {_id: "xxx"}}, {transaction: t}, function(err, result){
if(err){t.rollback();}
t.commit();
});
});
orm('gamer').invokeSQL({sql: "xxx", options: {}}, function(err, result){
});