namespace Friendica\Test;
-use Friendica\Database\DBA;
-use PHPUnit\DbUnit\DataSet\YamlDataSet;
-use PHPUnit\DbUnit\TestCaseTrait;
-use PHPUnit_Extensions_Database_DB_IDatabaseConnection;
-
-require_once __DIR__ . '/../boot.php';
+use Friendica\Database\Database;
+use Friendica\Test\Util\Database\StaticDatabase;
/**
* Abstract class used by tests that need a database.
*/
abstract class DatabaseTest extends MockedTest
{
- use TestCaseTrait;
-
- /**
- * Get database connection.
- *
- * This function is executed before each test in order to get a database connection that can be used by tests.
- * If no prior connection is available, it tries to create one using the USER, PASS and DB environment variables.
- *
- * If it could not connect to the database, the test is skipped.
- *
- * @return PHPUnit_Extensions_Database_DB_IDatabaseConnection
- * @see https://phpunit.de/manual/5.7/en/database.html
- */
- protected function getConnection()
+ protected function setUp()
{
- if (!getenv('MYSQL_DATABASE')) {
- $this->markTestSkipped('Please set the MYSQL_* environment variables to your test database credentials.');
- }
+ parent::setUp();
- DBA::connect(getenv('MYSQL_HOST'),
- getenv('MYSQL_USERNAME'),
- getenv('MYSQL_PASSWORD'),
- getenv('MYSQL_DATABASE'));
+ StaticDatabase::statConnect($_SERVER);
+ // Rollbacks every DB usage (in case the test couldn't call tearDown)
+ StaticDatabase::statRollback();
+ // Start the first, outer transaction
+ StaticDatabase::getGlobConnection()->beginTransaction();
+ }
- if (!DBA::connected()) {
- $this->markTestSkipped('Could not connect to the database.');
- }
+ protected function tearDown()
+ {
+ // Rollbacks every DB usage so we don't commit anything into the DB
+ StaticDatabase::statRollback();
- return $this->createDefaultDBConnection(DBA::getConnection(), getenv('MYSQL_DATABASE'));
+ parent::tearDown();
}
/**
- * Get dataset to populate the database with.
- * @return YamlDataSet
- * @see https://phpunit.de/manual/5.7/en/database.html
+ * Loads a given DB fixture for this DB test
+ *
+ * @param string $fixture The path to the fixture
+ * @param Database $dba The DB connection
+ *
+ * @throws \Exception
*/
- protected function getDataSet()
+ protected function loadFixture(string $fixture, Database $dba)
{
- return new YamlDataSet(__DIR__ . '/datasets/api.yml');
+ $this->assertFileExists($fixture);
+
+ $data = include $fixture;
+
+ foreach ($data as $tableName => $rows) {
+ if (!is_array($rows)) {
+ $dba->p('TRUNCATE TABLE `' . $tableName . '``');
+ continue;
+ }
+
+ foreach ($rows as $row) {
+ $dba->insert($tableName, $row);
+ }
+ }
}
}