IRC log for #storm on 20090504

00:39.09*** join/#storm jkakar (n=jkakar@S0106001ee57a879c.vc.shawcable.net)
04:56.51*** join/#storm jukart (n=jukart@d91-128-122-124.cust.tele2.at)
06:03.36*** join/#storm jukart (i=lovely@81.189.156.94)
07:14.55*** join/#storm zanaga (i=ressu@oxygen.at.ressukka.net)
07:19.44zanagaI have an enum field in the database, how should i access it? is Enum(map={"VAL1": "VAL1", "VAL2": "VAL2"}) the right way? doesn't sound too sane
07:25.03jameshzanaga: if you just want to treat it like strings in Python, I'd use Unicode()
07:25.24jameshEnum() is useful if you're doing things like mapping Python constants to integers in the DB
07:25.37jamesh(e.g. using lazr.enum)
07:26.05zanagaif i use Unicode() it will complain that the string received from the database is not unicode. I'm trying this with pgsql
07:26.48jameshhmm.  I guess you could use RawStr() then
07:39.21zanagathat appears to work
07:39.22zanagathanks
11:39.06*** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs)
11:45.01*** part/#storm zanaga (i=ressu@oxygen.at.ressukka.net)
12:38.39*** join/#storm niemeyer (n=niemeyer@200-138-37-135.ctame705.dsl.brasiltelecom.net.br)
13:27.13*** join/#storm munin (n=munin@209.9.227.50) [NETSPLIT VICTIM]
14:43.23*** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs)
16:12.42*** join/#storm mcayer (n=chatzill@modemcable250.87-70-69.static.videotron.ca)
16:12.53mcayerhi!
16:13.08jkakarHi!
16:13.18mcayerI would need some help for a store.find request
16:13.49jkakarmcayer: Sure, what's up?
16:14.36mcayerwell, I need to make a very complicated request, with fields at some value, and verify that certains relations with another table exists
16:14.42mcayera real mess
16:15.27mcayerthe tables definition contains the necessary ReferenceSet
16:15.59jkakarOkay.
16:16.33mcayeri could sent to you the current request, however I know it doesn't works
16:17.30jkakarmcayer: That's probably a good place to start.  Can you pastebin it please?
16:17.38mcayeryep
16:17.49mcayercould you just sent me the link to do it please?
16:18.20thervemcayer: http://pastebin.ubuntu.com
16:18.56mcayerthere you go : http://pastebin.ubuntu.com/164296/
16:20.29thervebreaking in some lines would have helped :)
16:20.35mcayeroups
16:20.48mcayerin my editor it does it automatically
16:21.17mcayersorry
16:22.26jkakarThe explicit And shouldn't be necessary either.
16:22.31mcayerk
16:23.03jkakarSo, the problem is that you're trying to use the result of Client.roles.find as an expression, which isn't currently supported behaviour.
16:23.05mcayerhowever, should I put parenthesis around everything to make sure it's all and
16:23.11mcayerk
16:23.35mcayerI tried something else using Count() and Gt(), but it didn't work
16:23.53mcayerand I'm sure the roles.find could be done in a more proper way
16:24.26jkakarmcayer: Can you paste the ReferenceSet definition for Client.roles, please?
16:24.30mcayersure
16:25.04jkakarI'm not sure you'll actually be able to do all of this in a single query; there's a lot of counting going on here.
16:25.37mcayerhttp://pastebin.ubuntu.com/164298/
16:26.06mcayerwell all I'm trying to do is verify a client a a particular role, so I can proceed with it or not
16:26.32jkakarmcayer: Do you map the same 'trial' Role row in your database to all Client's with that role?
16:26.41jkakarmcayer: Or does each client have a unique set of Roles?
16:26.45mcayerin my PHP framework it's done easily, and I'm trying to do the same thing in Python
16:26.48mcayerboth
16:27.33mcayera table Role exists defining every roles needed, and a Clients_roles table makes the relation between both
16:27.43mcayera many-to-many relationship
16:28.23jkakarOh right, I see that now that I read the ReferenceSet definition more carefully.
16:28.34mcayerk
16:31.29jkakarmcayer: Have you tried something like this: http://pastebin.ubuntu.com/164303/
16:31.40*** join/#storm shaunm (n=shaunm@proxyserver.wolfram.com)
16:32.25mcayerno
16:32.39mcayerbut I don't see how it can helps me
16:32.40jkakarmcayer: It may not be very efficient, but it should work I think.
16:32.53jkakarmcayer: Oh crap, you're right.
16:33.01jkakarmcayer: Sorry, it's early here and the coffee still hasn't set in. :)
16:33.09mcayerwhere are you?
16:33.26jkakarmcayer: In Vancouver, Canada.  So I guess it's not that early... 9:30am. :)
16:33.33mcayerlol
16:33.42jkakarBut the coffee still hasn't set it. ;)
16:33.43mcayerI'm in Montreal
16:33.50mcayerit's midday here
16:33.55mcayer;)
16:33.56jkakarmcayer: Oh nice!  I love Montréal.
16:34.17jkakarmcayer: I'm not sure how to do what you want because I don't think I understand what the SQL is that you would need to run to get the results you want.
16:34.31mcayerk
16:34.52mcayerhum
16:34.54jkakarmcayer: I would probably tackle this problem by figuring out what the SQL query(s) needed to produce the result are.
16:35.10mcayerthat's what I tought
16:35.15jkakarAnd then work back from that to figure out how to make Storm generate the query.
16:35.26mcayerk
16:35.44jkakarIn some cases, where queries are particularly complicated, we use store.execute(sql_statement) instead of using store.find.
16:35.45mcayeryeah, something like doing the query in phpmyadmin
16:35.51mcayerk
16:35.52jkakarYep, exactly.
16:36.06jkakarSorry to not be more helpful than that right now.
16:36.17mcayerthat's okay
16:36.42mcayernow I have some more work to do, but I know in which direction I should head :)
18:39.00*** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs)
18:54.45*** join/#storm sidnei (n=sidnei@plone/dreamcatcher)
19:00.20*** join/#storm sidnei (n=sidnei@plone/dreamcatcher)
19:24.47mcayerjkakar: are you still there?
20:20.47*** join/#storm artista_frustrad (n=artista_@201.35.2.95)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.