public function query($query, $mode = SQLDatabaseModel::MODE_ASSOC, $bind = null, $key = false)
{
$rows = array();
SQLDBDataStore::log($query, $bind);
$query = mb_convert_encoding($query, 'UTF-8', mb_detect_encoding($query));
SQLDBDataStore::$lastQuery = $query;
if (is_array($bind)) {
$rows = Db::boundQuery($query, Db::$defaultDatabase, $bind, $mode, $key);
} else {
$rows = Db::query($query, Db::$defaultDatabase, $mode);
}
if ($rows === false) {
$errorMessage = pg_errormessage(Db::getCachedInstance(Db::$defaultDatabase));
Db::query("ROLLBACK", Db::$defaultDatabase);
throw new Exception("PGSQL Says {$errorMessage} query :{$query}");
}
self::$namesSeen = array();
return $rows;
}
public function query($query, $mode = SQLDatabaseModel::MODE_ASSOC)
{
//$connection = Db::getCachedInstance();
$rows = array();
if (SQLDBDataStore::$logQueries) {
SQLDBDataStore::log($query);
}
if (mb_detect_encoding($query) != 'UTF-8') {
$query = mb_convert_encoding($query, 'UTF-8', mb_detect_encoding($query));
}
SQLDBDataStore::$lastQuery = $query;
$rows = Db::query($query, Db::$defaultDatabase, $mode);
if ($rows === false) {
$errorMessage = pg_errormessage(Db::getCachedInstance(Db::$defaultDatabase));
Db::query("ROLLBACK", Db::$defaultDatabase);
throw new Exception("PGSQL Says {$errorMessage} query :{$query}");
}
self::$namesSeen = array();
return $rows;
}
