.. image:: http://media.charlesleifer.com/blog/photos/p1423749536.32.png
peewee
======
This is just `peewee-2.10.1 <https://github.com/coleifer/peewee>` with some changes we need:
* Simple LEFT JOIN LATERAL. No need make subquery, just join to model.
.. code-block:: python
# make some compound select query
subq = ModelB.select(ModelB.id).where(ModelB.id > ModelA.id).limit(1)
# make query lateral joining subquery
ModelA.select(ModelA, subq.c.id).join(subq, join_type=JOIN.LATERAL)
peewee
======
This is just `peewee-2.10.1 <https://github.com/coleifer/peewee>` with some changes we need:
* Simple LEFT JOIN LATERAL. No need make subquery, just join to model.
.. code-block:: python
# make some compound select query
subq = ModelB.select(ModelB.id).where(ModelB.id > ModelA.id).limit(1)
# make query lateral joining subquery
ModelA.select(ModelA, subq.c.id).join(subq, join_type=JOIN.LATERAL)
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
311devs_peewee-2.10.1.3.tar.gz
(492.9 kB
view details)
File details
Details for the file 311devs_peewee-2.10.1.3.tar.gz.
File metadata
- Download URL: 311devs_peewee-2.10.1.3.tar.gz
- Upload date:
- Size: 492.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2c2e2748bd8865e66ac596eb0b89d58a847c53120d1cd751f7c023634de93c36
|
|
| MD5 |
8e2907ae3c222fd1dc1a54f47085dc88
|
|
| BLAKE2b-256 |
810a97f3176dbd2629080ea42d7702d046d2e43648ee01b2e6fbd2ddba87a1c5
|