Table columns are not read when using MariaDB and an enum field about resource-generator HOT 3 CLOSED

Hello @florentpoujol I think doctrine is not working with MariaDB, we only test it with mysql.

I think working only with mysql, i try to check soon :)

from resource-generator.

Hey ! Thanks for your anwser

But I apologize, I haven't properly investigated before opening the ticket.

The tool actually works for most tables, even with MariaDB.

It does not however when the table contain an enum type, because Doctrine thinks that MariaDB does'nt support it and throws the following exception from ResourceGeneratorService::getColumnType().
(MariaDB 10.3.7 definitely supports enums)

Unknown database type enum requested, Doctrine\DBAL\Platforms\MariaDb1027Platform may not support it. at /myapp/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:479)

Putting a quick try/catch in this method and returning 'enum' when catching DBALExceptions seems to work, I can access the table with all the fields but all the fields types are either 'text' or 'relation' (no 'integer' or 'datetime' even when the fields were recognized of that type)...

I already outgrown the need for the generator, so I won't bother doing more.
I will just close the issue and update the title/first post.

Tanks for your time.

from resource-generator.

@florentpoujol perfect ! so enjoy it :)

from resource-generator.