class MenuTreeStorageSchemaUpdateTest

class MenuTreeStorageSchemaUpdateTest extends UpdatePathTestBase {
    
    /**
     * The database.
     *
     * @var \Drupal\Core\Database\Connection
     */
    protected Connection $connection;
    
    /**
     * {@inheritdoc}
     */
    protected function setUp() : void {
        parent::setUp();
        
        /** @var \Drupal\Core\Database\Connection $connection */
        $this->connection = \Drupal::service('database');
    }
    
    /**
     * {@inheritdoc}
     */
    protected function setDatabaseDumpFiles() : void {
        $this->databaseDumpFiles = [
            // Start with a bare installation of Drupal 10.3.0.
DRUPAL_ROOT . '/core/modules/system/tests/fixtures/update/drupal-10.3.0.bare.standard.php.gz',
        ];
    }
    
    /**
     * Tests DB behavior after update.
     */
    public function testSchemaLengthAfterUpdate() : void {
        if (\Drupal::service('database')->databaseType() == 'sqlite') {
            $this->markTestSkipped("This test does not support the SQLite database driver.");
        }
        $results = $this->connection
            ->query('SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :menu AND COLUMN_NAME IN ( :column_names[] )', [
            ':menu' => $this->connection
                ->schema()
                ->prefixNonTable('menu_tree'),
            ':column_names[]' => [
                'route_param_key',
                'url',
            ],
        ])
            ->fetchCol();
        $this->assertNotEmpty($results);
        foreach ($results as $result) {
            self::assertEquals(255, $result);
        }
        $this->runUpdates();
        $results = $this->connection
            ->query('SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :menu AND COLUMN_NAME IN ( :column_names[] )', [
            ':menu' => $this->connection
                ->schema()
                ->prefixNonTable('menu_tree'),
            ':column_names[]' => [
                'route_param_key',
                'url',
            ],
        ])
            ->fetchCol();
        $this->assertNotEmpty($results);
        foreach ($results as $result) {
            self::assertEquals(2048, $result);
        }
    }

}