3 namespace Friendica\Test\src\Database;
6 use Friendica\Core\Config\Cache\PConfigCache;
7 use Friendica\Core\L10n\L10n;
8 use Friendica\Database\DBStructure;
10 use Friendica\Model\Config\Config;
11 use Friendica\Test\DatabaseTest;
12 use Friendica\Util\BaseURL;
14 class DBStructureTest extends DatabaseTest
17 * @throws \Friendica\Network\HTTPException\InternalServerErrorException
19 public function setUp()
21 $configModel = new Config(self::$dba);
22 $configFactory = new Factory\ConfigFactory();
23 $config = $configFactory->createConfig(self::$configCache, $configModel);
24 $pconfigModel = new \Friendica\Model\Config\PConfig(self::$dba);
25 $configFactory->createPConfig(self::$configCache, new PConfigCache(), $pconfigModel);
26 $loggerFactory = new Factory\LoggerFactory();
27 $logger = $loggerFactory->create('test', self::$dba, $config, self::$profiler);
28 $baseUrl = new BaseURL($config, $_SERVER);
29 $router = new App\Router();
30 $l10n = new L10n($config,
33 $this->app = new App(self::$dba, $config, self::$mode, $router, $baseUrl, $logger, self::$profiler, $l10n, false);
40 public function testExists() {
41 $this->assertTrue(DBStructure::existsTable('config'));
43 $this->assertFalse(DBStructure::existsTable('notatable'));
45 $this->assertTrue(DBStructure::existsColumn('config', ['k']));
46 $this->assertFalse(DBStructure::existsColumn('config', ['nonsense']));
47 $this->assertFalse(DBStructure::existsColumn('config', ['k', 'nonsense']));
53 public function testRename() {
56 $fromType = 'varbinary(255) not null';
57 $toType = 'varbinary(255) not null comment \'Test To Type\'';
59 $this->assertTrue(DBStructure::rename('config', [ $fromColumn => [ $toColumn, $toType ]]));
60 $this->assertTrue(DBStructure::existsColumn('config', [ $toColumn ]));
61 $this->assertFalse(DBStructure::existsColumn('config', [ $fromColumn ]));
63 $this->assertTrue(DBStructure::rename('config', [ $toColumn => [ $fromColumn, $fromType ]]));
64 $this->assertTrue(DBStructure::existsColumn('config', [ $fromColumn ]));
65 $this->assertFalse(DBStructure::existsColumn('config', [ $toColumn ]));
71 public function testChangePrimaryKey() {
75 $this->assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
76 $this->assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));