[sqlalchemy] Re: Logging facilities of SQLAlchemy

2009-06-13 Thread Anton Gritsay
unfortunately the logging module included with Python adds significant performance overhead even if no handlers are configured.   We would like to be able to have fine-grained logging available in our library, but at the same time when the logging is disabled for significant latency to not

[sqlalchemy] filtering/ordering with composite columns

2009-06-13 Thread Scott Torborg
Sorry, for the stupid question, but I'm out of coffee. When using a composite column type, how can I use the individual columns for filtering and ordering operations? Based off the example from the ORM docs: http://gist.github.com/129457 What if I want to order by the x values of the

[sqlalchemy] Re: filtering/ordering with composite columns

2009-06-13 Thread Michael Bayer
I think you have to use the table.c collection for that. SQLA doesn't add any instrumentation to the composite class itself (i.e. which would make Vertex.start into something special).You can go through the effort to add descriptors to Vertex yourself, however and then you'd be able