I don't understand why my promise.all() is not executed in Lambda while in development already work.
On AWS Lambda, it's already timeout because Promise.all() are not completed and I don't receive the new messages in my SQS queue.
However, the console.log(promises)
returned : 2017-01-29T22:55:46.191Z 0e82eeaf-e676-11e6-b69d-73a6bbd86272 [ Promise { <pending> } ]
var url = require('url');
var AWS = require('aws-sdk');
// var Promise = require("bluebird");
exports.handler = function (event, context, callback) {
AWS.config = {
region: 'us-east-1',
apiVersions : {
sqs: '2012-11-05'
}
};
if (typeof Promise === 'undefined') {
AWS.config.setPromisesDependency(require('bluebird'));
}
var sqs = new AWS.SQS(); // système de queue
var date = new Date();
var knex = require('knex')({
client: 'mysql',
connection: {
host : event.database.host,
user : event.database.user,
password : event.database.pwd,
database : event.database.name
}
});
var sqsQueueUrl = event.sqsQueueUrl;
var keywords = event.keywords;
knex.select('keywords').from('keyword')
.timeout(1000)
.then(function(results)
{
var keywordsInDbArray = returnArrayWithOnlyKeywords(results);
var keywordsWillBeStored = [];
for (var i in keywords)
{
var isInDb = keywordsInDbArray.indexOf(keywords[i]);
if(isInDb == -1)
keywordsWillBeStored.push({
keywords: keywords[i],
'created_at': date,
'updated_at': date
});
}
if(keywordsWillBeStored.length > 0)
{
knex.batchInsert('keyword', keywordsWillBeStored, keywordsWillBeStored.length)
.then(function(firstId)
{
var newKeywordsStored = dataStoredInDb(firstId, keywordsWillBeStored);
console.log(newKeywordsStored);
sendKeywordInqueue(newKeywordsStored);
})
.catch(function(error)
{
console.error(error);
context.fail(error);
knex.destroy();
});
}
else
{
context.succeed('Aucun nouveau keyword a enregistré');
}
})
.catch(function(error)
{
console.error(error);
context.fail(error);
knex.destroy();
});
function sendKeywordInqueue(array)
{
var promises = [];
for( var i in array)
{
var promise = sqs.sendMessage({
MessageBody: JSON.stringify(array[i]),
QueueUrl: sqsQueueUrl
}).promise().catch(function(error)
{
console.error(error);
});
promises.push(promise);
}
console.log(promises);
Promise.all(promises)
.catch(function(error)
{
console.error(error);
})
.then(function()
{
callback(null, "DONE");
context.succeed('Il y a eu '+array.length+' nouveau keywords enregistré et qui va être scrapé');
knex.destroy();
});
}
function dataStoredInDb(firstIdSavedInDb, arrayWithKeywords)
{
id = firstIdSavedInDb -1;
return arrayWithKeywords.map(function (obj, i) {
var rObj = {};
rObj.id = id + i + 1;
rObj.keywords = obj.keywords;
return rObj;
})
}
function returnArrayWithOnlyKeywords(resultDb)
{
var dataKeywords = [];
for(var key in resultDb)
{
dataKeywords.push(resultDb[key].keywords);
}
return dataKeywords;
}
};