Emergency Feature request : MySqlGrammar & MySqlProcessor to return a column Length 🙏😭🙏

[Ronan-Lenor]

Hi,

i need to get the length of a column and saw that the arrays returned by Schema::getConnection()->getSchemaBuilder()->getColumns('my_table') don't have it.

That would be super easy and fast to add that property in the result by modifying :
.\src\Illuminate\Database\Schema\Grammars\MySqlGrammar.php > compileColumns()

'select column_name as `name`, data_type as `type_name`, column_type as `type`, '
.'character_maximum_length as `length`, '    // < here

.\src\Illuminate\Database\Query\Processors\MySqlProcessor.php > processColumns()

return [
     ,...
    'type' => $result->type,
    'length' => $result->length,    // < here
     ,...
];

is it possible ? 🙄

[ghost]

If it will be implemented it will be with luck in L11, maybe only in L12. Until then you can do it on your own using macros or custom implementation.

[hafezdivandari]

$columns = collect(Schema::getColumns('my_table'))->map(function ($column) {
    $column['length'] = in_array($column['type_name'], ['char', 'varchar', 'binary', 'varbinary'])
        ? (int) Str::between($column['type'], '(', ')')
        : null;

    return $column;
})->all();

[Ronan-Lenor]

this won't work with longtext

[hafezdivandari]

Use this table to return the propper length for text type: https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html#data-types-storage-reqs-strings

[Ronan-Lenor]

i have replace my getColumns calls with something sightly different (So the length is directly given by my database) :

    /**
     * (Laravel v11.20.0) GetColumns() Polyfill
     * 
     * vendor\laravel\framework\src\Illuminate\Database\Schema\MySqlBuilder.php > getColumns()
     * 
     * Add Length
     *
     * @param  \Illuminate\Database\MySqlConnection     $schemaConnection
     * @param  string                                   $tableName
     * 
     * @return array
     */
    public function schemaBuilderGetColumns(\Illuminate\Database\MySqlConnection $schemaConnection, string $tableName)
    {
        $schemaGrammar       = $schemaConnection->getSchemaGrammar();
        $schemaPostProcessor = $schemaConnection->getPostProcessor();

        $oColumns = $schemaConnection->selectFromWriteConnection(
            // replace : vendor\laravel\framework\src\Illuminate\Database\Schema\Grammars\MySqlGrammar.php > compileColumns()
            // add length
            sprintf(
                'select column_name as `name`, data_type as `type_name`, column_type as `type`, '
                .'character_maximum_length as `length`, '
                .'collation_name as `collation`, is_nullable as `nullable`, '
                .'column_default as `default`, column_comment as `comment`, '
                .'generation_expression as `expression`, extra as `extra` '
                .'from information_schema.columns where table_schema = %s and table_name = %s '
                .'order by ordinal_position asc',
                $schemaGrammar->quoteString($schemaConnection->getDatabaseName()),
                $schemaGrammar->quoteString($schemaConnection->getTablePrefix().$tableName)
            )
        );

        // vendor\laravel\framework\src\Illuminate\Database\Query\Processors\MySqlProcessor.php > processColumns()
        // length not handled
        $aColumns = $schemaPostProcessor->processColumns($oColumns);
        
        if (array_key_exists('length', $aColumns[0] ?? []))
        {
            throw new Exception('Laravel getColumns() now supports length. Replace & remove schemaBuilderGetColumns()');
        }
        
        // add length
        foreach($oColumns as $index => $oColumn)
        {
            $aColumns[$index]['length'] = $oColumn->length;
        }

        return $aColumns;
    }