SQLAlchemy dialect for the sqlean.py SQLite wrapper
Project description
sqlean-driver
A SQLAlchemy driver for sqlean.py
.
Table of Contents
Installation
pip install sqlean-driver
Usage
from sqlalchemy import create_engine, func, select
engine = create_engine("sqlite+sqlean:///:memory:?extensions=all")
with engine.connect() as conn:
result = conn.execute(select(func.ipfamily("192.168.1.1")))
print(result.scalar()) # 4
Extensions
By default, sqlean.py
disables all SQLite extensions. To enable all of them, pass extensions=all
as a query parameter to the connection string. Or use a comma-separated list of extensions to enable only some of them, e.g. extensions=ipaddr,crypto
.
Alternatives
Note that you don't strictly need this driver to use sqlean.py
with SQLAlchemy. You can supply sqlean
as the module
parameter to create_engine
:
import sqlean
from sqlalchemy import create_engine, func, select
sqlean.extensions.enable_all()
engine = create_engine("sqlite:///:memory:", module=sqlean)
with engine.connect() as conn:
result = conn.execute(select(func.ipfamily("192.168.1.1")))
print(result.scalar()) # 4
Development
This project uses Hatch to manage the development environment, so make sure you have it installed.
Run tests and coverage
hatch run cov
Run linter
hatch run lint:style
Run type checker
hatch run typing:check
License
sqlean-driver
is distributed under the terms of the MIT license.
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
Hashes for sqlean_driver-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c25cbe348c97914372deb94676810f729db4ec93e05e4a071ba86b24cb2a797c |
|
MD5 | 1185ce1e62edb5528c23bea32885965c |
|
BLAKE2b-256 | 1897bd5104464fef4e587ab6ef2a8b8fb67282669087dfb62a5be98389cbfa26 |