The DataBase Context Manager library from Head First Python, 2nd edition.
Project description
DBcm
The Database Context Manager from the 2nd Edition of Head First Python.
Install
You can easily install DBcm into your local Python with this command:
pip install DBcm
Note: there is no conda install
option at this time.
How to use
The UseDatabase
context manager for working with MySQL/MariaDB.
For more information, see Chapters 7, 8, 9, and 11 of the 2nd edition of Head First Python.
Assumptions: you've installed either MySQL or MariaDB, created a database, granted a user full access to the database, and (optionally) created one of more tables within the database.
Begin by importing what you need from DBcm:
from DBcm import UseDatabase, SQLError
Then create a dictionary which provides your DB credentials data (substituting the relevant values as required):
config = { 'host': '127.0.0.1',
'user': 'useridhere',
'password': 'passwordhere',
'database': 'dbnamehere',
}
Use the config
dictionary together with the UseDatabase
context manager to interact with your database tables. Note: there's an assumption that you already know/understand some basic SQL here:
with UseDatabase(config) as cursor:
try:
_SQL = "select * from log"
cursor.execute(_SQL)
data = cursor.fetchall()
except SQLError as err:
print('Your query broke:', str(err)
The result of the query is in the data
variable.
Enjoy, and have fun. (Sorry: Python 3 only, due to type hints and new Exception syntax).
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.