[sqlalchemy] Re: Come on, share your sqlalchemy powered sites with others.//Fwd: A tornado powered site to show any project powered sites(open source)

2010-08-23 Thread Stone Puzzle
It's official online now after two weeks beta testing. A bunch of sites already been submitted, come on and enjoy it. Below list some popular projects' sub-sites: http://sqlalchemy.poweredsites.org SQLAlchemy powered sites. http://ror.poweredsites.org http://ror.poweredsites.org/Ruby on Rails

[sqlalchemy] How to declare many-to-one in this example?

2010-08-23 Thread Freewind
I'm new to python(sqlalchemy), and I'm learning to build web site with pylons and sqlalchemy. I have a problem when I declare the relationship between models. I've tried it several hours, but failed. But I think it should be a basic question. I have two classes: User and Article, user can create

Re: [sqlalchemy] Re: Polymorphic across foreign key

2010-08-23 Thread Michael Bayer
On Aug 22, 2010, at 8:45 AM, Eduardo Robles Elvira wrote: On May 15 2008, 6:27 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 15, 2008, at 12:12 PM, J. Cliff Dyer wrote: How can I use this field for polymorphism? Is it possible? polymorphicdiscriminators are currently

Re: [sqlalchemy] How do I set the transaction isolation level in SQLAlchemy for PostgreSQL?

2010-08-23 Thread Michael Bayer
On Aug 22, 2010, at 10:44 PM, Mahmoud Abdelkader wrote: Hi Michael, Thanks for responding. Will there be any backward incompatibility issues with a SQLAlchemy upgrade to the tip? We're using SQLAlchemy in a rather large project. Thanks! Mahmoud If your app sticks to traditional

[sqlalchemy] DB tables, check exists before creation? duplicate and rename table in sqlalchemy?

2010-08-23 Thread keekychen.shared
Dear All, I have questions in coding my application using sqlalchemy on database tables. 1. how to create table if not exists in metadata.create_all(engine) I googled and fould this http://www.mail-archive.com/sqlalchemy-us...@lists.sourceforge.net/msg02121.html; but I found no keywords

Re: [sqlalchemy] DB tables, check exists before creation? duplicate and rename table in sqlalchemy?

2010-08-23 Thread Daniel Kluev
On Tue, Aug 24, 2010 at 2:04 AM, keekychen.shared keekychen.sha...@gmail.com wrote: Dear All, I have questions in coding my application using sqlalchemy on database tables. 1. how to create table if not exists in metadata.create_all(engine) I googled and fould this

Re: [sqlalchemy] How to declare many-to-one in this example?

2010-08-23 Thread Michael Bayer
On Aug 23, 2010, at 5:37 AM, Freewind wrote: I'm new to python(sqlalchemy), and I'm learning to build web site with pylons and sqlalchemy. I have a problem when I declare the relationship between models. I've tried it several hours, but failed. But I think it should be a basic question.

Re: [sqlalchemy] DB tables, check exists before creation? duplicate and rename table in sqlalchemy?

2010-08-23 Thread Michael Bayer
On Aug 23, 2010, at 11:04 AM, keekychen.shared wrote: Dear All, I have questions in coding my application using sqlalchemy on database tables. 2. how to duplicate a table with name in sqlalchemy? I posted a question in

[sqlalchemy] rollbacks on select

2010-08-23 Thread Tarek Ziadé
Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback after every select using the mysql default engine. These rollback are not really useful and eat 15% of the CPU time. Is this a normal behavior, part of the auto commit custom

Re: [sqlalchemy] rollbacks on select

2010-08-23 Thread Michael Bayer
Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback after every select using the mysql default engine. These rollback are not really

Re: [sqlalchemy] rollbacks on select

2010-08-23 Thread Tarek Ziadé
On Mon, Aug 23, 2010 at 5:48 PM, Michael Bayer mike...@zzzcomputing.com wrote: Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback

Re: [sqlalchemy] rollbacks on select

2010-08-23 Thread Tarek Ziadé
On Mon, Aug 23, 2010 at 5:53 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: On Mon, Aug 23, 2010 at 5:48 PM, Michael Bayer mike...@zzzcomputing.com wrote: Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run