TargetDataService/db/addrGroupProvider.js

/**
 * Created by thm on 2017/09/08.
 */
var seq;
exports.delete = function(serverId) {
    return seq.query("delete from AddrGroup where LoginName like '" + serverId + "-%'",
    {
        type: seq.QueryTypes.DELETE
    });
};

exports.insert = function(addrGroup) {
    return seq.query('insert AddrGroup(GroupId, GroupName, ParentID, LoginName) ' +
        'values(' +
        ':GroupId,' +
        ':GroupName,' +
        ':ParentID,' +
        ':LoginName)', {
            replacements: addrGroup,
            type: seq.QueryTypes.INSERT
        });
};

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