Spaces:
No application file
No application file
File size: 3,030 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 |
<?php
declare(strict_types=1);
namespace Mautic\LeadBundle\Field;
use Mautic\CoreBundle\Doctrine\Mapping\ClassMetadataBuilder;
class SchemaDefinition
{
/**
* Max length of VARCHAR fields.
* Fields: charLengthLimit.
*/
public const MAX_VARCHAR_LENGTH = 191;
/**
* Get the MySQL database type based on the field type
* Use a static function so that it's accessible from DoctrineSubscriber
* without causing a circular service injection error.
*/
public static function getSchemaDefinition(string $alias, string $type, bool $isUnique = false, int $length = null): array
{
$options = ['notnull' => false];
// Unique is always a string in order to control index length
if ($isUnique) {
return [
'name' => $alias,
'type' => 'string',
'options' => $options,
];
}
switch ($type) {
case 'datetime':
case 'date':
case 'time':
case 'boolean':
$schemaType = $type;
break;
case 'number':
$schemaType = 'float';
break;
case 'timezone':
case 'locale':
case 'country':
case 'email':
case 'lookup':
case 'select':
case 'region':
case 'tel':
case 'url':
$schemaType = 'string';
$options['length'] = $length;
break;
case 'text':
$schemaType = (str_contains($alias, 'description')) ? 'text' : 'string';
$options['length'] = $length;
break;
case 'multiselect':
$schemaType = 'text';
$options['length'] = 65535;
break;
case 'html':
default:
$schemaType = 'text';
}
if ('string' === $schemaType && empty($options['length'])) {
$options['length'] = self::MAX_VARCHAR_LENGTH;
}
return [
'name' => $alias,
'type' => $schemaType,
'options' => $options,
];
}
/**
* @param mixed[] $schemaDefinition
*/
public static function getFieldCharLengthLimit(array $schemaDefinition): ?int
{
$length = $schemaDefinition['options']['length'] ?? null;
$type = $schemaDefinition['type'] ?? null;
return match ($type) {
'string' => $length ?? ClassMetadataBuilder::MAX_VARCHAR_INDEXED_LENGTH,
'text' => $length,
default => null,
};
}
/**
* Get the MySQL database type based on the field type.
*/
public function getSchemaDefinitionNonStatic(string $alias, string $type, bool $isUnique = false, int $length = null): array
{
return self::getSchemaDefinition($alias, $type, $isUnique, $length);
}
}
|