00:00.22 | *** join/#storm _mup_ (~mup@li37-90.members.linode.com) |
01:38.30 | *** join/#storm milosn_ (~milosn@02de808f.bb.sky.com) |
02:26.56 | *** join/#storm barry (~barry@canonical/launchpad/barry) |
02:27.09 | barry | yeah, it's a bit late for me, i'm probably going to bed soon :) |
02:27.26 | barry | lifeless, jamesh but right now _parse_time() throws a ValueError on the +00:00 |
02:27.39 | lifeless | barry: coming from where - user data or the db data? |
02:27.49 | jamesh | barry: [from #ubuntu-devel], if you are doing time zones, I'd define your column in Storm as DateTime(tzinfo=UTC) |
02:27.57 | lifeless | barry: and with sqlite or postgresql? If postgresql how is your postgresql column defined ? |
02:28.10 | barry | lifeless: it comes from user data and it's trying to stick that into a DateTime() column |
02:28.22 | jamesh | barry: that way Storm will add a UTC tzinfo to data coming out of the DB, and convert data going into the database to UTC |
02:28.22 | barry | jamesh: yeah, i tried that, without happiness |
02:28.47 | barry | jamesh: but only naive datetimes i think |
02:28.50 | lifeless | so, I think that that is a narrower bug |
02:28.50 | jamesh | barry: well, that's what Launchpad is using (well, it was when I hacked on it). If it isn't working, please file bugs |
02:29.03 | lifeless | totally different thing :) |
02:29.28 | jamesh | if you're using naive datetimes, use "timestamp without time zone" and no tzinfo at the storm level |
02:29.34 | barry | here's what i think the problem is. if you're using datetimes in your code with a utc timezone, you have to naive-ify them to store them into a DateTime |
02:30.04 | barry | which is rather inconvenient |
02:30.44 | barry | i'd be happy if using a DateTime(tzinfo=UTC) allowed storing datetimes in a utc tz |
02:30.50 | barry | without naive-ifying them first |
02:30.51 | jamesh | barry: which backend is this with? |
02:31.03 | barry | jamesh: sqlite for sure, i haven't tried it with postgres yet |
02:31.29 | jamesh | barry: It is entirely possible that there is some problems with the datetime parsers in Storm |
02:31.35 | barry | fwiw, i'm hacking around this by calling .replace(tzinfo=None) |
02:31.45 | jamesh | sqlite doesn't support dates, so they're just strings |
02:31.53 | barry | jamesh: that's all i think the bug is saying, or at least, all *i* care about :) |
02:32.12 | jamesh | It'd be worth fixing that, especially if you want to use it for Mailman |
02:32.16 | jamesh | rather than you working around it |
02:32.30 | barry | jamesh: that would be fantastic |
02:38.15 | barry | jamesh, lifeless: thanks. g'nite |
03:40.48 | *** join/#storm bigjools (~quassel@ppp59-167-159-180.static.internode.on.net) |
03:40.49 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
03:55.33 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
04:31.45 | *** join/#storm bigjools (~quassel@ppp59-167-159-180.static.internode.on.net) |
04:31.45 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
06:49.50 | *** join/#storm bigkevmcd (~kevin@87-194-156-112.bethere.co.uk) |
07:59.50 | *** join/#storm esteve (~quassel@cli-5b7eed72.bcn.adamo.es) |
08:03.03 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
08:38.02 | *** join/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
08:40.13 | *** join/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
09:12.23 | *** join/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
09:37.29 | *** part/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
10:41.39 | *** join/#storm milosn (~milosn@5ac0f90e.bb.sky.com) |
11:00.42 | *** join/#storm ant384 (~ghoul@unaffiliated/ant384) |
11:12.52 | *** join/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
11:28.36 | *** join/#storm neogeop (~neogeop@c-217-115-41-36.cust.bredband2.com) |
12:29.52 | *** join/#storm sliderr (~s@84.233.128.147) |
12:30.01 | *** part/#storm sliderr (~s@84.233.128.147) |
13:02.08 | *** join/#storm niemeyer (~niemeyer@189-10-219-18.pltce701.dsl.brasiltelecom.net.br) |
13:02.09 | *** mode/#storm [+o niemeyer] by ChanServ |
14:32.11 | jkakar | therve: Good morning! Can you please ask free to add a NEWS entry for the Distinct expression. :) |
14:37.29 | therve | jkakar, hi |
14:37.38 | therve | I'm not sure, i'll think about it :) |
15:34.41 | *** join/#storm magmatt (~Matt@63-235-131-194.dia.static.qwest.net) |
16:37.36 | jkakar | therve: Thanks. :) |
16:39.05 | *** join/#storm rrerolle (~rrerolle@neonex.fr) |
16:46.11 | *** join/#storm rrerolle (~rrerolle@neonex.fr) |
18:25.13 | *** join/#storm neogeop (~neogeop@s213-103-219-47.cust.tele2.se) |
19:55.05 | *** join/#storm infobot (~infobot@rikers.org) |
19:55.05 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.19 released! || Review branches: https://code.launchpad.net/storm/+activereviews || IRC logs: http://ibot.rikers.org/#storm/ || API documentation: http://people.canonical.com/~therve/storm/ |
20:28.47 | _mup_ | storm/trunk r440 committed by thomas@canonical.com |
20:28.47 | _mup_ | Reset global ZStorm after tests [trivial] [f=959471] |
20:48.42 | *** join/#storm fcorrea (~fcorrea@189.121.216.174) |
20:54.20 | *** join/#storm fcorrea (~fcorrea@189.121.216.174) |
20:54.29 | *** part/#storm neogeop (~neogeop@s213-103-219-47.cust.tele2.se) |
21:03.37 | *** join/#storm neogeop (~neogeop@s213-103-219-47.cust.tele2.se) |