mysql

mysql module

---

Access

gracenode.mysql

Configurations

"modules": {
	"mysql": {
		"configNameOfYourChoice": {
			"read": {
				"database": "databaseName",
				"host": "host or IP address",
				"user": "databaseUser",
				"password": "databasePassword"
			},
			"write": {
				"database": "databaseName",
				"host": "host or IP address",
				"user": "databaseUser",
				"password": "databasePassword"
			}
		}{...}
	}
}

#####API: create

MySql create(String configName)

Returns an instance of MySqlGroup class

MySqlGroup class

getOne

void getOne(String sql, Array params, Function callback)

Executes a "select" SQL query and passes a result to callback.

If no result is found, the funtion will throw an error.

var mysql = gracenode.mysql.create('peopleDb');
mysql.getOne('SELECT age, gender FROM people WHERE name = ?', ['bob'], function (error, result) {
	if (error) {
		throw new Error('nothing found');
	}	
	// do something here
});

getMany

void getMany(String sql, Array params, Function callback)

Executes a "select" SQL query and passes results to callback

If no result is found, the function will throw an error.

searchOne

void searchOne(String sql, Array params, Function callback)

Executes a "select" SQL query and passes a result to callback

No result will NOT throw an error.

searchMany

void searchMany(String sql, Array params, Function callback)

Executes a "select" SQL query and passes results to callback

No result will NOT throw an error.

write

void write(String sql, Array params, Function callback)

Executes "insert/update/delete/truncate/alter/create/drop/" SQL query

Can NOT be executed if the type is "ro"

transaction

void transaction(Function taskCallback, Function callback)

Creates Mysql transaction and allows you to execute transactional SQL queries in taskCallback.

Commit will be executed automatically on successful execution of taskCallback

An error in taskCallback will cause auto-rollback and ends the transaction.

Can NOT be executed if the type is "ro"

var mysql = gracenode.mysql.create('animalDb');
mysql.transaction(function (transactionMysql, finishCallback) {
	transactionMysql.write('INSERT INTO animal (name, species) VALUES(?, ?)', ['dog', 'knine'], function (error, res) {
		if (error) {
			return finishCallback(error);
		}
		transactionMysql.write('INSERT INTO food (animalName, amount) VALUES(?, ?)', ['dog', 10], function (error, res) {
			if (error) {
				return finishCallback(error);
			}
			// taskCallback is done. now move forward
			finishCallback();
		});
	});
}, 
function (error) {
	if (error) {
		throw new Error(error);
	}
	// All done and committed
});

placeHolder

Array placeHolder(Array params)

Creates and returns an array of ? based on params given.

var mysql = gracenode.create('people');
var params = ['jenny', 'ben', 'krista', 'ken'];
mysql.searchMany('SELECT * FROM people WHERE name IN (' + mylsq.placeHolder(params) + ')', params, function (error, res) {
	if (error) {
		throw new Error(error);
	}	
	// do something here
});