/**
* After connecting, update this connection's database settings.
*
* Note: Doctrine expects this method to be called postConnect
*
* @param ConnectionEventArgs $args
*/
public function postConnect(ConnectionEventArgs $args)
{
$db = $args->getConnection();
$platform = $args->getDatabasePlatform()->getName();
if ($platform === 'sqlite') {
$db->query('PRAGMA synchronous = OFF');
} elseif ($platform === 'mysql') {
/**
* @link https://groups.google.com/forum/?fromgroups=#!topic/silex-php/AR3lpouqsgs
*/
$db->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
// Set utf8 on names and connection, as all tables have this charset. We don't
// also do 'SET CHARACTER SET utf8', because it will actually reset the
// character_set_connection and collation_connection to @@character_set_database
// and @@collation_database respectively.
// see: http://stackoverflow.com/questions/1566602/is-set-character-set-utf8-necessary
$db->executeQuery('SET NAMES utf8');
$db->executeQuery('SET CHARACTER_SET_CONNECTION = utf8');
// Increase group_concat_max_len to 100000. By default, MySQL
// sets this to a low value – 1024 – which causes issues with
// certain Bolt content types – particularly repeaters – where
// the outcome of a GROUP_CONCAT() query will be more than 1024 bytes.
// See also: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_group_concat_max_len
$db->executeQuery('SET SESSION group_concat_max_len = 100000');
} elseif ($platform === 'postgresql') {
/**
* @link https://github.com/doctrine/dbal/pull/828
*/
$db->executeQuery("SET NAMES 'utf8'");
}
}
/**
* After connecting, update this connection's database settings.
*
* Note: Doctrine expects this method to be called postConnect
*
* @param ConnectionEventArgs $args
*/
public function postConnect(ConnectionEventArgs $args)
{
$db = $args->getConnection();
$platform = $args->getDatabasePlatform()->getName();
if ($platform === 'sqlite') {
$db->query('PRAGMA synchronous = OFF');
} elseif ($platform === 'mysql') {
/**
* @link https://groups.google.com/forum/?fromgroups=#!topic/silex-php/AR3lpouqsgs
*/
$db->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
// Set utf8 on names and connection, as all tables have this charset. We don't
// also do 'SET CHARACTER SET utf8', because it will actually reset the
// character_set_connection and collation_connection to @@character_set_database
// and @@collation_database respectively.
// see: http://stackoverflow.com/questions/1566602/is-set-character-set-utf8-necessary
$db->executeQuery('SET NAMES utf8');
$db->executeQuery('SET CHARACTER_SET_CONNECTION = utf8');
} elseif ($platform === 'postgresql') {
/**
* @link https://github.com/doctrine/dbal/pull/828
*/
$db->executeQuery("SET NAMES 'utf8'");
}
}
/**
* {@inheritdoc}
*/
public function postConnect(ConnectionEventArgs $args)
{
if ($args->getDatabasePlatform() instanceof OraclePlatform) {
parent::postConnect($args);
}
}
