| 01:18.24 | philiKON | so i'm playing with storm on the interpreter prompt |
| 01:18.31 | philiKON | but i'm running into a very basic problem it seems |
| 01:18.37 | philiKON | http://pastebin.ubuntu.com/333543/ |
| 01:18.41 | philiKON | see the last line |
| 01:19.00 | philiKON | i'm obviously missing somethign essential but i can't figure out what it is |
| 01:22.26 | philiKON | hmm, when i don't use connection.execute() but store.execute() it works |
| 01:22.51 | philiKON | is confused |
| 01:24.34 | jkakar | philiKON: Hi |
| 01:24.43 | jkakar | philiKON: You're not really meant to use the connection directly like that. |
| 01:24.49 | philiKON | ok |
| 01:24.51 | jkakar | philiKON: By doing that, you're bypassing the store entirely. |
| 01:24.57 | philiKON | i saw this in the unit tests somewhere |
| 01:25.00 | jkakar | philiKON: So it doesn't have any knowledge of anything to flush |
| 01:25.04 | jkakar | philiKON: Ah, I see. |
| 01:25.27 | philiKON | good to know |
| 01:25.35 | philiKON | i'll just use the store then |
| 01:25.41 | philiKON | store.execute() works nicely |
| 01:26.21 | jkakar | philiKON: Untested, but this should work: http://pastebin.ubuntu.com/333546/ |
| 01:26.44 | philiKON | it does |
| 01:26.48 | philiKON | even without the commits |
| 01:27.10 | jkakar | Right, as I'd expect. |
| 01:27.13 | philiKON | yup |
| 01:27.14 | philiKON | cheers |
| 01:27.22 | jkakar | The store will generally auto-flush for you, which results in that behaviour. |
| 01:27.55 | philiKON | so it doesn't see the tables b/c they were created in a different transaction? |
| 01:28.01 | philiKON | is that the reason for the error? |
| 01:29.14 | jkakar | philiKON: That's a good question, I'm not sure. |
| 01:29.23 | philiKON | well, doesn't matter really |
| 01:29.26 | philiKON | was just curious |
| 01:29.27 | philiKON | :) |
| 01:29.49 | jkakar | philiKON: I'd expect that part of it to work actually... so I'm confused, too. :) |
| 01:30.01 | jkakar | philiKON: Also, SQLite is *weird*. :) |
| 01:30.10 | philiKON | well, from what i saw in the unittests, i thought it would |
| 01:30.17 | philiKON | heh |
| 01:30.22 | jkakar | philiKON: For example, you can run CREATE TABLE and then rollback and the tables will still be there. |
| 01:30.29 | philiKON | weird |
| 01:30.34 | jkakar | Exactly! ;) |
| 01:30.38 | philiKON | :) |
| 01:30.44 | philiKON | but it's fast and simple |
| 01:30.52 | philiKON | and bundled with python |
| 01:30.55 | jkakar | Indeed. It's great for the tasks it's meant to be used for. |
| 01:31.13 | philiKON | yup |
| 01:31.18 | jkakar | I like it a lot, but have learned to have somewhat different expectations from it, and I think right so, than say PostgreSQL. |
| 01:31.48 | jkakar | philiKON: I'm off for the day. Have fun hacking on Storm! :) |
| 01:31.50 | philiKON | this is my first real project with it. i hope it (and storm) is fast enough to be used synchronously in a twisted app |
| 01:32.00 | philiKON | k, have a good night |
| 01:33.04 | jkakar | philiKON: Ah, interesting. |
| 01:33.13 | jkakar | philiKON: You might want to check out Axiom, too. |
| 01:33.21 | philiKON | yeh, i did briefly |
| 01:33.29 | jkakar | philiKON: If nothing else, i think the Divmod guys came up with interesting ways to test performance and make sure it was fast enough. |
| 01:33.49 | jkakar | philiKON: Axiom provided inspiration for Storm, at least in terms of it's API. |
| 01:34.24 | jkakar | philiKON: Let us know how it works for you, it's an interesting idea. |
| 01:34.27 | jkakar | => dinner |
| 01:34.31 | philiKON | will do |
| 02:35.32 | *** join/#storm gabriel (n=gabriel@mc-194-217.IPReg.mcmaster.ca) |
| 03:17.43 | *** join/#storm danilo__ (n=danilo@static-213-198-236-193.adsl.eunet.rs) |
| 03:31.42 | *** join/#storm stub (n=stub@ppp-58-11-88-12.revip2.asianet.co.th) |
| 04:48.22 | *** join/#storm gabriel (n=gabriel@d24-141-18-191.home.cgocable.net) |
| 05:41.57 | *** join/#storm gabriel (n=gabriel@d24-141-18-191.home.cgocable.net) |
| 06:23.13 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 07:24.34 | *** join/#storm danilos (n=danilo@canonical/launchpad/danilos) |
| 08:17.51 | *** join/#storm replicant (n=kapil@pool-74-96-4-147.washdc.east.verizon.net) |
| 08:30.18 | *** join/#storm elmom_ (n=elmom@vallila-gw.hupnet.helsinki.fi) |
| 09:14.22 | *** join/#storm zmijunkie (n=chatzill@i59F5DE7E.versanet.de) |
| 09:58.59 | *** join/#storm srichter (n=quassel@c-76-19-135-180.hsd1.ma.comcast.net) |
| 10:16.38 | *** join/#storm bac (n=bac@cpe-065-190-186-163.nc.res.rr.com) |
| 10:25.35 | *** join/#storm artista_frustrad (n=artista_@201-15-206-214.ctame704.dsl.brasiltelecom.net.br) |
| 10:34.53 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 10:53.07 | *** join/#storm elmom_ (n=elmom@vallila-gw.hupnet.helsinki.fi) |
| 10:56.56 | *** join/#storm philiKON (n=philiKON@gw-trusted.physics.gla.ac.uk) |
| 11:29.55 | *** join/#storm shaunm (n=shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
| 11:57.30 | *** join/#storm danilos (n=danilo@canonical/launchpad/danilos) |
| 11:57.30 | *** join/#storm jml (n=jml@canonical/launchpad/jml) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm mup (n=mup@li37-90.members.linode.com) |
| 11:57.30 | *** join/#storm shaunm (n=shaunm@c-98-212-133-244.hsd1.il.comcast.net) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm philiKON (n=philiKON@gw-trusted.physics.gla.ac.uk) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm artista_frustrad (n=artista_@201-15-206-214.ctame704.dsl.brasiltelecom.net.br) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm bac (n=bac@canonical/launchpad/bac) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm srichter (n=quassel@c-76-19-135-180.hsd1.ma.comcast.net) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm zmijunkie (n=chatzill@i59F5DE7E.versanet.de) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm replicant (n=kapil@pool-74-96-4-147.washdc.east.verizon.net) [NETSPLIT VICTIM] |
| 11:57.30 | *** join/#storm gabriel (n=gabriel@d24-141-18-191.home.cgocable.net) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm stub (n=stub@canonical/launchpad/stub) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm maxb (n=maxb@80.68.92.224) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm oubiwann (n=oubiwann@c-24-8-208-199.hsd1.co.comcast.net) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm rockstar (n=rockstar@canonical/launchpad/rockstar) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm jkakar (n=jkakar@S0106001ee57a879c.vc.shawcable.net) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm danilo_ (n=danilo@cable-94-189-247-236.dynamic.sbb.rs) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm thumper (n=quassel@canonical/launchpad/thumper) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm yosafbridge (n=yosafbri@li14-39.members.linode.com) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm wgrant (n=wgrant@ubuntu/member/wgrant) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm therve (n=therve@xvm-14-10.ghst.net) [NETSPLIT VICTIM] |
| 11:57.31 | *** join/#storm mzz (n=mzz@flits102-164.flits.rug.nl) [NETSPLIT VICTIM] |
| 11:58.46 | *** join/#storm niemeyer (n=niemeyer@189.73.142.161) |
| 11:58.46 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 11:58.47 | *** join/#storm bigdog1 (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 12:09.09 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 12:19.42 | *** join/#storm fcorrea (n=fcorrea@187.3.137.148) |
| 12:24.27 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 12:25.30 | *** join/#storm drudi (n=drudi@187.47.4.55) |
| 12:25.38 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 12:34.01 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 12:42.59 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 12:45.17 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 13:29.41 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 13:52.19 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 14:00.13 | *** join/#storm srichter (n=quassel@75.150.101.45) |
| 14:09.12 | *** join/#storm danilo_ (n=danilo@cable-94-189-247-236.dynamic.sbb.rs) |
| 14:18.40 | *** join/#storm zmijunkie_ (n=chatzill@i59F5D6A2.versanet.de) |
| 15:14.10 | *** join/#storm elmom_ (n=elmom@hoasnet-fe29dd00-137.dhcp.inet.fi) |
| 16:00.08 | *** join/#storm replicant (n=kapil@pool-74-96-4-147.washdc.east.verizon.net) |
| 16:44.29 | fcorrea | hello there. What's the best way to get something like: select foo, count(*) as qdt from baz group by foo in storm? |
| 17:08.40 | jkakar | fcorrea: Something like this should work if I remember correctly: result = store.find((Baz.foo, Count())).group_by(Baz.foo) |
| 17:09.23 | fcorrea | jkakar: interesting. Will try it out |
| 17:13.15 | fcorrea | jkakar: absolutely right |
| 17:13.39 | fcorrea | I wish the wiki was somehow public so I could document it somewhere in there |
| 18:16.40 | *** join/#storm replicant (n=kapil@pool-74-96-4-147.washdc.east.verizon.net) |
| 18:27.57 | jkakar | fcorrea: It's not public? I wonder if I can create a user for you. |
| 18:28.44 | jkakar | fcorrea: What happens when you click 'Login' in the right-hand pane at storm.canonical.com? |
| 18:28.53 | fcorrea | jkakar: I'd be happy to contribute on some subjects like "Common sequel operations in Storm" |
| 18:29.03 | jkakar | fcorrea: We would really appreciate that. |
| 18:29.13 | jkakar | fcorrea: As you know, our documentation could do with a lot of love. :) |
| 18:29.46 | fcorrea | jkakar: well, as a matter of fact I didn't check for that ;) |
| 18:30.11 | *** join/#storm mikex2 (n=mikael@193.11.22.216) |
| 18:30.31 | jkakar | fcorrea: Ah, okay. :) |
| 18:31.00 | fcorrea | jkakar: I'm in. ty! |
| 18:31.35 | fcorrea | Is that okay to put that on Manual? Or do you think Tutorial? |
| 18:33.00 | jkakar | fcorrea: The tutorial should probably have something about that kind of thing if it doesn't already. |
| 18:33.03 | therve | the tutorial is generated from the source I think? |
| 18:33.06 | jkakar | fcorrea: It's actually maintained as a doctest in the sourc. |
| 18:33.12 | jkakar | therve: Right. :) |
| 18:33.20 | fcorrea | cool |
| 18:33.26 | jkakar | fcorrea: So the thing to do there is create a branch, and put it in review, and then update the wiki once that's done. |
| 18:33.44 | fcorrea | jkakar: not a problem. Will do it tonight at home |
| 18:33.55 | jkakar | fcorrea: All that said, the manual really needs attention, but whatever goes there should probably be much more detailed than what goes in the tutorial. |
| 18:33.59 | jkakar | fcorrea: Thanks, that would be great! |
| 18:34.06 | *** join/#storm oubiwann_ (n=oubiwann@c-24-8-208-199.hsd1.co.comcast.net) |
| 18:34.56 | fcorrea | jkakar: yeah, lots of hidden treasures in there |
| 18:38.24 | *** join/#storm jukart (n=jukart@d86-32-163-51.cust.tele2.at) |
| 18:42.54 | jkakar | fcorrea: If you do make changes please mention it here or on the mailing list so we can review them. |
| 18:43.13 | jkakar | fcorrea: It'll also be a nice way to bring the topic to people's attention and hopefully your enthusiasm will spur others to chip in and help, too. |
| 18:43.18 | fcorrea | jkakar: sure, will sign up on ml |
| 18:45.04 | jkakar | fcorrea: Awesome, thanks. |
| 19:16.42 | *** join/#storm elmom_ (n=elmom@hoasnet-fe29dd00-137.dhcp.inet.fi) |
| 19:21.50 | *** join/#storm grantgm (n=gabriel@mc-125-173.IPReg.McMaster.CA) |
| 19:58.54 | *** join/#storm grantgm (n=gabriel@mc-122-175.IPReg.McMaster.CA) |
| 20:44.08 | *** join/#storm oubiwann_ (n=oubiwann@c-24-8-208-199.hsd1.co.comcast.net) |
| 20:58.41 | *** join/#storm philiKON (n=philiKON@cpc3-broo2-0-0-cust103.renf.cable.ntl.com) |
| 21:12.26 | *** join/#storm srichter_ (n=quassel@75.150.101.45) |
| 21:40.20 | *** join/#storm fcorrea (n=fcorrea@189-54-24-127-nd.cpe.vivax.com.br) |
| 22:07.24 | *** join/#storm gabriel (n=gabriel@mc-189-141.IPReg.mcmaster.ca) |
| 22:09.39 | *** join/#storm srichter (n=quassel@75.150.101.45) |
| 22:11.39 | *** join/#storm replicant (n=kapil@pool-74-96-4-147.washdc.east.verizon.net) |
| 23:03.28 | mup | storm/trunk r353 committed by jkakar@kakar.ca |
| 23:03.28 | mup | - Removed Debian packaging files [trivial]. |