RC4
Pre-release
Pre-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];
};