| 00:09.36 | *** join/#storm tjs (n=tjs@203.206.162.25) |
| 00:10.18 | *** join/#storm johnlr2 (n=johnlr@203-206-162-97.perm.iinet.net.au) |
| 00:12.59 | *** join/#storm jml (n=jml@ppp121-44-221-92.lns1.hba1.internode.on.net) |
| 00:29.54 | *** join/#storm oubiwann (n=oubiwann@209-181-154-99.omah.qwest.net) |
| 00:33.53 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 01:14.56 | *** join/#storm oubiwann_ (n=oubiwann@71-34-195-79.omah.qwest.net) |
| 01:31.58 | *** join/#storm oubiwann (n=oubiwann@70-57-178-63.omah.qwest.net) |
| 01:51.07 | *** join/#storm jml_ (n=jml@203-113-250-169-static.TAS.netspace.net.au) |
| 02:21.00 | *** join/#storm oubiwann_ (n=oubiwann@71-34-193-217.omah.qwest.net) |
| 03:40.01 | *** join/#storm oubiwann (n=oubiwann@209-181-152-148.omah.qwest.net) |
| 03:51.04 | *** join/#storm oubiwann_ (n=oubiwann@209-181-152-36.omah.qwest.net) |
| 04:07.19 | *** join/#storm jml_ (n=jml@ppp121-44-221-92.lns1.hba1.internode.on.net) |
| 07:13.06 | *** join/#storm mcella (n=michele@ip-176-22.sn2.eutelia.it) |
| 07:21.59 | *** join/#storm dobee (n=dobeee@dslb-088-072-003-024.pools.arcor-ip.net) |
| 07:43.34 | *** join/#storm jukart (n=jukart@lsfw01.lovelysystems.com) |
| 07:46.09 | *** join/#storm jml (n=jml@ppp121-44-221-92.lns1.hba1.internode.on.net) |
| 10:03.31 | *** join/#storm mcella_ (n=michele@ip-176-22.sn2.eutelia.it) |
| 10:04.20 | *** join/#storm oubiwann (n=oubiwann@209-181-154-2.omah.qwest.net) |
| 11:22.50 | *** join/#storm dobee (n=dobeee@dslb-088-072-003-024.pools.arcor-ip.net) |
| 11:56.10 | *** join/#storm niemeyer (n=niemeyer@200-103-134-216.ctame705.dsl.brasiltelecom.net.br) |
| 12:00.40 | *** join/#storm Key_Gena (i=lok@gateway/tor/x-a82e271659ef7ef6) |
| 12:09.53 | niemeyer | Good morning |
| 12:10.59 | *** join/#storm KaL (n=KaL@spain2.ai.wu-wien.ac.at) |
| 12:12.36 | KaL | hi!, I'm wondering whether it's possible to do something like 'select distinct(column) from foo;' with storm |
| 12:13.03 | *** join/#storm rafael (n=rafael@moinmoin/fan/rafael) |
| 12:14.27 | KaL | I've seen there is a ResultSet.config method with a distinct param, but I'm not sure how to use it |
| 12:22.41 | KaL | hmm, using store.execute (Select (... instead of store.find it seems to work |
| 12:23.03 | niemeyer | KaL: Hmm |
| 12:23.11 | niemeyer | KaL: You can do it with |
| 12:23.29 | niemeyer | store.find(MyClass, ...).config(distinct=True).values(MyClass.column) |
| 12:23.50 | KaL | I think I've already tried that, let me try again |
| 12:24.09 | niemeyer | KaL: If it doesn't work it's probably a bug |
| 12:26.03 | KaL | niemeyer: yes, it works, I guess I did something wrong when I tried it the first time |
| 12:26.09 | KaL | niemeyer: thank you! |
| 12:26.44 | niemeyer | KaL: Nie! |
| 12:26.49 | niemeyer | KaL: Nice even! :-) |
| 12:39.11 | *** join/#storm Key_Gena (i=lok@gateway/tor/x-418ebfbcc5029684) |
| 12:56.30 | *** join/#storm statik (n=emurphy@189.66.188.72.cfl.res.rr.com) |
| 13:05.38 | *** join/#storm oubiwann_ (n=oubiwann@71-34-204-170.omah.qwest.net) |
| 13:44.39 | *** join/#storm oubiwann (n=oubiwann@209-181-153-164.omah.qwest.net) |
| 14:02.33 | *** join/#storm leifkb (n=leifkb@dsl82.brbovtma.sover.net) |
| 14:09.56 | *** join/#storm oubiwann_ (n=oubiwann@70-57-180-201.omah.qwest.net) |
| 14:31.13 | *** join/#storm oubiwann (n=oubiwann@209-181-155-233.omah.qwest.net) |
| 14:38.08 | jamesh | niemeyer: I've got database disconnect handling working locally (with a slightly modified psycopg2) |
| 14:38.24 | niemeyer | jamesh: Woah! Sweeet! |
| 14:38.44 | niemeyer | jamesh: I've seen your recent updates on the Launchpad bug |
| 14:38.53 | niemeyer | jamesh: Still haven't managed to read your branch, though |
| 14:39.08 | jamesh | niemeyer: I should check if I've pushed my latest work ... |
| 14:39.11 | niemeyer | jamesh: Why was the modification needed? |
| 14:39.21 | niemeyer | jamesh: I mean, in psycopg2 |
| 14:39.35 | jamesh | niemeyer: because the code to generate the Python exception was commented out ... |
| 14:39.44 | niemeyer | WTF? |
| 14:39.53 | jamesh | exactly |
| 14:40.41 | jamesh | so when you get a disconnect, the execute() statement completed with no error |
| 14:40.57 | jamesh | then the following fetchone/fetchmany gave ProgrammingError: no results to fetch |
| 14:41.15 | jamesh | niemeyer: see http://initd.org/tracker/psycopg/browser/psycopg2/branches/2_0_x/psycopg/pqpath.c?rev=892#L414 |
| 14:41.35 | niemeyer | jamesh: Woah.. sadness :( |
| 14:41.59 | niemeyer | jamesh: That reminds me that commit() also does no error checking, as radix mentioned the other day |
| 14:42.25 | jamesh | niemeyer: it doesn't have error checking in 2.0.5, yes. |
| 14:45.51 | jamesh | niemeyer: of course, 2.0.6 had its own problems, which is what ticket 194 was about |
| 15:05.39 | niemeyer | jamesh: Right |
| 15:18.08 | *** join/#storm dobee_ (n=dobeee@dslb-088-072-006-143.pools.arcor-ip.net) |
| 15:25.52 | *** join/#storm michelp (n=michelp@69-30-72-119.dq1sf.easystreet.com) |
| 15:58.08 | *** join/#storm leifkb (n=leifkb@dsl82.brbovtma.sover.net) |
| 16:00.56 | *** join/#storm EnTeQuAk (n=EnTeQuAk@p57B99AB0.dip0.t-ipconnect.de) |
| 16:08.22 | *** join/#storm brosner (n=brian@63.150.173.39) |
| 16:42.15 | *** join/#storm oubiwann_ (n=oubiwann@70-57-180-102.omah.qwest.net) |
| 17:20.43 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 17:33.18 | *** join/#storm tarjei (n=tarjeih@mail2.bergfald.no) |
| 17:34.19 | tarjei | Hi, how do I get references when I do a store.find()? I got a class with a Reference attribute, but the attribute is just none when I get a list from find. |
| 17:44.19 | tarjei | Nevermind, the error was due to missing links. |
| 17:44.56 | niemeyer | tarjei: Cool |
| 17:45.12 | tarjei | I'm very impressed with the storm api. |
| 17:49.03 | radix | hooray :) |
| 17:49.21 | *** join/#storm nephish (n=nephish@69.55.24.133) |
| 17:49.55 | nephish | ello all |
| 17:50.34 | jkakar | Heya nephish |
| 17:56.35 | nephish | if i clear out an object, will storm remember it? say if i do var = store.get(Person, 24) do some stuff | later do var = None, does anything happen to the Person() ? |
| 17:56.51 | radix | happen? probably not |
| 17:56.58 | radix | although your question isn't very specific :) |
| 17:57.07 | nephish | or just the stuff that happened before i do the var = None / |
| 17:57.12 | nephish | ? |
| 17:57.15 | radix | I don't understand. |
| 17:57.32 | radix | if you make *modifications* to the Person, then they will take effect in the database. |
| 17:57.44 | radix | even if you delete the variable you had bound to that person. |
| 17:57.50 | radix | Which may or may not be what you're asking about. |
| 18:00.53 | nephish | well i have a GUI, when a person is selected as the active_person, such and such can be modified through the GUI, but if another person is selected, there is a period of time that the active_person should be None so that an accidental edit button push will not make changes to what the active person was previously.. does that make sense? |
| 18:03.43 | radix | ok. |
| 18:30.33 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 18:48.57 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 18:59.42 | *** join/#storm rafael (n=rafael@moinmoin/fan/rafael) |
| 19:04.37 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 19:28.35 | *** join/#storm oubiwann_ (n=oubiwann@70-57-181-66.omah.qwest.net) |
| 19:41.18 | *** join/#storm noizze (n=noise@p549DDF98.dip.t-dialin.net) |
| 19:41.59 | noizze | hello, how can i store a UNIX Timestamp with Storm & Sqlite? |
| 19:42.13 | noizze | integer datatype or string? |
| 19:42.51 | radix | noizze: you can use pretty much any data type for thq sqlite column |
| 19:43.34 | radix | noizze: and you can use storm.properties.DateTime on the python side |
| 19:43.45 | noizze | i used the DATE Type ...but it seems that not for Timestamp |
| 19:44.37 | noizze | radix: ok, thx ....i try with integer |
| 20:50.34 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 22:55.51 | *** join/#storm Key_Gena (i=lok@gateway/tor/x-5525bcd2496868b9) |
| 23:34.19 | *** join/#storm jml (n=jml@203-113-250-169-static.TAS.netspace.net.au) |