| 01:28.35 | *** join/#storm niemeyer_away (~niemeyer@189-10-219-9.pltce701.dsl.brasiltelecom.net.br) |
| 05:20.43 | *** join/#storm wallyworld__ (~quassel@27-33-46-253.static.tpgi.com.au) |
| 07:26.48 | *** join/#storm esteve (~quassel@cli-5b7ee22f.bcn.adamo.es) |
| 07:43.02 | *** join/#storm zmijunkie (~sascha@pd95b6fd9.dip0.t-ipconnect.de) |
| 07:53.36 | *** join/#storm esteve (~quassel@cli-5b7ee22f.bcn.adamo.es) |
| 08:16.06 | *** join/#storm stub (~stub@125.24.100.83.adsl.dynamic.totbb.net) |
| 08:16.06 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 09:14.58 | *** join/#storm pingveno (~pingveno@c-98-246-133-8.hsd1.or.comcast.net) |
| 09:15.57 | *** join/#storm pingveno1 (~pingveno@c-98-246-133-8.hsd1.or.comcast.net) |
| 09:40.20 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 11:46.28 | *** join/#storm wallyworld (~quassel@27-33-46-253.static.tpgi.com.au) |
| 12:02.37 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 12:19.35 | *** join/#storm niemeyer (~niemeyer@189-10-219-9.pltce701.dsl.brasiltelecom.net.br) |
| 13:06.16 | rrerolle | :q! |
| 13:06.34 | rrerolle | sry |
| 16:59.16 | *** join/#storm keppla (~keppla@p4FD46DC1.dip.t-dialin.net) |
| 17:00.57 | *** join/#storm Cameron__ (4a5cf5b5@gateway/web/freenode/ip.74.92.245.181) |
| 17:05.14 | Cameron__ | question for anyone...I'm newer to storm and I'm trying to create a ReferenceSet thats comparing a field defined as an Int and the other as Unicode (can't change the tables). This isn't a problem in sqlite but in postgres it requires type casting and can't join the tables. Is there any easy work around for this that I'm not seeing? |
| 17:30.29 | *** join/#storm medberry (~medberry@c-75-71-81-190.hsd1.co.comcast.net) |
| 17:30.29 | *** join/#storm medberry (~medberry@canonical/oem/medberry) |
| 17:45.33 | veloutin | Cameron__: you can create a view that casts your data |
| 17:46.49 | *** join/#storm medberry (~medberry@75.71.81.190) |
| 17:46.49 | *** join/#storm medberry (~medberry@canonical/oem/medberry) |
| 17:54.52 | *** join/#storm webmaven (~webmaven@97.65.119.2) |
| 18:01.32 | Cameron__ | Is there a storm solution assuming your referring to a postgres view. I'm limited on my database control. |
| 18:33.55 | *** join/#storm Cameron_ (4a5cf5b5@gateway/web/freenode/ip.74.92.245.181) |
| 18:34.41 | Cameron_ | bah |
| 18:50.44 | jkakar | Cameron_: Hi. :) |
| 18:51.10 | Cameron_ | Hello |
| 18:51.18 | jkakar | Cameron_: A good way to start to figure out what you can do is to write the SQL you want Storm to run for you. |
| 18:51.34 | jkakar | Cameron_: Once we know what query we want, we can probably figure out a way to make it happen. |
| 18:51.56 | *** join/#storm pingveno (~pingveno@c-98-246-133-8.hsd1.or.comcast.net) |
| 18:52.07 | Cameron_ | awesome, give me a few mins :) |
| 19:37.40 | Cameron_ | SELECT t.x t.y t.z a.summary FROM table as t, anothertable as a WHERE t.sorta::text = a.y AND t.name = a.name |
| 20:22.44 | *** join/#storm pingveno (~pingveno@c-98-246-133-8.hsd1.or.comcast.net) |
| 21:10.47 | *** join/#storm vokoda (~user@unaffiliated/vokoda) |
| 21:15.03 | vokoda | I'm having a little trouble getting a subselect to work with storm: |
| 21:15.04 | vokoda | http://paste.pocoo.org/show/379342/ |
| 21:15.24 | vokoda | what am I doing wrong? |
| 21:26.42 | jkakar | vokoda: You should use ResultSet.get_select_expr: http://paste.pocoo.org/show/379350/ |
| 21:28.46 | vokoda | jkakar: ah ok, didn't know about that |
| 21:28.51 | vokoda | jkakar: how about this: http://paste.pocoo.org/show/379355/ |
| 21:29.09 | vokoda | jkakar: is that doing what I think it's doing? seems to work.. |
| 21:33.34 | jkakar | vokoda: I think it looks okay, though when I look at Select.__init__ it looks like the parameters should be lists. |
| 21:33.59 | jkakar | vokoda: Anyway, I think you should use Store.find and ResultSet.get_select_expr to build subselects. It's much simpler. |
| 21:36.35 | vokoda | jkakar: ok, thanks :) |
| 23:29.14 | *** join/#storm bigdog1 (~scmikes@72-197-8-8-arpa.cust.cincinnaticomm.net) |
| 23:46.10 | *** join/#storm jamesh (~james@canonical/launchpad/jamesh) |