/**
* Open a database connection based on a configuration.
*
* @param array $configuration array('dsn' => '...', 'user' => '...', 'password' => '...')
* @param \Propel\Runtime\Adapter\AdapterInterface $adapter The adapter to use to build the connection
* @param string $defaultConnectionClass
*
* @return \Propel\Runtime\Connection\ConnectionInterface
*/
public static function create($configuration, AdapterInterface $adapter, $defaultConnectionClass = self::DEFAULT_CONNECTION_CLASS)
{
if (isset($configuration['classname'])) {
$connectionClass = $configuration['classname'];
} else {
$connectionClass = $defaultConnectionClass;
}
try {
$adapterConnection = $adapter->getConnection($configuration);
} catch (AdapterException $e) {
throw new ConnectionException("Unable to open connection", 0, $e);
}
$connection = new $connectionClass($adapterConnection);
// load any connection options from the config file
// connection attributes are those PDO flags that have to be set on the initialized connection
if (isset($configuration['attributes']) && is_array($configuration['attributes'])) {
foreach ($configuration['attributes'] as $option => $value) {
if (is_string($value) && false !== strpos($value, '::')) {
if (!defined($value)) {
throw new InvalidArgumentException(sprintf('Invalid class constant specified "%s" while processing connection attributes for datasource "%s"'), $value, $connection->getName());
}
$value = constant($value);
}
$connection->setAttribute($option, $value);
}
}
return $connection;
}
/**
* Performs DB-specific ignore case, but only if the column type necessitates it.
*
* @param string $str The expression we want to apply the ignore case formatting to (e.g. the column name).
* @param \Propel\Runtime\Adapter\AdapterInterface $db
*/
public function ignoreCase($str, AdapterInterface $db)
{
if ($this->isText()) {
return $db->ignoreCase($str);
}
return $str;
}
