spelling: cached

[friendica.git] / tests / src / Database / DBStructureTest.php

diff --git a/tests/src/Database/DBStructureTest.php b/tests/src/Database/DBStructureTest.php
index ef777b30e8164ebb6afc77f22f441eacf6f31af9..dfb46514fd21e6062adeec9772f5695ae0b66845 100644 (file)
--- a/tests/src/Database/DBStructureTest.php
+++ b/tests/src/Database/DBStructureTest.php
@@ -1,76 +1,84 @@
 <?php
+/**
+ * @copyright Copyright (C) 2010-2023, the Friendica project
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ *
+ */
 
 namespace Friendica\Test\src\Database;
 
-use Friendica\App;
-use Friendica\Core\Config\Cache\PConfigCache;
-use Friendica\Core\L10n\L10n;
+use Dice\Dice;
+use Friendica\Database\Database;
 use Friendica\Database\DBStructure;
-use Friendica\Factory;
-use Friendica\Model\Config\Config;
+use Friendica\DI;
 use Friendica\Test\DatabaseTest;
-use Friendica\Util\BaseURL;
+use Friendica\Test\Util\Database\StaticDatabase;
 
 class DBStructureTest extends DatabaseTest
 {
-       /**
-        * @throws \Friendica\Network\HTTPException\InternalServerErrorException
-        */
-       public function setUp()
+       protected function setUp(): void
        {
-               $configModel = new Config(self::$dba);
-               $config = Factory\ConfigFactory::createConfig(self::$configCache, $configModel);
-               $pconfigModel = new \Friendica\Model\Config\PConfig(self::$dba);
-               Factory\ConfigFactory::createPConfig(self::$configCache, new PConfigCache(), $pconfigModel);
-               $logger = Factory\LoggerFactory::create('test', self::$dba, $config, self::$profiler);
-               $baseUrl = new BaseURL($config, $_SERVER);
-               $router = new App\Router();
-               $l10n = new L10n($config,
-                       self::$dba,
-                       $logger);
-               $this->app = new App(self::$dba, $config, self::$mode, $router, $baseUrl, $logger, self::$profiler, $l10n, false);
                parent::setUp();
+
+               $dice = (new Dice())
+                       ->addRules(include __DIR__ . '/../../../static/dependencies.config.php')
+                       ->addRule(Database::class, ['instanceOf' => StaticDatabase::class, 'shared' => true]);
+               DI::init($dice);
        }
 
        /**
         * @small
         */
        public function testExists() {
-               $this->assertTrue(DBStructure::existsTable('config'));
-
-               $this->assertFalse(DBStructure::existsTable('notatable'));
+               self::assertTrue(DBStructure::existsTable('user'));
+               self::assertFalse(DBStructure::existsTable('notatable'));
 
-               $this->assertTrue(DBStructure::existsColumn('config', ['k']));
-               $this->assertFalse(DBStructure::existsColumn('config', ['nonsense']));
-               $this->assertFalse(DBStructure::existsColumn('config', ['k', 'nonsense']));
+               self::assertTrue(DBStructure::existsColumn('user', ['uid']));
+               self::assertFalse(DBStructure::existsColumn('user', ['nonsense']));
+               self::assertFalse(DBStructure::existsColumn('user', ['uid', 'nonsense']));
        }
 
        /**
         * @small
         */
        public function testRename() {
-               $fromColumn = 'k';
-               $toColumn = 'key';
-               $fromType = 'varbinary(255) not null';
-               $toType = 'varbinary(255) not null comment \'Test To Type\'';
+               $fromColumn = 'email';
+               $toColumn = 'email_key';
+               $fromType = 'varchar(255) NOT NULL DEFAULT \'\' COMMENT \'the users email address\'';
+               $toType = 'varchar(255) NOT NULL DEFAULT \'\' COMMENT \'Adapted column\'';
 
-               $this->assertTrue(DBStructure::rename('config', [ $fromColumn => [ $toColumn, $toType ]]));
-               $this->assertTrue(DBStructure::existsColumn('config', [ $toColumn ]));
-               $this->assertFalse(DBStructure::existsColumn('config', [ $fromColumn ]));
+               self::assertTrue(DBStructure::rename('user', [ $fromColumn => [ $toColumn, $toType ]]));
+               self::assertTrue(DBStructure::existsColumn('user', [ $toColumn ]));
+               self::assertFalse(DBStructure::existsColumn('user', [ $fromColumn ]));
 
-               $this->assertTrue(DBStructure::rename('config', [ $toColumn => [ $fromColumn, $fromType ]]));
-               $this->assertTrue(DBStructure::existsColumn('config', [ $fromColumn ]));
-               $this->assertFalse(DBStructure::existsColumn('config', [ $toColumn ]));
+               self::assertTrue(DBStructure::rename('user', [ $toColumn => [ $fromColumn, $fromType ]]));
+               self::assertTrue(DBStructure::existsColumn('user', [ $fromColumn ]));
+               self::assertFalse(DBStructure::existsColumn('user', [ $toColumn ]));
        }
 
        /**
         * @small
         */
        public function testChangePrimaryKey() {
+               static::markTestSkipped('rename primary key with autoincrement and foreign key support necessary first');
                $oldID = 'client_id';
                $newID = 'pw';
 
-               $this->assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
-               $this->assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));
+               self::assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
+               self::assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));
        }
 }