我有一个函数,每次我调用这个函数时,它都会返回一个未定义的对象。我想知道是否有解决这个问题的具体方法。在index.js中,我调用了sqlQuery.getItem方法,并期望它从数据库返回一行,但每次都返回未定义的行。
index.js
'use strict';
const Alexa = require('alexa-sdk');
const mysql = require('promise-mysql');
const querydb = require('./sqlQuery.js');
var testSQL = 'SELECT uWeight, uHeight from users where pin=1100';
//querydb.getItem(testSQL);
var values = querydb.getItem(testSQL);
if(values == undefined){
console.log('Error');
}
else{
console.log(values);
}
databaseConnection.js
var mysql = require('promise-mysql');
pool = mysql.createPool({
host: "mytrainerdb.cbh07n2xwds2.us-east-1.rds.amazonaws.com",
database: "trainerdb",
user: "user",
password: "password"
});
function getSqlConnection() {
return pool.getConnection().disposer(function(connection) {
pool.end(connection);
});
}
module.exports = getSqlConnection;
sqlQuery.js
var Promise = require("bluebird");
var getSqlConnection = require('./databaseConnection');
var hello = "hello";
function getItem(sql){
Promise.using(getSqlConnection(), function(connection) {
return connection.query(sql).then(function(rows) {
console.log(rows[0]);
return (rows[0]);
}).catch(function(error) {
return (error);
});
})
}
module.exports.getItem = getItem;
https://stackoverflow.com/questions/50709461
复制相似问题