<?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 Dice\Dice;
+use Friendica\Database\Database;
use Friendica\Database\DBStructure;
-use Friendica\Factory;
+use Friendica\DI;
use Friendica\Test\DatabaseTest;
-use Friendica\Util\BasePath;
-use Friendica\Util\Config\ConfigFileLoader;
+use Friendica\Test\Util\Database\StaticDatabase;
class DBStructureTest extends DatabaseTest
{
- public function setUp()
+ protected function setUp(): void
{
- $basePath = BasePath::create(dirname(__DIR__) . '/../../');
- $mode = new App\Mode($basePath);
- $router = new App\Router();
- $configLoader = new ConfigFileLoader($basePath, $mode);
- $configCache = Factory\ConfigFactory::createCache($configLoader);
- $profiler = Factory\ProfilerFactory::create($configCache);
- Factory\DBFactory::init($basePath, $configCache, $profiler, $_SERVER);
- $config = Factory\ConfigFactory::createConfig($configCache);
- Factory\ConfigFactory::createPConfig($configCache);
- $logger = Factory\LoggerFactory::create('test', $config, $profiler);
- $this->app = new App($config, $mode, $router, $logger, $profiler, 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));
}
}