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 as
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.
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
FAQs
Context manager for Sqlite databases
We found that sqlite3cm demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Elastic’s return to open source with the AGPL license has been met with skepticism, as many developers see it as a strategic move rather than a genuine effort to restore user trust and freedoms.
Security News
A new "revival hijack" supply chain attack targets deleted Python packages, with an estimated 22K packages at risk. Socket can detect and block hijacked packages that have added malicious code.
Product
We're introducing a new Analytics feature in the Socket dashboard so you can view changes in your organization's and repositories' alerts over time.