Here is my config :
doctrine:
dbal:
default_connection: default
connections:
default:
url: '%env(resolve:DATABASE_URL)%'
sqlite:
driver: 'pdo_sqlite'
path: '%kernel.project_dir%/src/data.db'
orm:
auto_generate_proxy_classes: true
enable_lazy_ghost_objects: true
default_entity_manager: default
entity_managers:
default:
connection: default
naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware
auto_mapping: true
mappings:
App:
is_bundle: false
type: annotation
dir: '%kernel.project_dir%/src/Entity'
prefix: 'App\Entity'
alias: App
sqlite:
connection: sqlite
mappings:
SQLite:
is_bundle: false
type: annotation
dir: /application/src/EntitySqlLite
prefix: App\Entity\EntitySqlLite
mapping: true
when@test:
doctrine:
dbal:
# "TEST_TOKEN" is typically set by ParaTest
dbname_suffix: '_test%env(default::TEST_TOKEN)%'
when@prod:
doctrine:
orm:
auto_generate_proxy_classes: false
proxy_dir: '%kernel.build_dir%/doctrine/orm/Proxies'
query_cache_driver:
type: pool
pool: doctrine.system_cache_pool
result_cache_driver:
type: pool
pool: doctrine.result_cache_pool
framework:
cache:
pools:
doctrine.result_cache_pool:
adapter: cache.app
doctrine.system_cache_pool:
adapter: cache.system
I have entites :
itbcode@2dc31f2b7529:/application$ php bin/console doctrine:schema:update --dump-sql --em=sqlite
[OK] No Metadata Classes to process.
itbcode@2dc31f2b7529:/application$ ls -la src/EntitySqlLite/
total 16
drwxrwxr-x 2 itbcode itbcode 4096 Oct 6 10:54 .
drwxrwxr-x 16 itbcode itbcode 4096 Oct 6 11:00 ..
-rw-rw-r-- 1 itbcode itbcode 739 Oct 6 10:47 ItbHelp.php
-rw-rw-r-- 1 itbcode itbcode 254 Oct 6 10:54 Test.php
ItbHelp :
<?php
namespace App\EntitySqlLite;
use Doctrine\ORM\Mapping as ORM;
/**
* @ORM\Entity()
*/
class ItbHelp
{
/**
* @ORM\Id()
* @ORM\Column(type="integer")
* @ORM\GeneratedValue(strategy="AUTO")
*/
protected ?int $id = null;