01:03.35 | *** join/#storm shaunm (~shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
02:49.59 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
05:04.52 | midgetspy | how can I accomplish this in storm? SELECT * FROM people WHERE age = (SELECT MIN(age) AS min_age FROM people WHERE age > 10) |
05:05.18 | midgetspy | I'd just use SQL except that I need to use date comparison so I have to do that inside python since sqlite stores dates as text |
05:39.46 | *** join/#storm bob2 (rob@unaffiliated/bob2) |
06:27.57 | *** join/#storm jukart (lovely@81.189.156.94) |
07:06.44 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
07:48.32 | jkakar | midgetspy: I think this (untested) is what you want: http://paste.ubuntu.com/414793/ |
07:50.59 | jkakar | I think you can even omit the thirds [Person] argument in the Select constructor... it's been a while since I looked at how Select was compiled, so not 100% sure. |
09:50.13 | *** join/#storm mup (~mup@li37-90.members.linode.com) |
10:13.20 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
11:19.49 | *** join/#storm keppla (~keppla@i577B241C.versanet.de) |
11:54.09 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
12:58.16 | *** join/#storm niemeyer (~niemeyer@189.74.206.84) |
13:06.21 | *** join/#storm bac (~bac@cpe-065-190-186-163.nc.res.rr.com) |
13:06.21 | *** join/#storm bac (~bac@canonical/launchpad/bac) |
13:57.28 | *** join/#storm elmom_ (~elmom@YZKMMMCDLV.gprs.sl-laajakaista.fi) |
16:24.31 | *** join/#storm keppla1 (~keppla@i577B24E6.versanet.de) |
17:17.41 | *** join/#storm jukart (~jukart@d86-32-163-62.cust.tele2.at) |
19:35.16 | *** join/#storm cody-somerville (~cody-some@ubuntu/member/somerville32) |
20:23.16 | *** join/#storm bac (~bac@cpe-065-190-186-163.nc.res.rr.com) |
20:23.17 | *** join/#storm bac (~bac@canonical/launchpad/bac) |
21:03.41 | *** join/#storm bac (~bac@cpe-065-190-186-163.nc.res.rr.com) |
21:03.41 | *** join/#storm bac (~bac@canonical/launchpad/bac) |
21:46.34 | *** join/#storm rockstar (~rockstar@blackout.eventuallyanyway.com) |
21:46.46 | *** join/#storm rockstar (~rockstar@canonical/launchpad/rockstar) |
21:49.27 | *** join/#storm yosafbridge (~yosafbrid@li14-39.members.linode.com) |
23:57.35 | *** join/#storm infobot (ibot@rikers.org) |
23:57.36 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.16 released! || Review branches: https://code.launchpad.net/storm/+activereviews || IRC logs: http://ibot.rikers.org/#storm/ || API documentation: http://people.canonical.com/~jkakar/storm/ |