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

diff --git a/tests/DatabaseTest.php b/tests/DatabaseTest.php
index 4dffc56878..4f0275493c 100644
--- a/tests/DatabaseTest.php
+++ b/tests/DatabaseTest.php
@@ -5,90 +5,56 @@
 
 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);
+			}
+		}
 	}
 }