BETWEEN queries #19

Activity

1. dresende commented on Jan 10, 2013

   

   dresende

   on Jan 10, 2013

   Owner

   More actions

   It's not possible, you need to develop code for now.
2. dresende commented on Jan 10, 2013

   

   dresende

   on Jan 10, 2013

   Owner

   More actions

   I just checked all 3 drivers and the syntax is the same so it is a good addition. I just don't know yet the best syntax for this.
3. dresende commented on Jan 10, 2013

   

   dresende

   on Jan 10, 2013

   Owner

   More actions

   I'm thinking about exposing some "special" functions to create "special" objects to use in conditions.

   Person.find({ age: orm.between(20, 30) }, ....);

   This.between() would return a common object with a non-enumerable function that would tell the sql builder what thing it is.. this could be used for other things:

   Person.find({ age: orm.greater(20) }, ...);
4. Gamaroff commented on Jan 10, 2013

   

   Gamaroff

   on Jan 10, 2013

   CollaboratorAuthor

   More actions

   That sounds great. Very powerful indeed.
5. Gamaroff

   closed this as completedon Jan 10, 2013
6. dresende

   added a commit that references this issue on Jan 10, 2013

   Changes sql SELECT to support special objects in condition values (fixes

   ...

   This issue will close once commit 1ed3dc5 is merged into the 'master' branch.

   1ed3dc5
7. dxg

   added a commit that references this issue on Sep 19, 2017

   Merge pull request #19 from locomote/fix/lm-2855-fix-tests-for-all-dr…

   ...

   e2da459