TargetDataService/db/branchsProvider.js

/**
 * Created by luququ on 2015/10/15.
 */
var seq;
exports.delete = function(serverId){
    return seq.query('delete from branchs where serverId = :sid',
        {
            replacements:{sid:serverId},
            type:seq.QueryTypes.DELETE
        });
};

exports.insert = function(branchs){
    return seq.query('insert branchs(id, parentId, branchName, position, serverId, branchId, displayLevel, inherit, branchType) ' +
		'values(:id,'+ 
        ':parentId,'+ 
        ':branchName,'+ 
        ':position,'+ 
        ':serverId,'+ 
        ':branchId,'+ 
        ':displayLevel,'+ 
        ':inherit,'+ 
        ':branchType)',
        {
            replacements:branchs,
            type:seq.QueryTypes.INSERT
        });
};

exports.setSequelize = function(sequelize){
    seq = sequelize;
};