object-relational mappers

Marco Mariani marco at sferacarta.com
Thu Apr 3 10:25:07 EDT 2008


Bruno Desthuilliers wrote:

>> A simple select query would be db.select('customers') or
>> db.select('customers', name='John').
>> But you can also resort to plain sql as follows: db.query('select *
>> from customers where name = "John"').
>>
>> Simple, effective and doesn't get in your way.
> 
> Seems nice too in another way.

And no different than using SQLAlchemy's sa.select() or 
engine.execute(), after all.

 > Is that part independant of the rest of the framework ? If so, I'll 
have to give it a try at least for admin
> scripts.

My admin scripts go through SQLAlchemy as well, I just have some issues 
with postgres' COPY statement -- but I don't know if the DBAPI is 
supposed to handle that.



More information about the Python-list mailing list