Ahhhh, deferred (new to me), thanks! in sqlalchemy/test/orm/sharding/test_shard.py:
mapper(WeatherLocation, weather_locations, properties={ 'reports':relation(Report, backref='location'), 'city': deferred(weather_locations.c.city), }) When I comment out the deferred property, it behaves as I would suspect (one query_chooser call). Ok, that answers Question #1. Question #2 similar, but w/ session.add(). I'll send a new email for Question #2. Thanks, --diana On Mon, Jan 11, 2010 at 3:25 PM, Michael Bayer <mike...@zzzcomputing.com> wrote: > > of course the details of the mapping might say something totally different > (i.e. deferred(), joined table inhertance, etc.)
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.