| 00:00.25 | *** join/#storm _mup_ (~mup@li37-90.members.linode.com) |
| 01:58.10 | *** join/#storm med_out (~medberry@canonical/oem/medberry) |
| 01:58.10 | *** join/#storm artista_frustrad (~artista_f@201-14-24-109.ctame704.dsl.brasiltelecom.net.br) |
| 02:07.14 | *** join/#storm jamesh (~james@canonical/launchpad/jamesh) |
| 02:49.31 | *** join/#storm veloutin (~vvinet@nat/revolutionlinux/x-dnkaqqwiadimtgqb) |
| 08:17.11 | *** join/#storm bigjools (~quassel@82-71-93-254.dsl.in-addr.zen.co.uk) |
| 08:17.11 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
| 10:08.03 | *** join/#storm stub (~stub@125.24.105.38.adsl.dynamic.totbb.net) |
| 10:08.03 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 12:20.59 | *** join/#storm jkakar (~jkakar@2.Red-88-17-252.dynamicIP.rima-tde.net) |
| 14:06.03 | *** join/#storm Horrorcat (~unknown@static.88-198-247-171.clients.your-server.de) |
| 14:06.09 | Horrorcat | hi all |
| 14:08.00 | Horrorcat | I'll just ask right away⦠I'm having objects with Timestamps, like http://pastie.org/private/zsbawpxshsvwkyvilgewzq |
| 14:08.26 | Horrorcat | now I'd like to find out for which years and months objects exist and I'd like to let the SQL server do this |
| 14:08.34 | marienz | your timestamp isn't a timestamp |
| 14:08.41 | Horrorcat | its a unix timestamp |
| 14:09.07 | Horrorcat | should I use something different than Int for that? |
| 14:09.16 | jkakar | Horrorcat: You should be using DateTime instead. |
| 14:09.17 | marienz | there's a DateTime property |
| 14:09.32 | marienz | I don't know what that gets turned into in all databases, but it's more likely to do what you want than Int is |
| 14:10.14 | jkakar | Horrorcat: You pass it datetime instances on the Python side. On the database side it's stored as a TIMESTAMP type. |
| 14:10.50 | Horrorcat | I remember having issues with the mysql TIMESTAMP type in the past |
| 14:10.58 | Horrorcat | (not with storm though) |
| 14:11.14 | Horrorcat | thats why I use Bigint on the database side |
| 14:11.31 | marienz | then it'll be somewhat awkward to come up with the query you want |
| 14:12.12 | marienz | not that I can actually spell out the query if your column *is* a timestamp, but still :) |
| 14:12.27 | Horrorcat | SELECT YEAR(FROM_UNIXTIME(Timestamp)) as year, MONTH(FROM_UNIXTIME(Timestamp)) as month FROM transmissions GROUP BY year, month |
| 14:12.36 | Horrorcat | this it what I'd do in raw SQL to get what I want |
| 14:12.43 | Horrorcat | any way to do that directly in storm? |
| 14:13.06 | marienz | I'm pretty sure you'd have to drop to raw for that |
| 14:13.16 | therve | or you can define Storm functions |
| 14:13.21 | jkakar | You can use NamedFunc, but using a raw expression is probably easier. |
| 14:13.25 | jkakar | raw query, that is. |
| 14:13.33 | jkakar | therve: Hi! I was just talking about harassing you. :) |
| 14:13.34 | Horrorcat | mmk |
| 14:14.03 | Horrorcat | ok⦠how do I execute a raw expression with storm? :) |
| 14:14.08 | therve | jkakar, you mean to harass me in the future, or how you harassed me in the past? |
| 14:14.18 | jkakar | therve: Uhm, the present actually. |
| 14:14.18 | therve | Horrorcat, store.execute(query) |
| 14:14.25 | Horrorcat | ah right |
| 14:14.29 | therve | jkakar, the future is now! |
| 14:14.42 | jkakar | therve: Well, now that future is the past. |
| 14:14.52 | jkakar | therve: We just changed dimensions! |
| 14:15.02 | Horrorcat | ah great, that works fine |
| 14:15.05 | therve | damn you're harassing me already |
| 14:15.15 | Horrorcat | thank you :) |
| 14:15.18 | jkakar | therve: Anyway, allenap fixed the problems in my json-property branch, which I've merged... can you please approve, so I can merge? |
| 14:15.25 | jkakar | therve: https://code.launchpad.net/~jkakar/storm/json-property/+merge/51634 |
| 14:15.59 | therve | oh noes |
| 14:16.05 | therve | jkakar, can you review a branch of mine? :) |
| 14:16.10 | jkakar | therve: Sure, which one? :) |
| 14:16.20 | jkakar | therve: The one that niemeyer had questions about...? |
| 14:16.33 | therve | jkakar, https://code.launchpad.net/~therve/storm/cache-compile/+merge/71473 |
| 14:16.46 | jkakar | therve: Sure, am on it. |
| 14:16.51 | therve | thanks |
| 14:17.54 | *** join/#storm niemeyer (~niemeyer@200.102.220.181) |
| 14:19.03 | therve | oh no a compat module |
| 14:19.16 | jkakar | It wasn't me. |
| 14:19.19 | jkakar | niemeyer: Hi! :) |
| 14:21.03 | jkakar | therve: Done! |
| 14:21.53 | jkakar | Hmm, I guess I should add docstrings before merging the changes from allenap. |
| 14:22.24 | jkakar | niemeyer: Unless you have a problem with it, I think therve's branch is ready to land: https://code.launchpad.net/~therve/storm/cache-compile/+merge/71473 |
| 14:27.50 | niemeyer | jkakar! |
| 14:27.56 | jkakar | niemeyer: !!! :) |
| 14:28.02 | jkakar | niemeyer: How are things? |
| 14:28.57 | niemeyer | jkakar: pretty good in general |
| 14:29.03 | jkakar | niemeyer: Nice, that's good to hear. |
| 14:29.24 | niemeyer | jkakar: Yeah, I'm happy with it |
| 14:29.38 | jkakar | niemeyer: Jenn and I are getting ready to hit the road... we leave Barcelona in less than two weeks. It's a bit of a weird mix of feelings. |
| 14:30.03 | niemeyer | Wow |
| 14:30.11 | niemeyer | jkakar: I can imagine :) |
| 14:30.36 | jkakar | niemeyer: Yeah, it's a hard life... you know, leaving an awesome city to travel around the world... but someone has to do it. |
| 14:30.37 | jkakar | ;b |
| 14:31.12 | niemeyer | jkakar: Hehehe :-) |
| 14:31.14 | _mup_ | storm/json-property r390 committed by jkakar@kakar.ca |
| 14:31.14 | _mup_ | - Minor formatting improvements. |
| 14:31.56 | niemeyer | jkakar: Feel free to step by :) |
| 14:32.43 | _mup_ | storm/trunk r399 committed by jkakar@kakar.ca |
| 14:32.43 | _mup_ | Merged json-property [r=stub,therve] [f=726799] |
| 14:32.43 | _mup_ | A new JSON property is available. It's similar to the existing Pickle |
| 14:32.43 | _mup_ | property, except that it serializes data as JSON. Thanks to Gavin |
| 14:32.44 | _mup_ | Panella for helping finish and get this branch landed! |
| 14:32.56 | jkakar | niemeyer: I'd love to. :) |
| 14:41.11 | *** join/#storm esteve (~quassel@cli-5b7ee9bd.bcn.adamo.es) |
| 14:46.10 | therve | niemeyer, I just realized I only answer half of your comment, and in a wrong way, sorry |
| 15:04.02 | _mup_ | storm/trunk r400 committed by thomas@canonical.com |
| 15:04.02 | _mup_ | Merge cache-compile [r=free.ekanayaka,jkakar,niemeyer] [f=826170] |
| 15:04.02 | _mup_ | Cache the compilation of columns and tables. |
| 15:06.54 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 15:07.59 | jkakar | Woot! |
| 18:01.54 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 21:25.59 | *** join/#storm infobot (~infobot@rikers.org) |
| 21:25.59 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.18 released! || Review branches: https://code.launchpad.net/storm/+activereviews || IRC logs: http://ibot.rikers.org/#storm/ || API documentation: http://people.canonical.com/~jkakar/storm/ |
| 21:45.48 | *** join/#storm lifeless (~robertc@222.153.223.45) |
| 23:47.29 | *** join/#storm lifeless (~robertc@222.153.223.40) |