namespace Friendica\Test;
-use Friendica\App\Mode;
-use Friendica\Core\Config\Cache\ConfigCache;
use Friendica\Database\Database;
-use Friendica\Factory\ConfigFactory;
-use Friendica\Factory\DBFactory;
-use Friendica\Factory\ProfilerFactory;
-use Friendica\Util\BasePath;
-use Friendica\Util\ConfigFileLoader;
-use Friendica\Util\Profiler;
-use PHPUnit\DbUnit\DataSet\YamlDataSet;
-use PHPUnit\DbUnit\TestCaseTrait;
-use PHPUnit_Extensions_Database_DB_IDatabaseConnection;
-use Psr\Log\NullLogger;
-
-require_once __DIR__ . '/../boot.php';
+use Friendica\Test\Util\Database\StaticDatabase;
/**
* Abstract class used by tests that need a database.
*/
abstract class DatabaseTest extends MockedTest
{
- use TestCaseTrait;
-
- /** @var Database */
- protected static $dba;
-
- /** @var BasePath */
- protected static $basePath;
-
- /** @var Mode */
- protected static $mode;
-
- /** @var ConfigCache */
- protected static $configCache;
+ protected function setUp()
+ {
+ parent::setUp();
- /** @var Profiler */
- protected static $profiler;
+ 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();
+ }
- public static function setUpBeforeClass()
+ protected function tearDown()
{
- parent::setUpBeforeClass();
+ // Rollbacks every DB usage so we don't commit anything into the DB
+ StaticDatabase::statRollback();
- self::$basePath = new BasePath(dirname(__DIR__));
- $configLoader = new ConfigFileLoader(self::$basePath->getPath());
- $configFactory = new ConfigFactory();
- self::$configCache = $configFactory->createCache($configLoader);
- self::$profiler = new Profiler(self::$configCache);
- self::$dba = new Database(self::$configCache, self::$profiler, new NullLogger(), $_SERVER);
- self::$mode = new Mode(self::$basePath, self::$dba, self::$configCache);
+ parent::tearDown();
}
/**
- * Get database connection.
+ * Loads a given DB fixture for this DB test
*
- * 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.
+ * @param string $fixture The path to the fixture
+ * @param Database $dba The DB connection
*
- * 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
+ * @throws \Exception
*/
- protected function getConnection()
+ protected function loadFixture(string $fixture, Database $dba)
{
- if (!getenv('MYSQL_DATABASE')) {
- $this->markTestSkipped('Please set the MYSQL_* environment variables to your test database credentials.');
- }
+ $this->assertFileExists($fixture);
- if (!self::$dba->isConnected()) {
- if (!self::$dba->connect()) {
- $this->markTestSkipped('Could not connect to the database.');
- }
- }
+ $data = include $fixture;
- return $this->createDefaultDBConnection(self::$dba->getConnection(), getenv('MYSQL_DATABASE'));
- }
+ foreach ($data as $tableName => $rows) {
+ if (!is_array($rows)) {
+ $dba->p('TRUNCATE TABLE `' . $tableName . '``');
+ continue;
+ }
- /**
- * Get dataset to populate the database with.
- * @return YamlDataSet
- * @see https://phpunit.de/manual/5.7/en/database.html
- */
- protected function getDataSet()
- {
- return new YamlDataSet(__DIR__ . '/datasets/api.yml');
+ foreach ($rows as $row) {
+ $dba->insert($tableName, $row);
+ }
+ }
}
}