Indie-Resource.com

alex_king92 wrote:Hi, I need to make a function which query my MySQL db.
I've made this:
call:

Code: Select all

var data = {};
data = self.queryMySQL('SELECT * FROM table_one');
console.log(data);   //No output here

function:

Code: Select all

queryMySQL: function(query){
	var result = {};
	//connect to the mysql server
		ige.mysql.connect(function (err, db) {
			// Check if we connected to mysql correctly
			if (!err) {
				// Query the database
				ige.mysql.query(query, function (err, rows, fields) {
					if (!err) {
						result=rows;
					} else {
						console.log('Error', err);
					}
				});
			} else {
				console.log(err);
			}
		});
		console.log(result);   //All is OK here
		return result;
	};

The problem is the function which don't give the value back because it's asynchronous and so my "data" object is still empty when I try to use it. (I think)
Does anybody know a solution?

queryMySQL: function(query, callback){
	var result = {};
	//connect to the mysql server
		ige.mysql.connect(function (err, db) {
			// Check if we connected to mysql correctly
			if (!err) {
				// Query the database
				ige.mysql.query(query, function (err, rows, fields) {
					if (!err) {
                                                callback(rows, fields);
					} else {
						console.log('Error', err);
					}
				});
			} else {
				console.log(err);
			}
		});
	};

var data = {};
data = self.queryMySQL('SELECT * FROM table_one', function (rows, fields) {
console.log(rows, fields);   //No output here
});

alex_king92 wrote:Ok, but can I bring the result outside the function call? Something like this:

Code: Select all

var data = {};
self.queryMySQL('SELECT * FROM table_one', function (rows, fields) {
data=rows;
});
console.log(data);

alex_king92 wrote:I have solved, I used a global variable:

Code: Select all

self.data[0]=rows[0];

Now a have an other question. I dont understand how I have to call the "disconnect" metod of "IgeMySql"
When I call it, I have this answer from my cmd: "Cannot call methot 'end' of undefined...".
What I have to pass it to identify my current connection?

this.connection.end(function () {

this.client.end(function () {

alex_king92 wrote:Done. And the output is this:
C:\wamp\www\ige-master\engine\components\database\mysql\IgeMySql.js:74
callback();
^
TypeError: undefined is not a function
at Quit._callback (C:\wamp\www\ige-master\engine\components\database\mysql\IgeMySql.js:74:4)
at C:\wamp\www\ige-master\server\node_modules\mysql\lib\protocol\sequences\Sequence.js:68:22
at process._tickCallback (node.js:415:13)

But if I modify it in this way:

Code: Select all

this.client.destroy();

It seems to work.
I don't know if this is an ige or node error, or an error is occurred while I installed my server. Any opinion?