3 namespace Friendica\Test\src\Database;
6 use Friendica\Core\Config\Cache\PConfigCache;
7 use Friendica\Database\DBStructure;
9 use Friendica\Test\DatabaseTest;
10 use Friendica\Util\BasePath;
11 use Friendica\Util\BaseURL;
12 use Friendica\Util\Config\ConfigFileLoader;
14 class DBStructureTest extends DatabaseTest
16 public function setUp()
18 $basePath = BasePath::create(dirname(__DIR__) . '/../../');
19 $mode = new App\Mode($basePath);
20 $router = new App\Router();
21 $configLoader = new ConfigFileLoader($basePath, $mode);
22 $configCache = Factory\ConfigFactory::createCache($configLoader);
23 $profiler = Factory\ProfilerFactory::create($configCache);
24 $database = Factory\DBFactory::init($configCache, $profiler, $_SERVER);
25 $config = Factory\ConfigFactory::createConfig($configCache);
26 Factory\ConfigFactory::createPConfig($configCache, new PConfigCache());
27 $logger = Factory\LoggerFactory::create('test', $database, $config, $profiler);
28 $baseUrl = new BaseURL($config, $_SERVER);
29 $this->app = new App($database, $config, $mode, $router, $baseUrl, $logger, $profiler, false);
37 public function testExists() {
38 $this->assertTrue(DBStructure::existsTable('config'));
40 $this->assertFalse(DBStructure::existsTable('notatable'));
42 $this->assertTrue(DBStructure::existsColumn('config', ['k']));
43 $this->assertFalse(DBStructure::existsColumn('config', ['nonsense']));
44 $this->assertFalse(DBStructure::existsColumn('config', ['k', 'nonsense']));
50 public function testRename() {
53 $fromType = 'varbinary(255) not null';
54 $toType = 'varbinary(255) not null comment \'Test To Type\'';
56 $this->assertTrue(DBStructure::rename('config', [ $fromColumn => [ $toColumn, $toType ]]));
57 $this->assertTrue(DBStructure::existsColumn('config', [ $toColumn ]));
58 $this->assertFalse(DBStructure::existsColumn('config', [ $fromColumn ]));
60 $this->assertTrue(DBStructure::rename('config', [ $toColumn => [ $fromColumn, $fromType ]]));
61 $this->assertTrue(DBStructure::existsColumn('config', [ $fromColumn ]));
62 $this->assertFalse(DBStructure::existsColumn('config', [ $toColumn ]));
68 public function testChangePrimaryKey() {
72 $this->assertTrue(DBStructure::rename('clients', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
73 $this->assertTrue(DBStructure::rename('clients', [ $oldID ], DBStructure::RENAME_PRIMARY_KEY));