[sqlalchemy] Declarative, single table inheritance and column type override

2009-12-21 Thread Serge Koval
Hello, I'm trying to override column type in a single-table inheritance, using declarative syntax and a bit stuck. Is it possible at all? Sample code: class Person(DeclarativeBase): id = Column(Integer, primary_key=True) test = Column(Integer, unique=True) class Engineer(Person):

[sqlalchemy] Re: Declarative, single table inheritance and column type override

2009-12-21 Thread Sergey Koval
Sorry for misleading question. I found the problem and it was related to the index management. Here's sample: ... class Person(DeclarativeBase): id = Column(Integer, primary_key=True) test = Column(Integer, index=True, unique=True) ... and another file: from test import Person class

Re: [sqlalchemy] Expressing UPDATE...SET column = column + 1

2009-12-21 Thread Igor Katson
Alex Brasetvik wrote: On 12/20/09 13:31 , Igor Katson wrote: I want to increment a column by 1 with UPDATE table SET column = column + 1 WHERE id = %(id)s, This is covered here: http://www.sqlalchemy.org/docs/06/sqlexpression.html however, when writing instance.column += 1 in python,

[sqlalchemy] Re: Multiple table query ?

2009-12-21 Thread gsandorx
Uff, sorry, the word-wrap destroyed my schema :( Sandor -- 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] injecting explain analyze into ORM queries?

2009-12-21 Thread kris
Is it possible to turn on explain analyze during query execution.. I have some slow queries and it would be very useful if we could simply enable analysis at runtime. Thanks, Kris -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this