I added an ENUM
property to an entity in a Symfony 5 based project:
MyEntity
/**
* @var string
*
* @ORM\Column(type="string", columnDefinition="ENUM('foo', 'bar', 'buz')", options={"comment": "Lorem ipsum...."})
*/
private $myEnum = 'foo';
config.yaml
doctrine:
dbal:
driver: pdo_mysql
server_version: 5.7
host: '%database_host%'
port: '%database_port%'
dbname: '%database_name%'
user: '%database_user%'
password: '%database_password%'
charset: UTF8
mapping_types:
enum: string
It works fine. But the PHPUnit tests run against SQLite. As result, I'm getting errors like this one:
Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'CREATE TABLE my_table (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ... my_enum ENUM('foo', 'bar', 'buz'), ...)':
SQLSTATE[HY000]: General error: 1 near "'foo'": syntax error
Is it possible / How to get the combination ENUM
type + Doctrine + SQLite working? (At least in this case, for PHPUnit within a Symfony project)