Nodejs koa2 Sequelize 连接mysql使用原始sql多条插入数据

文档：https://www.sequelize.cn/core-concepts/raw-queries

        
//连接mysql
const devTargetServer = new Sequelize('数据库名称', '用户名账号', '密码', {
    host: '127.0.0.1',
    port: '5506',
    dialect: 'mysql',//连接的数据库类型：mysql，mongoose
    database:'数据库名称',
    pool: {   //连接池设置
        max: 5, //最大连接数
        min: 0, //最小连接数
        idle: 10000
    },
})



  let data = [
                ['157030967331444252', '1570309673314291847', '1570309673314291847', '1565253175034908840', 'id', 'id', 'bigint', 1, 0, 1],
                ['157030967331334252', '1570309673314291847', '1570309673314291847', '1565253175034908840', 'id2', 'id2', 'bigint', 1, 0, 1],
                ['157030967331114252', '1570309673314291847', '1570309673314291847', '1565253175034908840', 'id1', 'id1', 'bigint', 1, 0, 1],
            ]
            let sql = `INSERT INTO permission_field(id, pid, role_id, field_id,field_c, field_n,field_type,enabled ,visible,required) VALUES ${data.map(a => '(?)').join(',')};`
            let contato = await devTargetServer.sequelize.query(sql, {
                replacements: data,
                type: QueryTypes.INSERT,
                returning: true,
            }
            );