app.js
app.get('/api/search/:hashtag/:sinceid/:resultType', function(req, res)
{
//var obj = searchdb.search('rooney',connection);
obj = searchdb.search('rooney',connection);
console.log("obj is" + obj);
}
I have this part of code in app.js
calling search function in another js
file to search for a query but it always come undefined. Although the obj is being shown as [object Object] printed in console.log
statement of 2nd part of code. Am I returning "statuses" correctly?
var alerts = [];
var text;
var jsonString;
module.exports = {search: function mydb(query_search,connection){
query_search = "%#" + query_search + "%";
connection.query('select * from `team079`.`tweets` where text like ?',query_search, function(err,res){
if(err)
{
throw err;
console.log(err);
}
else{
for (var i in res){
var tweetText = res[i].text;
var screenName = res[i].screen_name;
var created_at = res[i].created_at;
text = {text: tweetText, screen_name: screenName,created_at: created_at };
alerts.push(text);
console.log("Tweet:" + tweetText + "\n\n" + screenName + "\n\n" + created_at + "\n\n ");
}
var statuses = {"statuses":alerts};
console.log("searchdb obj is " + statuses);
var string = JSON.stringify(statuses);
jsonString = JSON.parse(string);
return statuses;
}
})
}