KitLoong\MigrationsGenerator\Repositories\MySQLRepository::getSetPresetValues()

Complexity

Conditions	2
Paths	2

Size

Total Lines

16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getSetPresetValues(string $table, string $columnName): ?string
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = app(MigrationGeneratorSetting::class);

        $column = DB::connection($setting->getConnection())->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'set(%'");
        if (count($column) > 0) {
            return substr(
                str_replace('set(', '[', $column[0]->Type),
                0,
                -1
            ).']';
        }

        return null;
    }
}