Entity generation for a single table

Question

So, I want to generate entities for certain tables in a database with a huge number of tables.

Here is my command:

php app/console doctrine:mapping:convert yml ./src/MyNamespace/Bundle/MyNamespaceBundle/Resources/config/doctrine/metadata/orm --from-database --em=my_manager --filter=TblReports --verbose 

Here is the error:

 [Doctrine\DBAL\DBALException] Unknown database type unknown requested, Doctrine\DBAL\Platforms\PostgreSqlPlatform may not support it. 

Now I can run this command in a smaller database with only a few tables, and it works fine, so it should be a database.

Yes, I want to filter this table:

 --filter=TblReports 

If I remove the filter, it generates entities for the entire database, which I do not want.

I am running PostgreSQL 8.4 and 9.1 if that matters.

Does anyone else or know how to fix this problem?

 Unknown database type unknown requested 

Doctrine docs

• http://docs.doctrine-project.org/projects/doctrine-orm/en/2.1/reference/tools.html#reverse-engineering

Related:

• Creating a single object from an existing database using symfony2 and the doctrine

UPDATE: adding my_manager (config.yml)

 # Doctrine Configuration doctrine: dbal: default_connection: my_database connections: my_database: driver: pdo_pgsql port: 5432 dbname: tbl_reports user: foo_user password: foo_pass charset: UTF8 mapping_types: bit: string orm: auto_generate_proxy_classes: "%kernel.debug%" default_entity_manager: my_manager entity_managers: my_manager: connection: my_database mappings: MyNamespaceBundle: mapping: true dir: Entity/Reports 

in config_dev.yml (I use dev and prod yml files to manage hosts that I can connect to)

 # Doctrine Configuration doctrine: dbal: connections: my_database: host: 172.0.0.1 

Answer 1

I agree with Ziumin that this is probably a data type problem in your Postgres database. Perhaps Enum or similar.

I would try to convert the tables one by one until you narrow it down to a problem table, and then look at the data types, and this should be pretty obvious.