SourceDataClient/db/branchsProvider.js

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

exports.getAll = function(serverId){
    var seq = seqs[serverId];
    return seq.query('select id, parentId, branchName, position, serverId, branchId, displayLevel, inherit, branchType from branchs where  serverId = :sid',
        {
            replacements:{sid: serverId},
            type:seq.QueryTypes.SELECT
        });
};

exports.setSequelize = function(sequelizes){
    seqs = sequelizes;
};