Network Programming in .NET

In order to connect to Microsoft SQL server from Node in AWS Lambda you need to include a reference to require(‘mssql’); – but how do you install NPM packages on AWS Lambda.

That’s where the AWS CLI comes in. Download it, and the first thing you do is configure it with an IAM user as follows

aws configure

which prompts;

AWS Access Key ID [****************]:
AWS Secret Access Key [****************]:
Default region name [None]: eu-west-1
Default output format [None]:

Now, get a list of lambda functions as follows;

aws lambda list-functions

You can get the function name from the json returned, then if you want to get a zip of your function call;

aws lambda get-function –function-name <Function Name>

The JSON will return a property “Location” which you use to download the zip file.  Unzip the zip file, and navigate into the folder, then type

npm install mssql

Once complete, zip up the folder, and upload it back to AWS as follows

aws lambda update-function-code –function-name <Function Name> –zip-file “fileb://<ZIP Name>”

Now, you can create a file, database.js in your Lambda project as follows

const sql = require(‘mssql’);

(function() {

// ——- Database support ——- //

module.exports.execute = function(sqlQuery, callback)
{
const config = {
user: ‘xxxxxx’,
password: ‘xxxxx’,
server: ‘xxxx.xx.xx.xxx’,
database: ‘xxxxxx’,
};
sql.connect(config, (err) => {
if (err) {
console.log(err);
callback(err);
} else {
const req = new sql.Request();
req.query(sqlQuery, (error, result) => {
if (error) {
console.log(error);
callback(error);
} else {
console.log(result);
sql.close();
callback(null, result.recordset);
}
});
}
});

sql.on(‘error’, (err) => {
console.log(err);
callback(err);
});

};
}());