Sets the fetch mode.
| public setFetchMode ( integer $fetchMode ) : void | ||
| $fetchMode | integer | |
| return | void | |
/**
* setup configuration for Doctrine Dbal.
*
* @param array $db_config array config for override the default configuration.
*/
public function setupConfigurationDbal(array $db_config = [])
{
$dbal_config = new Configuration();
if (empty($db_config)) {
//setup connection configuration.
$config = new SystemConfig();
$config->load('db');
$db_params = $config->get('ALL', 'db');
unset($config, $db_params['table_prefix']);
} else {
$db_params = $db_config;
unset($db_params['table_prefix']);
}
$dbal_config->setSQLLogger(new \System\Libraries\Db\Logger());
try {
$this->Conn = DriverManager::getConnection($db_params, $dbal_config);
$this->Conn->connect();
} catch (\Doctrine\DBAL\DBALException $e) {
http_response_code(500);
echo $e->getMessage();
exit;
}
$this->Conn->setFetchMode(\PDO::FETCH_OBJ);
unset($dbal_config, $db_params);
}
public function connect()
{
if ($this->connection === null) {
$connection_params = array('dbname' => config()->db_name(), 'user' => config()->db_user(), 'password' => config()->db_pass(), 'host' => config()->db_host(), 'driver' => 'pdo_mysql');
$this->connection = \Doctrine\DBAL\DriverManager::getConnection($connection_params, new \Doctrine\DBAL\Configuration());
$this->connection->setFetchMode(\PDO::FETCH_OBJ);
}
}
/**
* Contructor
*
* @var string $dsn The connection string
* @var string $tablePrefix Table prefix
*/
public function __construct($dsn, $tablePrefix = null)
{
$this->con = \Doctrine\DBAL\DriverManager::getConnection(array('url' => $dsn));
$this->con->setFetchMode(\PDO::FETCH_ASSOC);
if (!empty($tablePrefix)) {
foreach ($this->tables as $tableName) {
$this->tables[$tableName] = rtrim($tablePrefix, '_') . '_' . $tableName;
}
}
}
public function __construct(Connection $connection)
{
$this->connection = $connection;
$this->connection->setFetchMode(\PDO::FETCH_OBJ);
}