Re: [sqlalchemy] SQLite problem: column aliases with dot are stripped

2012-04-29 Thread Stefan Urbanek
On 28.4.2012, at 18:39, Michael Bayer wrote: On Apr 28, 2012, at 5:52 AM, Stefan Urbanek wrote: This is what I used as workaround [1]: # select is sqlalchemy.sql.expression.select() # each selected column was derived as column = table.c[reference].label(label_with_dot)

[sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
I can't find how to enable alembic support multiple databases. -- I like python! UliPad The Python Editor: http://code.google.com/p/ulipad/ UliWeb simple web framework: http://code.google.com/p/uliweb/ My Blog: http://hi.baidu.com/limodou -- You received this message because you are subscribed

Re: [sqlalchemy] SQLite problem: column aliases with dot are stripped

2012-04-29 Thread Michael Bayer
On Apr 29, 2012, at 4:06 AM, Stefan Urbanek wrote: On 28.4.2012, at 18:39, Michael Bayer wrote: On Apr 28, 2012, at 5:52 AM, Stefan Urbanek wrote: This is what I used as workaround [1]: # select is sqlalchemy.sql.expression.select() # each selected column was derived as

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread Michael Bayer
You would assemble a multi-database scheme of your choosing in env.py. If you do alembic init multidb you'll see an example of one. How env.py is organized depends greatly on the relationship of the databases to each other, that is, to what degree they are mirrors of each other versus

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer mike...@zzzcomputing.com wrote: You would assemble a multi-database scheme of your choosing in env.py.   If you do alembic init multidb you'll see an example of one.     How env.py is organized depends greatly on the relationship of the

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 10:56 PM, limodou limo...@gmail.com wrote: On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer mike...@zzzcomputing.com wrote: You would assemble a multi-database scheme of your choosing in env.py.   If you do alembic init multidb you'll see an example of one.     How

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread Michael Bayer
On Apr 29, 2012, at 10:56 AM, limodou wrote: On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer mike...@zzzcomputing.com wrote: You would assemble a multi-database scheme of your choosing in env.py. If you do alembic init multidb you'll see an example of one. How env.py is organized

Re: [sqlalchemy] multi table but single object

2012-04-29 Thread Michael Bayer
check out the examples for mapping to multiple tables at: http://docs.sqlalchemy.org/en/rel_0_7/orm/mapper_config.html#mapping-a-class-against-multiple-tables also if you wanted to make a class hierarchy of Table3(Table2), Table2(Table1), straight joined inheritance can work:

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 11:13 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Apr 29, 2012, at 10:56 AM, limodou wrote: On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer mike...@zzzcomputing.com wrote: You would assemble a multi-database scheme of your choosing in env.py.   If you do