# Minimal settings (replace placeholders)
username = "your_user"
password = "your_password"
dsn = "your_dsn" 
wallet_path = "/path/to/your/oracle/wallet"
instant_client_path = "/path/to/your/instantclient"


if __name__ == "__main__":
    # Initialize Oracle client (thick mode)
    print("Initializing Oracle Client...")
    oracledb.init_oracle_client(lib_dir=instant_client_path, config_dir=wallet_path)

    # Attempt creating a connection pool (crashes here on Python 3.13)
    print("Creating Oracle connection pool...")
    pool = oracledb.create_pool(
        user=username,
        password=password,
        config_dir=wallet_path,
        dsn=dsn,
        wallet_location=wallet_path,
        wallet_password="",
        min=1,
        max=2,
        increment=1,
    )

    print("Acquiring connection from pool...")
    with pool.acquire() as connection:
        print("Oracle DB version:", connection.version)

    print("Test completed successfully (if no crash).")

@asynccontextmanager
async def lifespan(app: FastAPI):
    # Create the connection pool
    app.state.pool = create_db_connection_pool()
    yield
    # Close the connection pool on shutdown
    app.state.pool.close()
    logger.debug("Closed Oracle database connection pool.")

if os.getenv("ENV_FOR_DYNACONF") != "test":
    # noinspection PyUnresolvedReferences
    oracledb.init_oracle_client(
        lib_dir=settings.db.instant_client_library, config_dir=wallet_path
    )


def create_db_connection_pool() -> oracledb.ConnectionPool:
    logger.debug("Creating Oracle database connection pool...")
    pool = oracledb.create_pool(
        user=username,
        password=password,
        config_dir=wallet_path,
        dsn=dsn,
        wallet_location=wallet_path,
        wallet_password="",
        min=1,  # Minimum number of connections in the pool
        max=5,  # Maximum number of connections in the pool
        increment=1,  # Number of connections to add when more are needed
    )
    logger.debug("Created Oracle database connection pool.")
    return cast("oracledb.ConnectionPool", pool)