Skip to main content

Head First Python's Database Context Manager

Project description

The DBcm.UseDatabase context manager for working with MySQL/MariaDB and SQLite3.

The 1.x release of this module was based on code created for the second edition of Head First Python. See chapters 7, 8, 9, and 11 of the that book for information on how this module was created.

To install the second edition release, please use: pip install DBcm=1.7.4

For the third edition of Head First Python, DBcm moved to release 2. The option to use SQLite3 is now supported in this new release.

Simple example usage (for a MySQL/MariaDB backend):

from DBcm import UseDatabase, SQLError

config = { "host": "127.0.0.1",
           "user": "myUserid",
           "password": "myPassword",
           "database": "myDB" }

with UseDatabase(config) as cursor:
    try:
        _SQL = "select * from log"
        cursor.execute(_SQL)
        data = cursor.fetchall()
    except SQLError as err:
        print("Your query caused an issue:", str(err))

If a filename (string) is used in place of a config dictionary when using DBcm.UseDataBase, the data is assumed to reside in a local SQLite file (which gets created if it doesn't previously exist).

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbcm-2.1.tar.gz (2.9 kB view hashes)

Uploaded Source

Built Distribution

dbcm-2.1-py3-none-any.whl (4.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page