[sqlalchemy] Re: Executing a PostgreSQL Function

2009-04-26 Thread Eric
Thanks! I owe you one. On 26 Apr, 00:05, Michael Bayer wrote: > the "func" construct described in the documentation is the usual way   > to render any SQL function, such as   > sess.execute(func.sp_add_tag(user.id, self.id, value.lower())) > > On Apr 25, 2009, at 11:16 PM, Eric wrote: > > > > >

[sqlalchemy] Re: Create table from declarative class definition.

2009-04-26 Thread Mike Conley
Your metadata has no knowledge of the table definition. Declarative uses a metadata instance that is a member of the Base class. Move the declaration of Base before the class definition, and either (1) attach your metadata to Base metadata = MetaData() Base = declarative_base(metadata=metadata) c

[sqlalchemy] Re: Revers Dialect - SQL Interpreter

2009-04-26 Thread Jarrod Chesney
Thank you Lord Michael On Apr 26, 2:32 am, Michael Bayer wrote: > this just came out recently > > http://code.google.com/p/python-sqlparse/ > > On Apr 24, 2009, at 9:36 PM, Jarrod Chesney wrote: > > > > > Hi all again. > > > I have a program that has a UI and allows the user to do some data or