直接上代码
/**
* @param {Object} payload 上一节点的输出
* @param {Object} node 指定某个节点的输出
* @param {Object} query 服务流第一个节点的输出
* @param {Object} context { appKey, appSecret }
* @param {Object} global 变量
*/
module.exports = async function(payload, node, query, context, global) {
const mysql = require('mysql');
const moment = require('moment');
var name = query.name;
var phone = query.phone;
var deviceNames = query.deviceNames;
var type = query.type;
var permission = query.permission;
var company = query.company;
var createTime = moment(new Date).add(8, "hours").format("YYYY-MM-DD HH:mm:ss");
const pool = mysql.createPool({
host: '自己的数据库host',
user: '自己的数据库用户名',
password: '自己的数据库密码',
port: '3306',
database: '自己的数据库名',
multipleStatements: true,
supportBigNumbers:true,
});
var str = '';
if(deviceNames!=''&&deviceNames!=undefined){
if(deviceNames.indexOf(',')!=-1){
//包含,
var arr = deviceNames.split(",");
arr.map(function(item){
if(item!=''){
str+= '(\''+name+'\',\''+phone+'\','+type+','+permission+',\''+createTime+'\',\''+item+'\',\''+company+'\'),';
}
});
str = str.substring(0,str.length-1);
}else{
str = '(\''+name+'\',\''+phone+'\','+type+','+permission+',\''+createTime+'\',\''+deviceNames+'\',\''+company+'\')';
}
var sqlStr = "REPLACE INTO device_user (name,phone,type,permission,create_time,device_name,company) VALUES "+str;
console.log(sqlStr);
if(str != ''){
const promise = new Promise(function(resolve, reject) {
pool.getConnection(function(err, connection) {
if (err) {
reject( err )
} else {
connection.query(sqlStr, ( err, rows) => {
if ( err ) {
reject( err )
} else {
resolve( rows )
}
// 结束会话
connection.release()
})
}
});
});
await promise.then(function(data){
console.log("success ",data);
},function(err){
console.log("err ",err);
});
}
}
return null;
}