search

nobrin / macaron

A simple O/R mapper for SQLite
http://nobrin.github.com/macaron/
MIT License
31 stars 8 forks source link

Q object for complexed queries has been introduced #35

Open nobrin opened 9 years ago

nobrin commented 9 years ago

Q object, may likes Django's one, has been introduced. @1fb3f1dc575e4b3ce3dd71198023cd2a774b7cbf It enables this.

members = Member.select(Q(name="Fortune") | Q(group__name="Happiness Charge"))

This will be converted into this SQL.

SELECT "member".* FROM "member"
INNER JOIN "group" AS "member.group" ON "member"."group_id" = "member.group"."id"
WHERE (((("member"."name" = ?) OR ("member.group"."name" = ?))))