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) |