services.mysql[name].connect = function (db,connectionListener) {
var mysqlModule = require("mysql-native");
if (!mysqlModule) return null;
client = mysqlModule.createTCPClient(this.cred.host,this.cred.port,connectionListener);
client.auto_prepare = true;
client.auth(db,this.cred.username,this.cred.password);
}
function createConnection()
{
var db = mysql.createTCPClient();
db.auto_prepare = true;
db.auth("test", "testuser", "testpass");
return db;
}
drush_exec('hostmaster', 'status', [], {}, function(results) {
settings.mysql.user = results.context.db_user;
settings.mysql.pass = results.context.db_passwd;
settings.mysql.host = results.context.db_host;
settings.mysql.name = results.context.db_name;
settings.mysql.port = results.context.db_port;
db = mysql.createTCPClient(settings.mysql.host, settings.mysql.port);
db.autoprepare = true;
db.auth(settings.mysql.name, settings.mysql.user, settings.mysql.pass)
console.log("connected to db, starting task queue poll");
poll_tasks();
});
var createClient = function(){
cfg.client = cfg.client || 'TCP';
cfg.charset = cfg.charset || 'utf8_general_cs';
switch( cfg.client ){
case 'UNIX' :
cfg.path = cfg.path || false;
var db = mysql.createUNIXClient( cfg.path );
break;
default :
var db = mysql.createTCPClient( cfg.host , cfg.port );
}
db.set('auto_prepare' , false);
db.set('charset' , cfg.charset);
db.auth( cfg.database , cfg.user, cfg.password);
db.query("SET NAMES '"+ cfg.charset.split('_')[0] +"'");
return db;
};
create : function(callback) {
var client = mysql.createTCPClient(process.conf.mysql.ip,process.conf.mysql.port);
client.auth(process.conf.mysql.u,process.conf.mysql.p,process.conf.mysql.db)
callback(null, client);
},