Jinja Templates to SQL
Project description
Jinja2SQL (Jinja To SQL)
Jinja2SQL
is a simple and efficient library for generating SQL queries from Jinja2 templates. It is type-friendly and offers async
support, drawing significant inspiration from the excellent library at jinjasql.
Documentation
http://jinja2sql.readthedocs.io/
Requirements
Python 3.8+
and Jinja2 3.1.2+
.
Installation
Install using pip
:
pip install jinja2sql
or using poetry
:
poetry add jinja2sql
Quick Example
from jinja2sql import Jinja2SQL
j2sql = Jinja2SQL(param_style="named")
query, params = j2sql.from_string(
"SELECT * FROM {{ table | identifier }} WHERE email = {{ email }}",
context={"table": "users", "email": "user@mail.com"},
)
assert query == "SELECT * FROM users WHERE email = :email"
assert params == {"email": "user@mail.com"}
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
jinja2sql-0.1.0.tar.gz
(6.2 kB
view hashes)
Built Distribution
Close
Hashes for jinja2sql-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87d1b078dcafce4a0d1aeddbbbf4583923b7bee975a56b7ba7b970168bf5ac91 |
|
MD5 | dda6874aa2cff9e29754ec2ee3f12c74 |
|
BLAKE2b-256 | fc961e8ae844fb5acb814731c3ed61bc20757ceaa9e89b9cecdae0197ac59190 |