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 hashes)

Uploaded Source

Built Distribution

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

Uploaded Python 3

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