sova-bootstrap
93 lines
3.2 KiB
YAML
93 lines
3.2 KiB
YAML
doctrine:
|
|
dbal:
|
|
connections:
|
|
default: # PostgreSQL
|
|
schema_filter: ~^(?!cron)~
|
|
url: '%env(resolve:DATABASE_URL)%'
|
|
logging: true
|
|
profiling: true
|
|
profiling_collect_backtrace: '%kernel.debug%'
|
|
use_savepoints: true
|
|
|
|
mysql: # Bitrix MySQL
|
|
url: '%env(resolve:DATABASE_BITRIX_URL)%'
|
|
driver: pdo_mysql
|
|
logging: true
|
|
profiling: true
|
|
|
|
cabinet: # Cabinet PostgreSQL
|
|
url: '%env(resolve:DATABASE_CABINET_URL)%'
|
|
logging: true
|
|
profiling: true
|
|
orm:
|
|
dql:
|
|
string_functions:
|
|
JSONB_CONTAINS: Scienta\DoctrineJsonFunctions\Query\AST\Functions\Postgresql\JsonbContains
|
|
JSON_CONTAINS: Scienta\DoctrineJsonFunctions\Query\AST\Functions\Postgresql\JsonContains
|
|
JSONB_EXISTS: Scienta\DoctrineJsonFunctions\Query\AST\Functions\Postgresql\JsonbExists
|
|
JSONB_EXISTS_ANY: Scienta\DoctrineJsonFunctions\Query\AST\Functions\Postgresql\JsonbExistsAny
|
|
JSONB_EXISTS_ALL: Scienta\DoctrineJsonFunctions\Query\AST\Functions\Postgresql\JsonbExistsAll
|
|
auto_generate_proxy_classes: false
|
|
metadata_cache_driver:
|
|
type: pool
|
|
pool: doctrine.system_cache_pool
|
|
query_cache_driver:
|
|
type: pool
|
|
pool: doctrine.system_cache_pool
|
|
result_cache_driver:
|
|
type: pool
|
|
pool: doctrine.result_cache_pool
|
|
enable_lazy_ghost_objects: true
|
|
report_fields_where_declared: true
|
|
validate_xml_mapping: true
|
|
naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware
|
|
identity_generation_preferences:
|
|
Doctrine\DBAL\Platforms\PostgreSQLPlatform: identity
|
|
auto_mapping: true
|
|
mappings:
|
|
App:
|
|
type: attribute
|
|
is_bundle: false
|
|
dir: '%kernel.project_dir%/src/Entity'
|
|
prefix: 'App\Entity'
|
|
alias: App
|
|
controller_resolver:
|
|
auto_mapping: false
|
|
|
|
when@dev:
|
|
doctrine:
|
|
orm:
|
|
# In dev, avoid Redis-backed metadata/query cache: stale ClassMetadata (e.g. removed fields) breaks warmup.
|
|
metadata_cache_driver:
|
|
type: pool
|
|
pool: cache.system
|
|
query_cache_driver:
|
|
type: pool
|
|
pool: cache.system
|
|
|
|
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
|