3 namespace Friendica\Test\Database;
6 use Friendica\Core\Config;
7 use Friendica\Database\DBStructure;
9 use Friendica\Test\DatabaseTest;
10 use Friendica\Util\BasePath;
12 class DBStructureTest extends DatabaseTest
14 public function setUp()
16 $basedir = BasePath::create(dirname(__DIR__) . '/../../');
17 $configLoader = new Config\ConfigCacheLoader($basedir);
18 $config = Factory\ConfigFactory::createCache($configLoader);
19 $logger = Factory\LoggerFactory::create('test', $config);
20 $this->app = new App($config, $logger, false);
21 $this->logOutput = FActory\LoggerFactory::enableTest($this->app->getLogger());
26 Config::set('config', 'hostname', 'localhost');
27 Config::set('system', 'throttle_limit_day', 100);
28 Config::set('system', 'throttle_limit_week', 100);
29 Config::set('system', 'throttle_limit_month', 100);
30 Config::set('system', 'theme', 'system_theme');
36 public function testExists() {
37 $this->assertTrue(DBStructure::existsTable('config'));
39 $this->assertFalse(DBStructure::existsTable('notatable'));
41 $this->assertTrue(DBStructure::existsColumn('config', ['k']));
42 $this->assertFalse(DBStructure::existsColumn('config', ['nonsense']));
43 $this->assertFalse(DBStructure::existsColumn('config', ['k', 'nonsense']));
49 public function testRename() {
52 $fromType = 'varbinary(255) not null';
53 $toType = 'varbinary(255) not null comment \'Test To Type\'';
55 $this->assertTrue(DBStructure::rename('config', [ $fromColumn => [ $toColumn, $toType ]]));
56 $this->assertTrue(DBStructure::existsColumn('config', [ $toColumn ]));
57 $this->assertFalse(DBStructure::existsColumn('config', [ $fromColumn ]));
59 $this->assertTrue(DBStructure::rename('config', [ $toColumn => [ $fromColumn, $fromType ]]));
60 $this->assertTrue(DBStructure::existsColumn('config', [ $fromColumn ]));
61 $this->assertFalse(DBStructure::existsColumn('config', [ $toColumn ]));
67 public function testChangePrimaryKey() {
71 $this->assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
72 $this->assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));