Context manager for Sqlite databases
SQLITE 3 CM is a context manager,
A way TO USE
with statement on sqlite databases !! (WITHOUT CLOSING OR OPENING ANYTING 🤩)
pip install sqlite3cm
from sqlite3cm import OpenSqlite3db with OpenSqlite3db("database.db", throw_error=True) as (conn, cursor): conn.execute('CREATE TABLE IF NOT EXISTS users')
You shouldn't forget about the parentisis after the
db_path Path to the database (can be
Pathlib path) (default to "database.db")
throw_error Weather you want to throw an error or not (default to True)
None of these arguments are required.
THE SCRIPT IS ONLY 20 LINES LONG 😄 (50 with docstrings and comments)
At the beggining, the script will connect to the database and create a cursor
At the end, the script will commit, close the connection and cursor
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for sqlite3cm-0.0.3-py3-none-any.whl