[sqlalchemy] Re: Adjacency List + Alternate Join Conditions == ???

2008-09-14 Thread GustaV
I was thinking about something like: session.reload( [tile0, tile1, tile2], 'neighbors' ) for example. That feature would be great because you don't necessary know what relation you will need later when you do the first query (eagerload is not enough) or in the case: class Tile(object):

[sqlalchemy] declarative_base and UNIQUE Constraint

2008-09-14 Thread GustaV
How do I create a unique constraint with the declarative plugin (latest version 0.5) ? both: __table_args__ = ( UniqueConstraint('region.x', 'region.y'), {'mysql_engine':'InnoDB'} ) __table_args__ = ( UniqueConstraint(x, y), {'mysql_engine':'InnoDB'} ) don't work. Thanks!

[sqlalchemy] Best Practices for ORM vs SQL in this context

2008-09-14 Thread Marcus Cavanaugh
I often find myself wanting to do something like this: for address in user.addresses: if address.street == 123 Elm Street: # there's an address from this street, so do something break else: # do nothing; no addresses from that street That could also be accomplished with

[sqlalchemy] Re: Adjacency List + Alternate Join Conditions == ???

2008-09-14 Thread Michael Bayer
On Sep 14, 2008, at 1:28 PM, GustaV wrote: I was thinking about something like: session.reload( [tile0, tile1, tile2], 'neighbors' ) for example. That feature would be great because you don't necessary know what relation you will need later when you do the first query (eagerload is not

Re: [Talk-de] construction=yes bitte nicht durch highway=construction ersetzen!!!

2008-09-14 Thread Garry
Ulf Lamping schrieb: Garry schrieb: Wichtig ist hierfür, dass die bereits erfassten Daten in den üblichen Anwendungen - insbesondere Garmin, Navipowm,.. - angezeigt werden, was mit highway=construction nicht funktioniert! Wir mappen nicht für die Renderer - ich kauf mir demnächst