// 使用Doctrine DBAL示例
use Doctrine\DBAL\Types\Type;

// 定义自定义枚举类型
class UserStatusType extends Type
{
    const USER_STATUS = 'userstatus';
    const ACTIVE = 'active';
    const INACTIVE = 'inactive';
    const SUSPENDED = 'suspended';

    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform)
    {
        return "ENUM('active', 'inactive', 'suspended')";
    }

    public function convertToPHPValue($value, AbstractPlatform $platform)
    {
        return $value;
    }

    public function convertToDatabaseValue($value, AbstractPlatform $platform)
    {
        if (!in_array($value, [self::ACTIVE, self::INACTIVE, self::SUSPENDED])) {
            throw new \InvalidArgumentException("Invalid status");
        }
        return $value;
    }

    public function getName()
    {
        return self::USER_STATUS;
    }
}

// 注册类型
Type::addType(UserStatusType::USER_STATUS, UserStatusType::class);

// 生成枚举类的脚本示例
$pdo = new PDO('mysql:host=localhost;dbname=test', 'user', 'password');
$stmt = $pdo->query("SHOW COLUMNS FROM users WHERE Field = 'status'");
$column = $stmt->fetch(PDO::FETCH_ASSOC);

preg_match("/^enum\(\'(.*)\'\)$/", $column['Type'], $matches);
$enumValues = explode("','", $matches[1]);

$enumClass = "<?php\n\n";
$enumClass .= "namespace App\Enums;\n\n";
$enumClass .= "class UserStatus\n";
$enumClass .= "{\n";

foreach ($enumValues as $value) {
    $constName = strtoupper(str_replace(' ', '_', $value));
    $enumClass .= "    const {$constName} = '{$value}';\n";
}

$enumClass .= "}\n";

file_put_contents('src/Enums/UserStatus.php', $enumClass);

// 定义原生枚举
enum UserStatus: string
{
    case ACTIVE = 'active';
    case INACTIVE = 'inactive';
    case SUSPENDED = 'suspended';
}

// 使用示例
$status = UserStatus::from('active'); // 自动验证