<?php
/**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2023, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
class DBStructureTest extends DatabaseTest
{
- protected function setUp()
+ protected function setUp(): void
{
parent::setUp();
* @small
*/
public function testExists() {
- $this->assertTrue(DBStructure::existsTable('config'));
+ self::assertTrue(DBStructure::existsTable('user'));
+ self::assertFalse(DBStructure::existsTable('notatable'));
- $this->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() {
- $oldID = 'id';
+ static::markTestSkipped('rename primary key with autoincrement and foreign key support necessary first');
+ $oldID = 'client_id';
$newID = 'pw';
- $this->assertTrue(DBStructure::rename('poll', [ $newID ], DBStructure::RENAME_PRIMARY_KEY));
- $this->assertTrue(DBStructure::rename('poll', [ $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));
}
}