acdc.database.connect_db.load_connection

load_connection(dbname, echo=False)[source]

Return session, base, and engine objects for connecting to the database.

Parameters:

  • dbsettings (dict) – Dictionary listing database type and all required connection parameters. Params will get plugged into the full connection string of form: dialect+driver://username:password@host:port/database

  • echo (Bool) – If True, log all statements to STDOUT. Defaults to False.

Returns:

  • session (Session() instance) – Provides a holding zone for all objects loaded or associated with the database.

  • engine (engine object) – Provides a source of database connectivity and behavior.