promise封装数据库请求与http请求

function queryPromise(sql){
    return new Promise( (resolve,reject)=>{
        pool.getConnection(function (err, conn) {
            if(!err){
                conn.query(sql, function (qerr, vals, fields) {
                    //释放连接  
                    conn.release();   
                    if(qerr){
                        reject(qerr);
                    }else{
                        //resolve(null, vals);
                        resolve(vals);
                    }
                });
            }else{
                reject(err);
            }
        })
    })
    // .catch(qerr=>{   
    //     return {
    //         err: qerr,
    //         data: null
    //     };
    // });
}

调用数据库请求

exports.create_room = async function (roomId, conf, ip, port, create_time, gps_limit, teamId) {
    // callback = callback == null ? nop : callback;
    var sql = "INSERT INTO t_rooms(uu