FEATURE | Ordered multiple select from list.

v1a0 / sqllex

The most pythonic ORM (for SQLite and PostgreSQL). Seriously, try it out!

https://v1a0.github.io/sqllex

GNU General Public License v3.0

92 stars 8 forks source link

Closed swayll closed 3 years ago

swayll commented 3 years ago

In v1 for multiple select rows by id from list of ids the command is:

list = [1,2,3,4,5...]
table.select(WHERE=['id', *list], ORDER_BY="published DESC")

In v2 not a feature for this. Please add multiple select from list with order.

swayll commented 3 years ago

Sorry, solution is found.

list = [1,2,3,4,5...]
table.find(id=list)

v1a0 commented 3 years ago

Hey @swayll👋 Sorry I was really busy last week... And I'm really happy to see you found solution by yourself!

I Invite you to join our telegram group, our community members can answer at anytime for any your questions. Good luck and have a nice week!