| 03:53.25 | *** join/#storm stub (~stub@125.24.135.107.adsl.dynamic.totbb.net) |
| 03:53.25 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 07:34.23 | *** join/#storm esteve (~quassel@cli-5b7ee22f.bcn.adamo.es) |
| 08:53.42 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 09:29.50 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 13:51.44 | *** join/#storm danilos (~danilo@cable-178-148-38-107.dynamic.sbb.rs) |
| 13:51.44 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 15:00.58 | *** join/#storm webmaven (~webmaven@50-0-90-172.dsl.dynamic.sonic.net) |
| 15:11.24 | *** join/#storm eserra (~eserra@88.149.230.232) |
| 15:12.33 | eserra | Hi guys, I need to execute a multiple join on the same table with Storm but I cannot figure out how |
| 15:13.14 | jkakar | eserra: You can specify simple JOINs directly... |
| 15:13.43 | jkakar | eserra: As in, result = store.find(Thing, Thing.id == Something.thing_id, Thing.id == AnotherThing.thing_id). |
| 15:13.56 | jkakar | eserra: You can also use store.using(...) to pass explicit Join expressions. |
| 15:14.12 | jkakar | eserra: https://storm.canonical.com/Tutorial#Joins |
| 15:14.17 | jkakar | That has more information about it. |
| 15:14.18 | eserra | jkakar: thanks, but I need to use the same table multiple times, let me paste you the SQL |
| 15:14.40 | eserra | SELECT u1.nickname, fp.name, u2.nickname FROM users u1 LEFT JOIN facebook_users_pages fup1 ON u1.id = fup1.user_id LEFT JOIN facebook_users_pages fup2 ON fup1.page_id = fup2.page_id LEFT JOIN users u2 ON fup2.user_id = u2.id LEFT JOIN facebook_pages fp ON fup1.page_id = fp.id WHERE u1.id = 35562 AND u2.id = 35556; |
| 15:15.21 | eserra | I store in my database facebook pages liked by our users and I need to find common facebook pages between users |
| 15:15.46 | eserra | so the table facebook_users_pages is used twice in the query, with 2 different aliases |
| 15:16.10 | eserra | and so is the users table |
| 15:20.01 | eserra | jkakar: I was lookig for a way to specify table aliases, but I cannot find it |
| 15:28.53 | jkakar | eserra: Ah, okay, you can do it with ClassAlias. |
| 15:29.15 | jkakar | eserra: https://storm.canonical.com/Tutorial#Aliases |
| 15:33.21 | eserra | jkakar: Thanks, I really missed that part of the documentation |
| 15:49.10 | jkakar | eserra: np! |
| 17:56.08 | *** join/#storm webmaven (~webmaven@97.65.119.2) |
| 18:02.42 | *** join/#storm jdobrien (~john@50-88-19-25.res.bhn.net) |
| 21:37.07 | *** join/#storm artista_frustrad (~artista_f@187.6.155.246) |