3 namespace Friendica\Test\src\Database;
6 use Friendica\Core\Config\Cache\PConfigCache;
7 use Friendica\Database\DBStructure;
9 use Friendica\Model\Config\Config;
10 use Friendica\Test\DatabaseTest;
11 use Friendica\Util\BaseURL;
13 class DBStructureTest extends DatabaseTest
16 * @throws \Friendica\Network\HTTPException\InternalServerErrorException
18 public function setUp()
20 $configModel = new Config(self::$dba);
21 $config = Factory\ConfigFactory::createConfig(self::$configCache, $configModel);
22 Factory\ConfigFactory::createPConfig(self::$configCache, new PConfigCache());
23 $logger = Factory\LoggerFactory::create('test', self::$dba, $config, self::$profiler);
24 $baseUrl = new BaseURL($config, $_SERVER);
25 $router = new App\Router();
26 $this->app = new App(self::$dba, $config, self::$mode, $router, $baseUrl, $logger, self::$profiler, false);
34 public function testExists() {
35 $this->assertTrue(DBStructure::existsTable('config'));
37 $this->assertFalse(DBStructure::existsTable('notatable'));
39 $this->assertTrue(DBStructure::existsColumn('config', ['k']));
40 $this->assertFalse(DBStructure::existsColumn('config', ['nonsense']));
41 $this->assertFalse(DBStructure::existsColumn('config', ['k', 'nonsense']));
47 public function testRename() {
50 $fromType = 'varbinary(255) not null';
51 $toType = 'varbinary(255) not null comment \'Test To Type\'';
53 $this->assertTrue(DBStructure::rename('config', [ $fromColumn => [ $toColumn, $toType ]]));
54 $this->assertTrue(DBStructure::existsColumn('config', [ $toColumn ]));
55 $this->assertFalse(DBStructure::existsColumn('config', [ $fromColumn ]));
57 $this->assertTrue(DBStructure::rename('config', [ $toColumn => [ $fromColumn, $fromType ]]));
58 $this->assertTrue(DBStructure::existsColumn('config', [ $fromColumn ]));
59 $this->assertFalse(DBStructure::existsColumn('config', [ $toColumn ]));
65 public function testChangePrimaryKey() {
69 $this->assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
70 $this->assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));