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.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 28f70983141ab60f73ce6ba1e3ec548d6522769b6122a0a9ea4c96bc970dc649 |
|
MD5 | 86d01889f5b4f6232cd990f624d2e4e8 |
|
BLAKE2b-256 | eb64e07a74400c9144f7468a20f69a587234aa6d00ddee6104936b1a444a6047 |