public function testBackup()
{
$this->conn->query('DROP DATABASE IF EXISTS backup_test');
$this->conn->query('CREATE DATABASE IF NOT EXISTS backup_test CHARSET utf8;');
$dest = Connection::create(['dsn' => 'mysql:host=localhost;dbname=backup_test', 'user' => 'root', 'pass' => null, 'connection_options' => [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8']]);
$backup = new MySQLBackup();
$backup->backup($this->conn, $dest);
}
public function backupToDatabase(Connection $source, $databaseName, $dropAndCreate = false)
{
$newDSN = clone $source->getDSN();
if ($newDSN->getAttribute('dbname') == $databaseName) {
throw new LogicException('Backup to the same database.');
}
if ($dropAndCreate) {
$source->query('DROP DATABASE IF EXISTS ' . $databaseName);
$source->query('CREATE DATABASE IF NOT EXISTS ' . $databaseName . ' CHARSET utf8');
}
// Create new dest database connection
$newConfig = $source->getConfig();
$newDSN->setAttribute('dbname', $databaseName);
$newConfig['dsn'] = $newDSN->__toString();
$dest = Connection::create($newConfig);
return $this->backup($source, $dest);
}
/**
* Create connection.
*
* $dbh = new Connection('mysql:host=localhost;dbname=test', $user, $pass);
*
* $pdo = new Connection(
* 'mysql:host=hostname;dbname=defaultDbName',
* 'username',
* 'password',
* array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
* );
*
* $dbh = new Connection('pgsql:dbname=$dbname; host=$host; username=$username; password=$password');
* $pdo = new Connection( 'sqlite::memory:', null, null, array(PDO::ATTR_PERSISTENT => true) );
* sqlite2:mydb.sq2
*/
public function getConnection($sourceId)
{
if ($sourceId === 'default' && $this->config) {
$sourceId = $this->config->getDefaultDataSourceId();
}
// use cached connection objects
if (isset($this->conns[$sourceId])) {
return $this->conns[$sourceId];
}
if (!isset($this->datasources[$sourceId])) {
throw new UndefinedDataSourceException("data source {$sourceId} not found.");
}
// Only for MySQl
// $conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
return $this->conns[$sourceId] = Connection::create($this->datasources[$sourceId]);
}
