| 00:00.15 | *** join/#storm wallflower (n=wallflow@ip-205-246-113-216.pool.grokthis.net) |
| 01:35.41 | *** join/#storm lymxz (n=lymxz@123.116.113.230) |
| 01:43.52 | jkakar | >>> subselect = Select(CompanyAccountant.accountant_id, distinct=True) |
| 01:43.52 | jkakar | >>> result = store.find(Accountant, Not(Accountant.id.is_in(subselect))) |
| 01:44.32 | jkakar | jml: ^^ That's one way to do it. I think you could do it without the subselect using a RightJoin but SQLite (or pysqlite) doesn't support RIGHT JOIN so I couldn't actually test it easily. |
| 01:45.40 | jml | jkakar: thanks. |
| 01:45.45 | jkakar | jml: np. |
| 01:47.50 | jml | jkakar: I'm using sqlite, so I guess I'll stick with the subselect |
| 01:48.08 | jkakar | jml: Yeah, makes sense. |
| 01:48.36 | jkakar | jml: It's a little easier to read than having to remember how a RIGHT JOIN works. :) I wonder what the performance difference is though. |
| 01:48.50 | *** join/#storm weatherman (n=weatherm@204-174-36-245.unknown-dhcp802.dsl.ucc-net.ca) |
| 01:48.50 | weatherman | storm/sub-select-tutorial r202 committed by jkakar@kakar.ca |
| 01:48.50 | weatherman | - Fixed test failure related to ordering. |
| 01:48.50 | weatherman | - Added section about sub-selects to the tutorial. |
| 01:51.30 | jml | jkakar: heh :) |
| 01:52.57 | weatherman | storm/sub-select-tutorial r203 committed by jkakar@kakar.ca |
| 01:52.57 | weatherman | - Added storm.expr.Not to storm.locals. |
| 01:52.57 | weatherman | - Removed explicit import from tutorial. |
| 02:42.55 | *** join/#storm licorna (n=rvalin@201.241.28.169) |
| 06:37.01 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 07:19.08 | *** join/#storm jukart (n=jukart@lsfw01.lovelysystems.com) |
| 07:20.08 | *** join/#storm jukart_ (n=jukart@194.183.146.181) |
| 07:22.06 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 08:35.07 | *** join/#storm dobee (n=dobeee@lsfw01.lovelysystems.com) |
| 08:37.37 | *** join/#storm dobee_ (n=dobeee@194.183.146.186) |
| 13:24.52 | *** join/#storm drews1 (n=jcd@kontor.netgroupprocessing.dk) |
| 13:43.31 | *** join/#storm oubiwann (n=oubiwann@209-181-152-131.omah.qwest.net) |
| 14:32.45 | *** join/#storm Zenom (n=Zenom@unaffiliated/aj1973) |
| 16:06.04 | *** part/#storm drews1 (n=jcd@kontor.netgroupprocessing.dk) |
| 17:19.12 | *** join/#storm niemeyer (n=niemeyer@201.23.160.3) |
| 17:48.23 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 18:06.07 | *** join/#storm dobee (n=dobeee@81-223-53-162.dornbirn.xdsl-line.inode.at) |
| 18:17.27 | *** join/#storm dobee (n=dobeee@81-223-53-162.dornbirn.xdsl-line.inode.at) |
| 18:22.46 | weatherman | storm/trunk r202 committed by radix@twistedmatrix.com |
| 18:22.46 | weatherman | fix obviously screwed up statement ordering in the tutorial. makes tutorial pass again. [trivial] |
| 18:36.58 | *** join/#storm oubiwann (n=oubiwann@209-181-152-131.omah.qwest.net) |
| 18:49.32 | *** join/#storm dobee (n=dobeee@81-223-53-162.dornbirn.xdsl-line.inode.at) |
| 20:37.22 | *** join/#storm bac (n=bac@cpe-065-190-191-245.nc.res.rr.com) |
| 20:59.39 | *** join/#storm bac (n=bac@cpe-065-190-191-245.nc.res.rr.com) |
| 21:18.58 | radix | this cache inconsistency bug is a real PITA |
| 22:23.10 | *** join/#storm jml (n=jml@li2-200.members.linode.com) |
| 22:26.14 | *** join/#storm jml_ (n=jml@ppp121-44-220-202.lns1.hba1.internode.on.net) |
| 23:00.23 | *** join/#storm Anon366 (n=Frank@pool-71-126-176-102.washdc.fios.verizon.net) |
| 23:01.03 | *** part/#storm Anon366 (n=Frank@pool-71-126-176-102.washdc.fios.verizon.net) |