Skip to main content

Karellen Sqlite Extensions

Project description

Gitter chat

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

karellen-sqlite-0.0.3.tar.gz (4.0 kB view details)

Uploaded Source

Built Distribution

karellen_sqlite-0.0.3-py3-none-any.whl (8.4 kB view details)

Uploaded Python 3

File details

Details for the file karellen-sqlite-0.0.3.tar.gz.

File metadata

File hashes

Hashes for karellen-sqlite-0.0.3.tar.gz
Algorithm Hash digest
SHA256 36cb312b53740af3b1534aa4a472f3ad7a115434b4c1ad2df461ab713dc7f65f
MD5 6a90d53759a6596c09900b6c003ac38a
BLAKE2b-256 31144e414a9e5e316143faf2f729baa59df5b22788a16ca53a67016bad1b180f

See more details on using hashes here.

File details

Details for the file karellen_sqlite-0.0.3-py3-none-any.whl.

File metadata

File hashes

Hashes for karellen_sqlite-0.0.3-py3-none-any.whl
Algorithm Hash digest
SHA256 820032366d3e41204be3a19a6a418df8746bef8e6c8eebc90af328bdc4cf2bf3
MD5 ebcb3de841ebb4aa367cdcd0639bbe30
BLAKE2b-256 592961a858df088f7ad1a529633e929d1685cd96641b654622c35493dd254f72

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page