getEnumValues(); $enumValues = null !== $rawEnumValues ? array_values(array_filter($rawEnumValues, 'is_string')) : []; $baseDefinition = self::buildBaseDefinition($options->getType(), $enumValues, $options->getSize()); $nullClause = $options->isNullable() ? 'NULL' : 'NOT NULL'; $parts = [$baseDefinition, $nullClause]; $defaultValue = $options->getDefaultValue(); if (null !== $defaultValue) { $parts[] = 'DEFAULT ' . self::quoteDefaultValue($options->getType(), $defaultValue); } return implode(' ', $parts); } /** * Returns the base SQL type string (without NULL/NOT NULL or DEFAULT). * * @param ExtraPropertyType $type * @param list $enumValues Only used for Choice type * @param int|null $size For STRING type: varchar length (1–16383). Defaults to 255 when null. * Ignored for all other types. * * @return string */ private static function buildBaseDefinition(ExtraPropertyType $type, array $enumValues, ?int $size = null): string { return match ($type) { ExtraPropertyType::INT => 'INT(11)', ExtraPropertyType::BOOL => 'TINYINT(1) UNSIGNED', ExtraPropertyType::STRING => 'VARCHAR(' . (null !== $size && $size > 0 ? $size : 255) . ')', ExtraPropertyType::FLOAT => 'DECIMAL(20,6)', ExtraPropertyType::DATE => 'DATETIME', ExtraPropertyType::HTML => 'TEXT', ExtraPropertyType::JSON => 'LONGTEXT', ExtraPropertyType::CHOICE => !empty($enumValues) ? self::buildEnumDefinition($enumValues) : 'VARCHAR(64)', }; } /** * Extracts the literals of a SQL ENUM column type, e.g. "enum('a','b')" → ['a', 'b']. * Parsing counterpart of buildEnumDefinition(). * * Returns null for any non-ENUM column type. * * @return list|null */ public static function parseEnumValues(string $sqlColumnType): ?array { if (!str_starts_with(strtolower($sqlColumnType), 'enum(')) { return null; } // Literals are single-quoted; embedded quotes are doubled (''). preg_match_all("/'((?:[^']|'')*)'/", $sqlColumnType, $matches); $values = array_map( static fn (string $value): string => str_replace("''", "'", $value), $matches[1] ); return [] !== $values ? array_values($values) : null; } /** * Builds an ENUM SQL definition from a list of allowed values, with proper single-quote escaping. * * @param list $enumValues * * @return string e.g. "ENUM('pending','active','closed')" */ private static function buildEnumDefinition(array $enumValues): string { $quotedValues = array_map( static fn (string $v): string => "'" . str_replace("'", "''", $v) . "'", $enumValues ); return 'ENUM(' . implode(',', $quotedValues) . ')'; } /** * Formats a default value as a SQL literal appropriate for the given type. * * Numeric types are unquoted; string-like types are single-quoted with escaping. * * @param ExtraPropertyType $type * @param scalar $defaultValue * * @return string */ private static function quoteDefaultValue(ExtraPropertyType $type, mixed $defaultValue): string { return match ($type) { ExtraPropertyType::INT, ExtraPropertyType::FLOAT => (string) $defaultValue, ExtraPropertyType::BOOL => $defaultValue ? '1' : '0', ExtraPropertyType::STRING, ExtraPropertyType::DATE, ExtraPropertyType::HTML, ExtraPropertyType::JSON, ExtraPropertyType::CHOICE => "'" . str_replace("'", "''", (string) $defaultValue) . "'", }; } }