mysql lambda查询_从NodeJS AWS Lambda函数查询MySQL数据库

我在AWS Lambda函数中查询我的

MySQL数据库(从AWS远程托管)时遇到问题.

这是我的代码,除了Lambda函数的其余部分所需的部分(正在为Alexa技能调用)：

var mysql = require('mysql');

var connection = mysql.createConnection({

host : '',

user : '',

password : '',

database : ''

});

connection.connect(function(err){

if(!err) {

console.log("Database is connected ... nn");

}

else {

console.log("Error connecting database ... nn");

}

});

connection.query("INSERT INTO Users (user_id) VALUES ('TESTNAME')");

connection.end();

当我从命令提示符运行节点时,这工作正常：

node index.js

我正在使用通过npm在index.js目录下安装的“mysql”模块并压缩它并将其上传到我的Lambda函数.

同样,这适用于我的开发机器,但在测试我的Lambda函数时没有给出任何指示,因为它根本不会影响我的数据库.

我的问题扩展到Alexa和Lambda,就像它正确使用mysql Node.JS模块一样.

这是我当前的Lambda代码,当然这里的问题仍然是我的测试值 – >名为“TESTNAME”的用户名不会添加到我的MySQL数据库中.

我把查询放入连接回调中,正如第一条评论所暗示的那样,我正在使用我的新代码而不是更新上面的旧代码,只是为了记录我认为代码应该如何转换为我的Alexa Lambda函数：

更新的代码：

var mysql = require('mysql');

var connection = mysql.createConnection({

host : '',

user : '',

password : '',

database : ''

});

exports.handler = (event, context) => {

try {

if (event.session.new) {

// New Session

console.log("NEW SESSION");

}

switch (event.request.type) {

case "LaunchRequest":

// Launch Request

console.log(`LAUNCH REQUEST`);

context.succeed(

generateResponse({},

buildSpeechletResponse("Welcome to an Alexa Skill, this is running on a deployed lamda function", true)

)

);

break;

case "IntentRequest":

// Intent Request

console.log(`Intent Request`);

console.log('Then run MySQL code:');

connection.connect(function(err) {

console.log('Inside connection.connect() callback');

if (!err) {

console.log("Database is connected ... ");

connection.query("INSERT INTO Users (user_id) VALUES ('TESTNAME')",

function(err, result) {

console.log("Inside connection.query() callback")

if (!err) {

console.log("Query Successful! Ending Connectection.");

connection.end();

} else {

console.log("Query error!");

}

});

} else {

console.log("Error connecting database ..." + err.message);

}

});

context.succeed(

generateResponse({},

buildSpeechletResponse("Welcome to the incredible intelligent MySQLable Alexa!", true)

)

);

break;

case "SessionEndedRequest":

// Session Ended Request

console.log(`SESSION ENDED REQUEST`);

break;

default:

context.fail(`INVALID REQUEST TYPE: ${event.request.type}`);

}

} catch (error) {

context.fail(`Exceptiodn: ${error}`)

}

};

//Helpers

buildSpeechletResponse = (outputText, shouldEndSession) => {

return {

outputSpeech: {

type: "PlainText",

text: outputText

},

shouldEndSession: shouldEndSession

};

};

generateResponse = (sessionAttributes, speechletResponse) => {

return {

version: "1.0",

sessionAttributes: sessionAttributes,

response: speechletResponse

};

};

我的控制台输出：

START RequestId: 5d4d17a7-0272-11e7-951c-b3d6944457e1 Version: $LATEST

2017-03-06T13:39:47.561Z 5d4d17a7-0272-11e7-951c-b3d6944457e1 Intent Request

2017-03-06T13:39:47.562Z 5d4d17a7-0272-11e7-951c-b3d6944457e1 Then run MySQL code:

END RequestId: 5d4d17a7-0272-11e7-951c-b3d6944457e1

REPORT RequestId: 5d4d17a7-0272-11e7-951c-b3d6944457e1 Duration: 82.48 ms Billed Duration: 100 ms Memory Size: 128 MB Max Memory Used: 14 MB