X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=tests%2FDatabaseTest.php;h=4f0275493c8f659d28734c99052cd3145080ff2a;hb=fe51c53798e5b2ec0032c478ade8bb7b1255a023;hp=79af5b5468a9495f86d390ceda58d1afdc4d64eb;hpb=83f49fcf15c29263f1448b728d60245b90f847fa;p=friendica.git

diff --git a/tests/DatabaseTest.php b/tests/DatabaseTest.php
index 79af5b5468..4f0275493c 100644
--- a/tests/DatabaseTest.php
+++ b/tests/DatabaseTest.php
@@ -5,65 +5,56 @@
 
 namespace Friendica\Test;
 
-use Friendica\Core\Config;
-use Friendica\Database\DBA;
-use Friendica\Factory;
-use Friendica\Util\BasePath;
-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;
+	protected function setUp()
+	{
+		parent::setUp();
+
+		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();
+	}
+
+	protected function tearDown()
+	{
+		// Rollbacks every DB usage so we don't commit anything into the DB
+		StaticDatabase::statRollback();
+
+		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);
 
-		$basedir = BasePath::create(dirname(__DIR__));
-		$configLoader = new Config\ConfigCacheLoader($basedir);
-		$config = Factory\ConfigFactory::createCache($configLoader);
+		$data = include $fixture;
 
-		DBA::connect(
-			$config,
-			getenv('MYSQL_HOST'),
-			getenv('MYSQL_USERNAME'),
-			getenv('MYSQL_PASSWORD'),
-			getenv('MYSQL_DATABASE'));
+		foreach ($data as $tableName => $rows) {
+			if (!is_array($rows)) {
+				$dba->p('TRUNCATE TABLE `' . $tableName . '``');
+				continue;
+			}
 
-		if (!DBA::connected()) {
-			$this->markTestSkipped('Could not connect to the database.');
+			foreach ($rows as $row) {
+				$dba->insert($tableName, $row);
+			}
 		}
-
-		return $this->createDefaultDBConnection(DBA::getConnection(), getenv('MYSQL_DATABASE'));
-	}
-
-	/**
-	 * 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');
 	}
 }