SQLITE3 CM

SQLITE 3 CM is a context manager, 😃 A way TO USE with statement on sqlite databases !! (WITHOUT CLOSING OR OPENING ANYTING 🤩)

Install 📦

pip install sqlite3cm

Docs 📄

from sqlite3cm import OpenSqlite3db

with OpenSqlite3db("database.db", throw_error=True) as (conn, cursor):
    conn.execute('CREATE TABLE IF NOT EXISTS users')

Note:

You shouldn't forget about the parentisis after the as

Arguments

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)

Note:

None of these arguments are required.

Lightness 🕊

THE SCRIPT IS ONLY 20 LINES LONG 😄 (50 with docstrings and comments)

Features 🧪

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