.. 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.2.tar.gz
(492.8 kB
view details)
File details
Details for the file 311devs_peewee-2.10.1.2.tar.gz.
File metadata
- Download URL: 311devs_peewee-2.10.1.2.tar.gz
- Upload date:
- Size: 492.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b3c8ba1b97e5ae1e2e4ed1e947840cdb049e3937d8427d6c411482ce815c79db
|
|
| MD5 |
65c398c1307c502e2beb5caf118ae2c1
|
|
| BLAKE2b-256 |
148df17b2dbe9997b0897b3b82e98b3169a13d266d750926679a9a130714a250
|