Skip to content

RC4

Pre-release
Pre-release
Compare
Choose a tag to compare
@dedmen dedmen released this 13 Jan 17:11
· 69 commits to master since this release

New stuff:

dbCreateConnection "configname"
dbPrepareQueryConfig "configname"
dbPrepareQueryConfig ["configname", [binding1, binding2, ...]]
dbPrepareQuery ["INSERT ....", [binding1, binding2, ...]]
dbReloadConfig
accounts:
 maindb: #production db, don't break things here!
  ip: 127.0.0.1
  username: root
  password: lulz
  database: production
  port: 3306 #optional
 testdb: #testserver
  ip: 127.0.0.2
  username: root
  password: lulz
  database: production
  port: 3306 #optional

statements:
 insertStuff: INSERT INTO table (a,b,c) VALUES (?,?,?)
 deleteStuff: DELETE FROM table WHERE a=?
_connection = dbCreateConnection "testdb";
_query = dbPrepareQueryConfig ["deleteStuff", [15]];
_connection dbExecuteAsync _query;

All commands renamed from db_stuff to dbStuff
db_query renamed to dbExecute

DB_Connection = dbCreateConnection ["ip", 3306, "user", "password", "db"];
_query = dbPrepareQuery 'SELECT intel_missionen.`name` FROM intel_missionen WHERE intel_missionen.id > ?';
_query dbBindValue 400;
_result = DB_Connection dbExecuteAsync _query;

_result db_bindCallback [{
	params ["_result", "_args"];

	DB_RES = [dbResultToArray _result, _args];
	systemChat "got result!";
}, 1];
DB_Connection = dbCeateConnection ["ip", 3306, "user", "password", "db"];

[] spawn {
	Sleep 5;
	_query = dbPrepareQuery 'SELECT intel_missionen.`name` FROM intel_missionen WHERE intel_missionen.id > ?';
	_query dbBindValue 400;

	_start = diag_tickTime;

	_result = DB_Connection dbExecute _query;
	
	systemChat str ["got result!", diag_tickTime - _start];

	DB_RES = [dbResultToArray _result];
};