| 00:00.15 | *** join/#storm wallflower (n=wallflow@ip-205-246-113-216.pool.grokthis.net) |
| 00:23.55 | *** join/#storm bozzo (n=bozzo@195-86-253-195.dsl.easynet.nl) |
| 01:40.36 | radix | PenguinOfDoom: probably |
| 01:41.55 | radix | PenguinOfDoom: storm does make thorough use of descriptors |
| 03:07.16 | PenguinOfDoom | halp!! :( |
| 03:08.46 | PenguinOfDoom | If I have a table with IDs and Names, and also I have multiple tables that contain the same kind of IDs, and also other attributes, how do I find something by name? |
| 03:11.20 | PenguinOfDoom | I guess I need to get me some database education |
| 03:11.32 | PenguinOfDoom | here's an example! first table contains [(20, "Foo"), (30, "Foo")] -- those are different types of objects! the second table contains [(20, "awesome orange")] and the third table contains [(30, "awesome apple")]. How do I look up an Apple with the name "Foo"? |
| 03:14.12 | PenguinOfDoom | Oh, I suppose a separate name table is a bit daft |
| 03:14.15 | PenguinOfDoom | hm |
| 05:26.24 | jkakar | PenguinOfDoom: If the first table is for class Foo and the others for Orange and Apple you can do: |
| 05:26.43 | jkakar | tables = [Apple, Join(Apple.id == Foo.id)] |
| 05:27.09 | jkakar | store.using(tables).find(Apple, Foo.name == "Foo") |
| 05:28.53 | jkakar | Oops. |
| 05:28.56 | jkakar | That should be: |
| 05:29.03 | jkakar | store.using(*tables).find(...) |
| 05:50.16 | PenguinOfDoom | jkakar: The first table is for both Oranges and Apples. |
| 05:50.27 | PenguinOfDoom | because it's silly and I'll stop doing it |
| 05:59.06 | *** join/#storm michelp (n=michelp@69-30-72-119.dq1sf.easystreet.com) |
| 08:26.20 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 08:41.52 | *** join/#storm jukart_ (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 09:11.31 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 09:40.06 | *** join/#storm bozzo (n=bozzo@195-86-253-195.dsl.easynet.nl) |
| 10:26.28 | *** join/#storm ubot3 (n=ubot3@unaffiliated/nalioth/bot/ubot3) |
| 11:47.32 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 13:11.21 | *** join/#storm bozzo (n=bozzo@195-86-253-195.dsl.easynet.nl) |
| 14:17.30 | *** join/#storm lymxz (n=lymxz@123.116.114.117) |
| 14:19.22 | *** part/#storm lymxz (n=lymxz@123.116.114.117) |
| 15:21.16 | aa_ | hi, I am having slight issues with References on superclasses |
| 15:22.05 | aa_ | in that if I have a simple query with one of the inherited attributes being either the foreign key, or reference field, the expr tries to compile the superclass |
| 15:26.24 | aa_ | superclasses don't need tables do they? |
| 15:29.57 | aa_ | oh man, it works on a simple use-case |
| 15:33.28 | aa_ | ok, I see, you can't select on a Reference of a superclass |
| 16:00.51 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 18:00.38 | *** join/#storm jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 18:00.38 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.11 released! || Review branches: https://bugs.launchpad.net/storm/+bugs?field.tag=review |
| 18:47.43 | *** join/#storm dobee (n=dobeee@81-223-53-162.dornbirn.xdsl-line.inode.at) |
| 20:10.56 | *** join/#storm niemeyer (n=niemeyer@201-11-39-190.ctame705.dsl.brasiltelecom.net.br) |