/**
* Creates connection to test MySQL database
*
* MySQL server must be installed locally, with root access
* and empty password and listening on unix socket
*
* @return PDO
* @see DBUnitTestUtility::setUpMySqlDatabase()
*/
public static function getMySQLDB()
{
if (self::$mySQLConnection === NULL) {
self::$mySQLConnection = new PDO(PHPUNIT_TESTSUITE_EXTENSION_DATABASE_MYSQL_DSN, PHPUNIT_TESTSUITE_EXTENSION_DATABASE_MYSQL_USERNAME, PHPUNIT_TESTSUITE_EXTENSION_DATABASE_MYSQL_PASSWORD);
self::setUpMySQLDatabase(self::$mySQLConnection);
}
return self::$mySQLConnection;
}
public static function getSQLiteMemoryDB()
{
if (self::$connection === NULL) {
self::$connection = new PDO('sqlite::memory:');
self::setUpDatabase(self::$connection);
}
return self::$connection;
}
public function setUp()
{
$this->pdo = DBUnitTestUtility::getSQLiteMemoryDB();
parent::setUp();
$this->dataSet = new PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection());
$this->dataSet->addTable('table1');
$this->dataSet->addTable('query1', '
SELECT
t1.column1 tc1, t2.column5 tc2
FROM
table1 t1
JOIN table2 t2 ON t1.table1_id = t2.table2_id
');
}
public function getConnection()
{
return new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection(DBUnitTestUtility::getSQLiteMemoryDB(), 'sqlite');
}
public function getConnection()
{
return new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection(DBUnitTestUtility::getMySQLDB(), 'mysql');
}
