[sqlalchemy] Re: Mapper Issue Upgrading to 0.4.5

2008-04-15 Thread Koen Bok
For anyone who needs this too, there is a small typo in the above example. It should be: mapper(PGUser, pg_user, properties={ 'groups': relation(PGGroup, viewonly=True, primaryjoin=pg_user.c.usesysid==func.any(pg_group.c.grolist),

[sqlalchemy] Re: Extension proposal

2008-04-15 Thread Paul Johnston
Hi, the function so far seems pretty use-case specific. (only works in one direction, is hardcoded to the obj.mapper convention, sort of Ok, fair enough. It looks like Elixir will accept this, and Jonathan also made the observation that my approach is one-way. For the time being, I've updated

[sqlalchemy] Problem with the session of SQLAlchemy

2008-04-15 Thread Chugo
Hello, I am setting the SQLAlchemy to work with meetings, but not the rollback, no mistake, it keeps the data bb.dd. As if there were no rollback in the code. We show the example: model.py from elixir import * from turbogears.database import metadata options_defaults['autosetup'] = False

[sqlalchemy] sqlalchemy migration/schema creation

2008-04-15 Thread Lukasz Szybalski
Hello, Is there maybe a feature in sqlalchemy that would allow me to autoload table from one database, and move it over to another database? 1. I would like to print data structure from autoload table. (then copy and paste it into new file and use it to create new table)(without typing every