Release 3 of DBcm
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 originally created. The 2.x and 3.x releases were updated during the writing of the third edition of the book.
Installation Notes
To install the second edition release of DBcm, please use:
pip install --upgrade DBcm==1.7.4
To install DBcm for use with a MySQL server (for example, on PythonAnywhere), please use:
pip install --upgrade DBcm==2.1
Note: on the PythonAnywhere command-line, prefix the above "pip" command with "python3 -m ".
The 3.x release (the default install target) specifically works with the MariaDB server (for compatibility reasons).
The Latest (and Greatest) DBcm
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. Release 3 of DBcm removes the dependancy on mysql.connector and replaces it with (the more up-to-date) mariadb library (but do consider the Installation Notes, above).
Using DBcm
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).
1 maintainer
Metadata
1 maintainer
Release files for DBcm 3.0.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbcm-3.0.5.tar.gz | 3.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbcm-3.0.5-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 7.9 kB
Release files / dbcm-3.0.5.tar.gz
| Download URL | dbcm-3.0.5.tar.gz |
|---|---|
| Size | 3.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
97cef0f72b98be742fe9f2b9d69e6d09784023626f65fbda6b73fcaeaf90bac3
|
|
BLAKE2b-256 checksum How to use checksums |
b7756dfebcdac4bb535dd4e075d0b7f46175bca96cb992dbcbd0ce6677b5b0c5
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.13.0
|
Release files / dbcm-3.0.5-py3-none-any.whl
| Download URL | dbcm-3.0.5-py3-none-any.whl |
|---|---|
| Size | 4.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
00f8f9a8e810df33142cf8343b0739240f2b101f0090b60dcafd8e4f38829035
|
|
BLAKE2b-256 checksum How to use checksums |
d647c4a15228d098a72c07a8f95573ae29e83262ccfe5bb7254b69294a3b0c3a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.1 CPython/3.13.0
|
