为SQLAlchemy提供简洁、Python风格的查询语法
项目描述
pythonic_sqlalchemy_query模块为SQLAlchemy提供简洁、Python风格的查询语法。例如，这两个查询产生相同的结果
pythonic_query = session.User['jack'].addresses['jack@google.com']
traditional_query = (
# Ask for the Address...
session.query(Address).
# by querying a User named 'jack'...
select_from(User).filter(User.name == 'jack').
# then joining this to the Address 'jack@google.com`.
join(Address).filter(Address.email_address == 'jack@google.com')安装
pip install pythonic-sqlalchemy-query
与SQLAlchemy一起使用
在大多数情况下
from pythonic_sqlalchemy_query import QueryMakerSession
# Construct an engine as usual.
engine = create_engine(...)
# Create a session aware of this module.
Session = sessionmaker(bind=engine, class_=QueryMakerSession)
session = Session()
# After defining some declarative classes, query away:
for result in session.User['jack'].addresses:
# Do some processing on result...提供示例提供了完整、可工作的代码。
与Flask-SQLAlchemy一起使用
在大多数情况下
from pythonic_sqlalchemy_query.flask import SQLAlchemyPythonicQuery
app = Flask(__name__)
db = SQLAlchemyPythonicQuery(app)
# After defining some declarative classes, query away:
for result in User['jack'].addresses:
# Do some processing on result...提供示例提供了完整、可工作的代码。
文档
许可证
此软件根据MIT许可证条款进行分发。
关闭
pythonic_sqlalchemy_query-1.2.0.tar.gz 的哈希值
| 算法 | 哈希摘要 | |
|---|---|---|
| SHA256 | 6eab85d7f640291a980cc00ee8cdd8aa12dc65b830969a1b684eb2583f475b48 |
|
| MD5 | 52ca94026a6a5df14d86b5ba1b52ac14 |
|
| BLAKE2b-256 | 5450103d56209e89a63e57039a9d5365cec8da74c8b73443c13c5e5d846b3055 |
关闭
pythonic_sqlalchemy_query-1.2.0-py2.py3-none-any.whl 的哈希值
| 算法 | 哈希摘要 | |
|---|---|---|
| SHA256 | cf66f682cc3a5aefbad4a64fc81c4232cc5878c65c198c0f53f417e1f0748df7 |
|
| MD5 | 32e16de6cb3c341b410f5a93d5a8f3a6 |
|
| BLAKE2b-256 | 156cc41559ed69b91013aec86bf5b5b8d64a9c1e7aa09c8703bc76d5cfd2e119 |