# Database Configuration
{% if database_type == "postgres" %}
# PostgreSQL Connection
DATABASE_URL=postgresql://username:password@localhost:5432/{{ name }}_dev
# Connection Pool Settings
DATABASE_MAX_CONNECTIONS=10
DATABASE_MIN_CONNECTIONS=1
DATABASE_CONNECT_TIMEOUT=30
DATABASE_IDLE_TIMEOUT=600
DATABASE_MAX_LIFETIME=1800
# PostgreSQL specific
POSTGRES_USER=username
POSTGRES_PASSWORD=password
POSTGRES_DB={{ name }}_dev
{% elif database_type == "mysql" %}
# MySQL Connection
DATABASE_URL=mysql://username:password@localhost:3306/{{ name }}_dev
# Connection Pool Settings
DATABASE_MAX_CONNECTIONS=10
DATABASE_MIN_CONNECTIONS=1
DATABASE_CONNECT_TIMEOUT=30
DATABASE_IDLE_TIMEOUT=600
DATABASE_MAX_LIFETIME=1800
# MySQL specific
MYSQL_ROOT_PASSWORD=rootpassword
MYSQL_DATABASE={{ name }}_dev
MYSQL_USER=username
MYSQL_PASSWORD=password
{% elif database_type == "sqlite" %}
# SQLite Connection
DATABASE_URL=sqlite://{{ name }}.db
# Connection Pool Settings (less relevant for SQLite)
DATABASE_MAX_CONNECTIONS=1
DATABASE_CONNECT_TIMEOUT=30
{% else %}
# Database Connection (default PostgreSQL)
DATABASE_URL=postgresql://username:password@localhost:5432/{{ name }}_dev
# Connection Pool Settings
DATABASE_MAX_CONNECTIONS=10
DATABASE_MIN_CONNECTIONS=1
DATABASE_CONNECT_TIMEOUT=30
DATABASE_IDLE_TIMEOUT=600
DATABASE_MAX_LIFETIME=1800
{% endif %}
# Test Database (for running tests)
{% if database_type == "postgres" %}
TEST_DATABASE_URL=postgresql://username:password@localhost:5432/{{ name }}_test
{% elif database_type == "mysql" %}
TEST_DATABASE_URL=mysql://username:password@localhost:3306/{{ name }}_test
{% elif database_type == "sqlite" %}
TEST_DATABASE_URL=sqlite::memory:
{% else %}
TEST_DATABASE_URL=postgresql://username:password@localhost:5432/{{ name }}_test
{% endif %}