I have a tree structure
Root
|
+--Area
| |
| +--SubArea
| | |
| | +--Item
| | |
| | +--Item
| |
| +--SubArea
| |
| +--Item
| |
| +--Item
|
+--Area
|
+--SubArea
| |
| +--Item
| |
| +--Item
|
+--SubArea
|
+--Item
|
+--Item
The tree structure corresponds to slqalchemy db tables `areas`,
`subareas` and `items`.
Something like this:
mapper(Area, areas_table, properties={
'subareas': relationship(SubArea, backref='parent'),
})
mapper(SubArea, subareas__table, properties={
'items': relationship(Item, backref='parent'),
})
mapper(Item, items_table)
so each Area instance will have a `subareas` list and each SubArea
will have a `items` list,
also I easyly get a backref `parent` from Item to parent SubArea and
from
SubArea to parent Area.
But this won't be for Root: it will not have a `areas` list in Root
nor its areas will have a parent reference to Root.
The quick-and-dirty solution is to do this in Root:
self.areas = query(Area).all()
for area in self.areas:
area.parent = self
But it won't be the same thing as sqlalchemy `relationship` attributes
so:
are there alternative solutions more sqlalchemy-like?
Any tip appreciated!
Thank you for your support
Greetings
neurino
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
