I want to call self.setState( { date_data: tour_dates}); in the third function in an async.series block. So I have a nested function, and seemingly even using .bind(this) on every block doesnt seem to fix my problem. What am I missing? And what should I change in my coding style to avoid problems like this?
var mysql = require('mysql');
var async = require('async');
var self = this;
var moment = require('moment');
class ArtistTable extends React.Component {
constructor(props, context) {
super(props, context);
this.getArtistData = this.getArtistData.bind(this);
this.state = {
open: false,
date_data: [],
};
}
getArtistData (artistName) {
var artist_id = -1;
var tour_id = -1;
var tour_dates = new Array();
var connection = mysql.createConnection({
host : '127.0.0.1',
user : 'root',
password : '',
database : 'anand2'
});
connection.connect(function(err) {
if (err) {
console.error('MYSQL Error Connecting!' + err.stack);
return;
}
console.log('MYSQL ArtistTable connected as ' + connection.threadId);
});
async.series([
function(callback){
connection.query("SELECT * FROM artist WHERE name = '" +artistName+"'" , function(err, rows){
artist_id = rows[0].id;
callback();
});
}, function(callback){
//finde tour ID
connection.query("SELECT * FROM tour WHERE artist = " + artist_id , function(err, rows){
console.log("SELECT * FROM tour WHERE artist = " + artist_id ) //Todo: neue erstellen
console.log(rows.length)
tour_id = rows[0].id;
console.log("Tour ID is " + tour_id)
callback();
});
}, function(callback){
connection.query("SELECT dtime,location FROM tour_date WHERE tour="+ tour_id + " AND dtime >= CurDate() ORDER BY dtime ASC" , function(err, rows){
if (rows.length > 0) {
for (var i = 0; i < rows.length; i++) {
tour_dates.push({date: rows[i].dtime, location: rows[i].location });
}
console.log("Number of dates: " + tour_dates.length)
self.setState( { date_data: tour_dates});
}
}.bind(this));
}
]);
}
}
Also, please ignore the "self = this", that was a test, I did try it with this.
