| 00:08.41 | *** join/#storm fcorrea (~fcorrea@189.85.82.50) |
| 00:15.07 | *** join/#storm fcorrea_ (~fcorrea@189.85.82.50) |
| 00:18.14 | *** join/#storm artista_frustrad (~artista_f@187.55.87.184) |
| 03:42.05 | *** join/#storm jdobrien (~john@24.18.88.184.cfl.res.rr.com) |
| 05:14.55 | *** join/#storm marienz (~marienz@freenode/staff/marienz) |
| 05:28.26 | *** join/#storm jtv (~jtv@27.130.84.36) |
| 05:37.36 | *** join/#storm jtv (~jtv@27.130.84.36) |
| 05:44.03 | *** join/#storm jtv (~jtv@27.130.84.36) |
| 05:52.34 | *** join/#storm jtv (~jtv@27.130.84.36) |
| 07:40.23 | *** join/#storm niemeyer (~niemeyer@201-2-134-72.pltce701.dsl.brasiltelecom.net.br) |
| 07:40.32 | *** join/#storm marienz (~marienz@freenode/staff/marienz) |
| 07:44.24 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 08:58.38 | *** join/#storm danilos (~danilo@cable-89-216-144-44.dynamic.sbb.rs) |
| 08:58.38 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 09:20.19 | *** join/#storm zmijunkie (~sascha@89.244.144.168) |
| 09:58.59 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 10:20.34 | *** join/#storm stub1 (~stub@125.24.177.241.adsl.dynamic.totbb.net) |
| 10:20.36 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 10:49.26 | *** join/#storm marienz_ (~marienz@freenode/staff/marienz) |
| 10:53.37 | *** join/#storm wallyworld__ (~quassel@27-33-46-253.static.tpgi.com.au) |
| 11:06.06 | *** join/#storm jkakar (~jkakar@113.Red-79-154-164.dynamicIP.rima-tde.net) |
| 11:57.58 | *** join/#storm artista_frustrad (~artista_f@187.55.87.184) |
| 11:58.46 | *** join/#storm jdobrien (~john@184.88.18.24) |
| 12:50.20 | *** join/#storm artista-frustrad (~artista_f@187.55.87.184) |
| 13:22.30 | *** join/#storm artista-frustrad (~artista_f@187.55.87.184) |
| 13:27.03 | *** join/#storm fcorrea (~fcorrea@187-25-163-107.3g.claro.net.br) |
| 14:28.35 | *** join/#storm niemeyer (~niemeyer@201-2-134-72.pltce701.dsl.brasiltelecom.net.br) |
| 14:48.39 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 15:00.48 | *** join/#storm wallyworld_ (~quassel@27-33-46-253.static.tpgi.com.au) |
| 15:44.51 | *** join/#storm wallyworld_ (~quassel@27-33-46-253.static.tpgi.com.au) |
| 15:47.10 | *** join/#storm niemeyer (~niemeyer@201-2-134-72.pltce701.dsl.brasiltelecom.net.br) |
| 15:51.03 | *** join/#storm artista-frustrad (~artista_f@187.55.87.184) |
| 16:22.36 | *** join/#storm fcorrea (~fcorrea@187-25-163-107.3g.claro.net.br) |
| 16:37.03 | *** join/#storm magmatt (~Matt@74-92-245-181-Utah.hfc.comcastbusiness.net) |
| 17:13.23 | *** join/#storm sidnei (~sidnei@201-40-159-34.cslce701.dsl.brasiltelecom.net.br) |
| 18:48.23 | *** join/#storm elmom_ (~elmom@a88-113-64-135.elisa-laajakaista.fi) |
| 18:52.35 | *** join/#storm fcorrea (~fcorrea@187.82.120.239) |
| 19:52.05 | magmatt | how best to do this: store.execute('select ⦠where field in ?', (['foo', 'bar', 'baz'],)) ? |
| 20:15.39 | marienz | magmatt: http://paste.pocoo.org/show/306139/ ? |
| 20:20.35 | magmatt | marienz: thanks! so you prefer the non-sql method |
| 20:21.51 | marienz | I do? |
| 20:32.01 | magmatt | I mean, store.find(objects/classes) over "sql statement" |
| 20:37.11 | marienz | well, yes |
| 20:37.47 | marienz | I don't see much point in hand-crafting sql if I can get storm to do it for me, or in using storm if I'm handcrafting my sql anyway, if you know what I mean |
| 20:40.47 | magmatt | gotcha⦠that "in" is on the end of a sorta complex sql query⦠so I guess I'll just stay in sql-land |
| 20:42.15 | marienz | you might be able to do something clever with storm.SQL |
| 20:42.32 | *** join/#storm niemeyer (~niemeyer@201-2-134-72.pltce701.dsl.brasiltelecom.net.br) |
| 20:42.47 | marienz | store.find(Thing, storm.And(storm.SQL('insert your sql here'), Thing.field.is_in(...))) |
| 20:45.25 | *** join/#storm bac` (~bac@cpe-024-163-113-206.nc.res.rr.com) |
| 20:46.23 | magmatt | really? |
| 20:46.24 | magmatt | wow |
| 20:46.47 | *** join/#storm jdobrien (~john@184.88.18.24) |
| 20:53.36 | marienz | I really don't know what kind of complicated sql thing you're doing, so I have no idea if I'm just making things worse here :) |
| 20:53.55 | marienz | I don't really recall having to drop back to sql for SELECTs with storm yet |
| 21:02.29 | *** join/#storm bac (~bac@cpe-024-163-113-206.nc.res.rr.com) |
| 21:02.40 | *** join/#storm bac (~bac@canonical/launchpad/bac) |
| 21:09.45 | *** join/#storm jdobrien (~john@184.88.18.24) |
| 22:06.16 | magmatt | Is there a way to set the query paramstyle used by store.execute? |
| 22:06.26 | magmatt | having some problems moving from sqlite to postgres |
| 22:12.31 | marienz | magmatt: why do you care? afaik storm always expects you to use "?" and converts automatically if the underlying db needs something else |
| 22:13.07 | magmatt | I don't care :) except storm is expecting %s for postgres |
| 22:13.22 | magmatt | I was using ? and it doesn't work with postgres |
| 22:13.28 | marienz | can you pastebin actual failing code or something? |
| 22:13.41 | magmatt | it's a little big⦠I can make a min example |
| 22:22.10 | magmatt | marienz: http://paste.pocoo.org/show/306181/ |
| 22:22.33 | magmatt | getStormURI just returns my local postgres URI |
| 22:26.34 | marienz | this would probably be easier for me to test if I had a postgres around |
| 22:26.36 | marienz | reads code |
| 22:27.37 | marienz | ah |
| 22:28.23 | marienz | magmatt: I'm assuming your "faliing" actually works if you wouldn't need that "like"? |
| 22:29.01 | magmatt | yup |
| 22:29.25 | marienz | can you try http://paste.pocoo.org/show/306187/ please? |
| 22:30.21 | magmatt | yup |
| 22:30.29 | marienz | memory rusty, I'm pretty sure I did the same thing I did there once before to fix something similar |
| 22:30.40 | magmatt | that makes more sense to pull that out anway |
| 22:30.47 | magmatt | thank you, as always! |
| 22:31.54 | marienz | no problem |
| 22:34.12 | marienz | ah, I just remembered where I did something similar before: it was when I or someone else was trying to sandwich a user-supplied value between "%"s (which is best done by passing '%' + val + '%' as param instead of trying to keep the "%"s inside the query) |
| 22:41.47 | magmatt | yeah, I think I'll let storm do _all_ my escaping now |
| 22:44.00 | *** join/#storm artista_frustrad (~artista_f@187.55.87.184) |
| 23:01.11 | *** join/#storm artista_frustrad (~artista_f@187.55.87.184) |
| 23:18.41 | *** join/#storm artista_frustrad (~artista_f@187.55.87.184) |