[frio] Add friendica-tagsinput library based on bootstrap-tagsinput

[friendica.git] / tests / DatabaseTest.php

diff --git a/tests/DatabaseTest.php b/tests/DatabaseTest.php
index 5f9d3bf72cdc05b835e18443463f01c5bc49a296..4f0275493c8f659d28734c99052cd3145080ff2a 100644 (file)
--- a/tests/DatabaseTest.php
+++ b/tests/DatabaseTest.php
@@ -5,88 +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\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);
+                       }
+               }
        }
 }