Karellen Sqlite Extensions
Project description
About
This project contains Karellen Sqlite extensions to the standard Python SQLite3 module.
These extensions are verified to work with Python 3.x (x >= 3) on Linux x86_64 and have been verified to work with GA and Debug builds of CPython. Any CPython ABI-compliant Python should work as well (YMMV).
SQLite3 Update Hook
The SQLite3 update hook allows the hook to be notified if the database to which the connection is made was changed.
This a drop-in replacement that can be used as demonstrated in the example below. The name pysqlite2 was chosen to the driver to be discovered automatically by Django SQLite backend.
from pysqlite2 import connect
def hook(conn, op, db_name, table_name, rowid):
"""Handle notification here. Do not modify the connection!"""
with connect(":memory:") as conn:
conn.set_update_hook(hook)
conn.execute("CREATE TABLE a (int id);")
conn.execute("INSERT INTO a VALUES (1);")
You can also use this library directly with your Python 3 without renaming:
from sqlite3 import connect
from karellen.sqlite3 import Connection
with connect(":memory:", factory=Connection):
# Do something useful here
pass
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.
Source Distribution
Built Distribution
File details
Details for the file karellen-sqlite-0.0.3.tar.gz
.
File metadata
- Download URL: karellen-sqlite-0.0.3.tar.gz
- Upload date:
- Size: 4.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36cb312b53740af3b1534aa4a472f3ad7a115434b4c1ad2df461ab713dc7f65f |
|
MD5 | 6a90d53759a6596c09900b6c003ac38a |
|
BLAKE2b-256 | 31144e414a9e5e316143faf2f729baa59df5b22788a16ca53a67016bad1b180f |
File details
Details for the file karellen_sqlite-0.0.3-py3-none-any.whl
.
File metadata
- Download URL: karellen_sqlite-0.0.3-py3-none-any.whl
- Upload date:
- Size: 8.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 820032366d3e41204be3a19a6a418df8746bef8e6c8eebc90af328bdc4cf2bf3 |
|
MD5 | ebcb3de841ebb4aa367cdcd0639bbe30 |
|
BLAKE2b-256 | 592961a858df088f7ad1a529633e929d1685cd96641b654622c35493dd254f72 |