Configuration

Environment variables

Variable	Description	Default
`DB_TYPE`	Database type: `sqlite`, `postgres`, `mysql`, `sqlserver`, `oracle`	Required
`DB_HOST`	Database host	`None`
`DB_USER`	Database user	`None`
`DB_PASSWORD`	Database password	`None`
`DB_NAME`	Database name or SQLite file path	Required
`DB_DRIVER`	ODBC driver name (SQL Server only)	`None`
`DB_PORT`	Database port	Driver default
`ORACLE_SID`	Oracle SID	`None`
`ORACLE_DB_PORT`	Oracle port	`1521`

All environment variables can be overridden by passing parameters directly:

db = SQLPyHelper(
    db_type="postgres",
    host="localhost",
    user="myuser",
    password="mypassword",
    database="mydb",
    port="5432",
)