| 01:57.20 | *** join/#storm daniloff (~danilo@cable-94-189-247-236.dynamic.sbb.rs) |
| 02:29.37 | *** join/#storm fcorrea (~fcorrea@201-75-152-196-nd.cpe.vivax.com.br) |
| 04:09.21 | *** join/#storm bigdog (~scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 04:09.53 | *** join/#storm rockstar (~rockstar@starscream.eventuallyanyway.com) |
| 04:10.06 | *** join/#storm rockstar (~rockstar@canonical/launchpad/rockstar) |
| 05:29.25 | *** join/#storm midgetspy (~midgetspy@d75-159-12-204.abhsia.telus.net) |
| 06:19.44 | *** join/#storm jamesh (~james@canonical/launchpad/jamesh) |
| 07:08.43 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 10:32.04 | *** part/#storm bigdog (~scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 12:20.26 | *** join/#storm salgado (~salgado@canonical/launchpad/salgado) |
| 13:18.50 | *** join/#storm niemeyer_ (~niemeyer@189.74.206.84) |
| 13:21.32 | *** join/#storm fcorrea (~fcorrea@187.3.15.40) |
| 13:23.11 | *** join/#storm fcorrea (~fcorrea@187.3.15.40) |
| 14:20.20 | *** join/#storm rockstar (~rockstar@blackout.eventuallyanyway.com) |
| 14:20.32 | *** join/#storm rockstar (~rockstar@canonical/launchpad/rockstar) |
| 15:11.10 | *** join/#storm salgado (~salgado@canonical/launchpad/salgado) |
| 16:40.30 | rockstar | Hey storm folk. I seem to storm stuck right now querying a many-to-many relationship. I want to get all the A classes where a B instance is in A.bs, and A.bs is a many-to-many with B |
| 16:50.23 | jkakar | rockstar: On a call, be with you shortly. |
| 16:50.40 | rockstar | jkakar, ack |
| 17:32.46 | *** join/#storm artista_frustrad (~artista_f@201-24-239-233.ctame704.dsl.brasiltelecom.net.br) |
| 17:41.01 | rockstar | jkakar, really long phone call? |
| 17:42.41 | jkakar | rockstar: Yeah, still on it. :) |
| 17:42.47 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 17:42.53 | jkakar | rockstar: Some advice: what's the SQL you'd run to get the results you want? |
| 17:43.51 | rockstar | tries to remember SQL |
| 17:53.52 | jkakar | rockstar: Okay, here now. |
| 17:53.56 | jkakar | rockstar: Sorry for the delay. |
| 17:54.06 | rockstar | jkakar, no sweat. I found other things to do. |
| 17:54.20 | jkakar | rockstar: Usually, when I have a problem with a Storm query, it's because I don't know what SQL I want to run. |
| 17:54.41 | jkakar | rockstar: Do you want to select all A's that are related to more than one B? |
| 17:54.45 | rockstar | jkakar, well, it may also be launchpad's egregious abstraction from Storm, I'm not sure. |
| 17:54.54 | jkakar | rockstar: Could be. |
| 17:55.03 | rockstar | jkakar, so, I have a B, and I want all the As that have a relation to B. |
| 17:55.09 | jkakar | rockstar: I'm not familiar enough with Launchpad to comment though. |
| 17:55.30 | jkakar | rockstar: Do you have 3 tables, A, A_B_link and B? |
| 17:56.24 | rockstar | jkakar, I assume. The property on A is a CollectionField, from lazr.schema.fields |
| 17:56.35 | rockstar | Er, lazr.restful. |
| 17:57.09 | jkakar | rockstar: Okay, I don't know what a CollectionField is... |
| 17:57.10 | rockstar | There has to be a table there, but there's no class representation of that table |
| 17:57.16 | jkakar | That's a problem. :) |
| 17:57.19 | rockstar | jkakar, yeah, I'm trying to figure that out too. |
| 17:57.33 | jkakar | But anyway, you can create the class for the table if it's there, that's not hard. |
| 17:58.08 | rockstar | jkakar, that seems counterintuitive. |
| 17:58.30 | rockstar | jkakar, unless, of course, Storm requires something like that, in which case I'd want to tear my hair out. |
| 17:59.15 | jkakar | rockstar: You can probably work around that requirement (by using Columns and other magic), but the most straightforward way to do what you want is to create a class representing the link table. |
| 18:00.35 | rockstar | jkakar, okay. I need to step away from the computer for a bit and eat some food. I'll figure something out when I get back. |
| 18:02.32 | jkakar | rockstar: Okay. |
| 18:09.34 | jkakar | rockstar: Here's an (untested) example showing a few ways to do what you want: http://paste.ubuntu.com/410656/ |
| 18:11.11 | jkakar | rockstar: The nice thing about using a ReferenceSet, instead of a query, is that you get some built-in methods that can be handy: http://people.canonical.com/~jkakar/storm/storm.references.BoundReferenceSet.html |
| 18:11.53 | jkakar | rockstar: Actually, you get the same methods on the ResultSet returned by a Store.find call, but being able to access library.books can be more natural than need to run a query, or implement a Library.get_books method. |
| 18:12.07 | jkakar | It really depends on the API you want. |
| 18:59.10 | rockstar | jkakar, so I am using ReferenceSet at the core of it. |
| 18:59.36 | jkakar | rockstar: Cool, so you need one of the definitions I included in the paste. |
| 19:00.49 | jkakar | rockstar: You will need to define a class for the link table... though using storm.expr.Column("book_id", "library_book") might work if you don't want to bother with the extra class. |
| 19:01.04 | jkakar | I'm not sure if expressions are honoured there, though, you'll have to experiment. |
| 19:01.37 | jkakar | I'll step away for some food+break. Good luck. |
| 19:01.45 | rockstar | jkakar, thanks |
| 20:39.08 | *** join/#storm skrite99 (~skrite@108.103.231.55) |
| 21:58.41 | *** join/#storm skrite99 (~skrite@108.103.231.55) |
| 22:43.31 | *** join/#storm skrite99 (~skrite@108.103.231.55) |
| 23:04.16 | *** join/#storm skrite99 (~skrite@108.103.231.55) |