public function dbW()
{
Doo::loadCore('db/DooSqlMagic');
$dbW = new DooSqlMagic();
$dbW->setDb(Doo::conf()->db_write, Doo::conf()->APP_MODE);
$dbW->connect();
return $dbW;
}
public function dbAAA2()
{
Doo::loadCore('db/DooSqlMagic');
$dbAAA = new DooSqlMagic();
$dbAAA->setDb(Doo::conf()->db_aaa2, Doo::conf()->APP_MODE);
$dbAAA->connect();
return $dbAAA;
}
/**
* Execute a query to the connected database. Auto toggle between master & slave.
*
* @param string $query SQL query prepared statement
* @param array $param Values used in the prepared SQL
* @return PDOStatement
*/
public function query($query, $param = null)
{
if ($this->autoToggle === True) {
$isSelect = strtoupper(substr($query, 0, 6)) == 'SELECT';
//change to master if update, insert, delete, create connection if not exist
if (!isset($this->pdoList[$isSelect])) {
#echo '<h1>Master connected</h1>';
$this->connectMaster();
} else {
$rr = $isSelect ? 'Slave' : 'Master';
#echo '<h1>'. $rr .' used</h1>';
$this->pdo = $this->pdoList[$isSelect];
}
}
return parent::query($query, $param);
}
