[sqlalchemy] Re: Modelling connected trees

2008-01-01 Thread Andreas Jung
--On 30. Dezember 2007 18:02:13 -0500 Michael Bayer [EMAIL PROTECTED] wrote: I am using this model since some years for the application (hand- made Python code/SQL queries) but now I want to adopt it to SA. The basic question is how I would extend the configuration for the

[sqlalchemy] sync tables/columns

2008-01-01 Thread braydon fuller
Hello, Is there a way to use SQLAlchemy to update my already created database tables, so that if I were to take: audio_table = Table('objects_audio', metadata, Column('id', Integer, primary_key=True), Column('oid',Integer, ForeignKey(objects.oid)), Column('src', String(1000)) ) and

[sqlalchemy] Re: Execute query without a mapper

2008-01-01 Thread Alexandre da Silva
http://www.sqlalchemy.org/docs/04/sqlexpression.html yes, I've already been read that, but I am using TurboGears and using session if you mean that youd like to execute using the Session itself, use the execute() method on Session and you probably want to bind your Session to the engine

[sqlalchemy] Re: Execute query without a mapper

2008-01-01 Thread Michael Bayer
On Jan 1, 2008, at 11:38 AM, Alexandre da Silva wrote: http://www.sqlalchemy.org/docs/04/sqlexpression.html yes, I've already been read that, but I am using TurboGears and using session if you mean that youd like to execute using the Session itself, use the execute() method on Session

[sqlalchemy] [Postgres/SA 0.3.X] Support for arrays?

2008-01-01 Thread Andreas Jung
I have a PG table containing a row tools varchar(256)[][] that stores a list of tuples ('HI1234', 'somestring'). Setting the tools property on Python level leads to bad SQL code: ProgrammingError) Fehler »syntax error« bei »,« at character 52 'UPDATE hierarchies SET tools=%(tools)s WHERE