1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 |
- <?php
- /**
- * SPDX-FileCopyrightText: 2017-2024 Nextcloud GmbH and Nextcloud contributors
- * SPDX-FileCopyrightText: 2017 ownCloud, Inc.
- * SPDX-License-Identifier: AGPL-3.0-only
- */
- namespace Test\DB;
- use Doctrine\DBAL\Platforms\PostgreSQL100Platform;
- use Doctrine\DBAL\Schema\Comparator;
- use Doctrine\DBAL\Schema\Schema;
- use Doctrine\DBAL\Types\Types;
- /**
- * Class OCPostgreSqlPlatformTest
- *
- * custom OCPostgreSqlPlatform behavior has been upstreamed, test is left to
- * ensure behavior stays correct.
- *
- * @group DB
- *
- * @package Test\DB
- */
- class OCPostgreSqlPlatformTest extends \Test\TestCase {
- public function testAlterBigint() {
- $platform = new PostgreSQL100Platform();
- $sourceSchema = new Schema();
- $targetSchema = new Schema();
- $this->createTableAndColumn($sourceSchema, Types::INTEGER);
- $this->createTableAndColumn($targetSchema, Types::BIGINT);
- $comparator = new Comparator();
- $diff = $comparator->compare($sourceSchema, $targetSchema);
- $sqlStatements = $diff->toSql($platform);
- $this->assertContains(
- 'ALTER TABLE poor_yorick ALTER id TYPE BIGINT',
- $sqlStatements,
- true
- );
- $this->assertNotContains(
- 'ALTER TABLE poor_yorick ALTER id DROP DEFAULT',
- $sqlStatements,
- true
- );
- }
- protected function createTableAndColumn($schema, $type) {
- $table = $schema->createTable("poor_yorick");
- $table->addColumn('id', $type, [
- 'autoincrement' => true,
- 'unsigned' => true,
- 'notnull' => true,
- 'length' => 11,
- ]);
- }
- }
|