Como carregar configurações MariaDB do ambiente usando pydantic_settings

Use este código para carregar configurações MySQL/MariaDB de variáveis de ambiente usando a biblioteca pydantic_settings:

mariadb_settings.py

from pydantic_settings import BaseSettings

class MariaDBSettings(BaseSettings):
    hostname: str = "mariadb"
    user: str = "root"
    password: str = "abc123"
    database: str = "mydb"

    class Config:
        env_prefix = 'MARIADB_'

from pydantic_settings import BaseSettings

class MariaDBSettings(BaseSettings):
    hostname: str = "mariadb"
    user: str = "root"
    password: str = "abc123"
    database: str = "mydb"

    class Config:
        env_prefix = 'MARIADB_'

Opcionalmente: se você quiser carregar de um arquivo .env, você pode usar load_dotenv da biblioteca dotenv:

load_dotenv_example.py

# Load environment variables from a .env file if necessary
# This step is optional and only needed if you are using a .env file
from dotenv import load_dotenv
load_dotenv()

# Load environment variables from a .env file if necessary
# This step is optional and only needed if you are using a .env file
from dotenv import load_dotenv
load_dotenv()

Exemplo de uso

mariadb_settings_usage.py

settings = MariaDBSettings()

print("MARIADB_HOSTNAME:", settings.hostname)
print("MARIADB_USER:", settings.user)
print("MARIADB_PASSWORD:", settings.password)
print("MARIADB_DATABASE:", settings.database)

settings = MariaDBSettings()

print("MARIADB_HOSTNAME:", settings.hostname)
print("MARIADB_USER:", settings.user)
print("MARIADB_PASSWORD:", settings.password)
print("MARIADB_DATABASE:", settings.database)

Saída de exemplo:

mariadb_settings_default_output.sh

$ ./mariadb_settings.py
MARIADB_HOSTNAME: mariadb
MARIADB_USER: root
MARIADB_PASSWORD: abc123
MARIADB_DATABASE: mydb

$ ./mariadb_settings.py
MARIADB_HOSTNAME: mariadb
MARIADB_USER: root
MARIADB_PASSWORD: abc123
MARIADB_DATABASE: mydb

mariadb_settings_env_output.sh

$ MARIADB_HOSTNAME=10.1.2.3 ./mariadb_settings.py
MARIADB_HOSTNAME: 10.1.2.3
MARIADB_USER: root
MARIADB_PASSWORD: abc123
MARIADB_DATABASE: mydb

$ MARIADB_HOSTNAME=10.1.2.3 ./mariadb_settings.py
MARIADB_HOSTNAME: 10.1.2.3
MARIADB_USER: root
MARIADB_PASSWORD: abc123
MARIADB_DATABASE: mydb