Type Hint SQL Query Builder for Python.
Project description
Type Safed SQL Query Builder for Python
Development Notes
DDL
There are no plans for support.
DDL is often used infrequently as its syntax varies from database to database. It is recommended that it be managed by a separate migration tool.
For Table Relation
If a PrimaryKey or a join key is included as a constraint, it can be expressed as a NewType to match the condition.
Examples
from textwrap import dedent
from tipsql.core.query.builder import QueryBuilder
from your_project.database.public import User, Address
builder = (
query.chain()
.from_(
lambda c: c(User)
.left_outer_join(
Address,
)
.on(
lambda c: c(User.id == Address.user_id)
.and_(Address.city == "Tokyo")
)
)
.select(
User.id,
User.name,
)
)
assert (
builder.build()
== dedent(
"""
SELECT
users.id,
users.name
FROM
users
LEFT OUTER JOIN
addresses
ON
users.id = addresses.user_id
AND addresses.city = 'Tokyo';
"""
).strip()
)
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
tipsql-0.0.13.tar.gz
(2.0 kB
view hashes)