App\Traits\TalentCloudCrudTrait::isColumnNullable()

Complexity

Conditions	2
Paths	2

Size

Total Lines	16
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function isColumnNullable(string $column_name) : bool
    {
        // Create an instance of the model to be able to get the table name.
        $instance = new static();
        $conn = DB::connection($instance->getConnectionName());
        $table = Config::get('database.connections.' . Config::get('database.default') . '.prefix') . $instance->getTable();
        // MongoDB columns are alway nullable.
        if ($conn->getConfig()['driver'] === 'mongodb') {
            return true;
        }
        // Register the enum, json, jsonb, and citext column types, because Doctrine doesn't support it.
        $conn->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
        $conn->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('json', 'json_array');
        $conn->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('jsonb', 'json_array');
        $conn->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('citext', 'string');
        return !$conn->getDoctrineColumn($table, $column_name)->getNotnull();
    }