| 00:00.24 | *** join/#storm _mup_ (~mup@li37-90.members.linode.com) |
| 01:15.32 | *** join/#storm yosafbridge (~yosafbrid@li125-242.members.linode.com) |
| 06:31.32 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 07:22.50 | *** join/#storm stub1 (~stub@125.24.128.248.adsl.dynamic.totbb.net) |
| 07:22.57 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 07:47.41 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 07:47.53 | *** join/#storm stub1 (~stub@125.24.128.248.adsl.dynamic.totbb.net) |
| 07:47.54 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 08:13.47 | *** join/#storm bigjools (~quassel@82-71-93-254.dsl.in-addr.zen.co.uk) |
| 08:13.47 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
| 09:27.40 | *** join/#storm gggirl (~gggirl@212-198-248-35.rev.numericable.fr) |
| 10:29.56 | *** join/#storm jkakar (~jkakar@236.Red-79-158-231.staticIP.rima-tde.net) |
| 11:22.03 | *** join/#storm jdobrien (~john@50-88-19-25.res.bhn.net) |
| 11:23.07 | jdobrien | IIRC, there is a way to automatically return Reference properties when getting a storm object. Does anyone remember how to do this? |
| 11:24.53 | jkakar | jdobrien: result = store.find((SomeClass, AnotherClass), SomeClass.id == AnotherClass.some_class_id); for some_class, another_class in result: ... |
| 11:25.10 | jdobrien | jkakar, yeah Im familiar with that. |
| 11:25.45 | jdobrien | jkakar, what I was thinking more like when getting SomeClass, the SomeClass.anotherclass ReferenceProperty is already there |
| 11:25.59 | jdobrien | jkakar, without another db hit |
| 11:26.06 | jkakar | jdobrien: Ahhh, right. Eager loading or prefetching or whatever you want to call it. |
| 11:26.15 | jdobrien | yeah that's the fancy wording :) |
| 11:26.19 | jkakar | jdobrien: We don't have native support for that in Storm yet. |
| 11:26.24 | jdobrien | ok |
| 11:26.42 | jkakar | jdobrien: The Launchpad guys have a thing... a ResultSet wrapper that make it possible to do prefetching I think. |
| 11:26.52 | jdobrien | jkakar, yeah |
| 11:26.55 | jkakar | jdobrien: You might want to ask them about it... I can't remember exactly what it's called. |
| 11:27.51 | jdobrien | jkakar, thanks |
| 11:27.57 | jkakar | jdobrien: Anytime. :) |
| 11:54.44 | _mup_ | storm/cache-compile r399 committed by thomas@canonical.com |
| 11:54.44 | _mup_ | Add tests for compile_cache value |
| 12:32.26 | *** join/#storm danilo_ (~danilo@static-213-198-236-193.adsl.eunet.rs) |
| 12:40.44 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 12:41.05 | *** join/#storm danilo_ (~danilo@cable-178-148-38-107.dynamic.sbb.rs) |
| 13:29.47 | *** join/#storm niemeyer (~niemeyer@200-102-220-163.pltce701.dsl.brasiltelecom.net.br) |
| 14:10.20 | *** join/#storm magmatt (~Matt@63-235-131-194.dia.static.qwest.net) |
| 14:14.35 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 14:23.26 | *** join/#storm jkakar (~jkakar@116.Red-88-17-131.dynamicIP.rima-tde.net) |
| 14:43.23 | *** join/#storm lakin (~lakin@S010600265af23ae6.cg.shawcable.net) |
| 14:47.38 | *** join/#storm jkakar (~jkakar@210.Red-83-32-71.dynamicIP.rima-tde.net) |
| 15:19.11 | *** join/#storm florianf (~florianf@e179015089.adsl.alicedsl.de) |
| 15:24.55 | *** join/#storm jkakar_ (~jkakar@210.Red-83-32-71.dynamicIP.rima-tde.net) |
| 15:26.07 | florianf | Hi there! I have a question about many-to-many-relations: Is there a simple way to store extra information in the reference table, something like: employee_id Int(), company_id Int(), year_of_employment Int(). If so, how can this data be accessed/updated? Thanks for every answer, I couldn't find one in the docs⦠|
| 15:31.40 | therve | florianf, there is no simple way, no |
| 15:31.50 | therve | you can create property on your objects to access it, probably |
| 15:32.06 | therve | it depends on the API you want to have really |
| 15:33.25 | florianf | therve: so i figured⦠I thought about adding a primary key to the reference table using the relationship itself as a "model" |
| 15:34.30 | magmatt | florianf: so you have ClassA, ClassB and ClassJoinAB? |
| 15:34.41 | therve | so, I guess you have Company.employees = ReferenceSet() |
| 15:35.10 | therve | you can do Company.get_employee_year(employee) |
| 15:35.21 | therve | or Employee.get_company_year(company) |
| 15:35.28 | therve | which would query the table |
| 15:38.34 | florianf | right. so i would have to implement get_company_year as a method of the employee class using raw SQL, right? |
| 15:39.56 | therve | no you don't |
| 15:40.05 | magmatt | florianf: or you could have a ReferenceSet on the Employee to the join class |
| 15:41.20 | florianf | therve: that sounds like a nice way to go! |
| 15:43.12 | florianf | therve: thank you a lot for your help! |
| 15:43.23 | therve | you're welcome! |
| 15:45.16 | magmatt | therve, florianf: I missed it... what would be inside Company.get_employee_year |
| 15:45.17 | magmatt | http://paste.pocoo.org/show/463686/ |
| 15:46.32 | therve | store.find(EmployeeCompany, employee_id=employee.id, company_id=self.id).one() |
| 15:46.36 | therve | something like that |
| 15:46.51 | magmatt | okay |
| 15:48.03 | florianf | magmatt, therve: looks pretty good to me! so once again: thank you both! |
| 15:48.18 | jkakar | :) |
| 16:00.58 | *** join/#storm florianf (~florianf@e179015089.adsl.alicedsl.de) |
| 16:25.46 | *** join/#storm jkakar (~jkakar@236.Red-79-158-231.staticIP.rima-tde.net) |
| 16:26.43 | *** join/#storm lakin (~lakin@S0106001ff3444dea.cg.shawcable.net) |
| 16:58.37 | *** join/#storm lakin (~lakin@S0106001ff3444dea.cg.shawcable.net) |
| 17:09.44 | *** part/#storm florianf (~florianf@e179015089.adsl.alicedsl.de) |
| 17:19.10 | *** join/#storm asch (~asch@bzq-84-111-36-40.red.bezeqint.net) |
| 17:21.43 | *** join/#storm lakin (~lakin@S0106001ff3444dea.cg.shawcable.net) |
| 17:23.15 | asch | hello, everybody |
| 17:23.42 | therve | hi |
| 17:25.37 | *** part/#storm asch (~asch@bzq-84-111-36-40.red.bezeqint.net) |
| 19:14.11 | *** join/#storm lakin (~lakin@S0106000625f6ffa5.cg.shawcable.net) |
| 19:30.51 | *** join/#storm lakin (~lakin@S0106000625f6ffa5.cg.shawcable.net) |
| 20:43.53 | *** join/#storm rohitmobme (~rohitmobm@123.237.135.228) |
| 20:44.28 | rohitmobme | hii can i do "select * from table into outfile """ in storm |
| 20:44.52 | rohitmobme | except using exec |