File: config/packages/doctrine.yaml

parameters:
    env(DATABASE_HOST): 'mysql'
    env(DATABASE_PORT): '3306'
    env(DATABASE_NAME): 'api'
    env(DATABASE_USER): 'root'
    env(DATABASE_PASS): 'api'

doctrine:
    dbal:
        driver:   pdo_mysql
        host:     "%env(DATABASE_HOST)%"
        port:     "%env(DATABASE_PORT)%"
        dbname:   "%env(DATABASE_NAME)%"
        user:     "%env(DATABASE_USER)%"
        password: "%env(DATABASE_PASS)%"
        charset:  UTF8
        server_version: 'mariadb-10.4.11'
        types:
          uuid_binary: Ramsey\Uuid\Doctrine\UuidBinaryType
        mapping_types:
          uuid_binary: binary
    orm:
        auto_generate_proxy_classes: '%kernel.debug%'
        entity_managers:
            default:
                naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware
                auto_mapping: true
                second_level_cache:
                    region_cache_driver:
                        type: service
                        id: cache.doctrine.redis
                        pool: 'dl2_'
                    enabled: true
                    regions:
                        locking:
                            lock_path: '%kernel.cache_dir%/doctrine/orm/lock'
                            type: filelock