[sqlalchemy] Re: SQLAlchemy 0.5.5 MySQL Issue

2009-11-27 Thread gizli
I am not sure about the storage engine but here goes: mysql> status -- mysql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline 5.2 the mysql-python version is MySQL_python-1.2.3c1 On Nov 26, 11:47 pm, Alexandre Conrad wrote: > 2009/11/27 gizli : > > > With mysql

Re: [sqlalchemy] Mapper on several columns only (multiple column_property)

2009-11-27 Thread Michael Bayer
naktinis wrote: > What is the best way to map several columns from one table to another > table? Let's say I have two classes: LargeComplicatedClass and > AnotherClass. > > LargeComplicatedClass which is has a lot of eager loads and columns > with a lot of data, which is expensive to query. > > I a

[sqlalchemy] Functions on results of subquery question

2009-11-27 Thread Oliver Beattie
Hey there, I'm probably missing something here, but no matter what I try, I can't seem to find a way to translate this query into SQLAlchemy code: SELECT AVG(sub.average) FROM ( SELECT AVG(feedback.overall_rating) AS average FROM feedback INNER JOIN listings ON fee

[sqlalchemy] Mapper on several columns only (multiple column_property)

2009-11-27 Thread naktinis
What is the best way to map several columns from one table to another table? Let's say I have two classes: LargeComplicatedClass and AnotherClass. LargeComplicatedClass which is has a lot of eager loads and columns with a lot of data, which is expensive to query. I also have a AnotherClass to whi