version: 0.6beta1
I'm just trying to update a row in a table but can't figure out what
the heck is the problem. I'm attempting the following:
session.execute(
warehouse.session().query(WarehouseFile)\
.filter(WarehouseFile.warehouse_file_id == file_id)\
http://pastebin.ca/1266308
In the link above you will see some output and code.
Some questions I have:
1) Why are these queries taking on a magnitude of 10 times slower than
they should be?
2) Could it be the implementation I am using? If so what is
recommended for using the system as you see
but it
doesn't appear that many people attempt what I am.
On Nov 24, 10:29 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Nov 24, 2008, at 8:50 PM, TheShadow wrote:
http://pastebin.ca/1266308
In the link above you will see some output and code.
Some questions I have:
1) Why
All I need to be able to do is the following. (I don't need, can't
use, and/or don't want ORM)
query = 'SELECT col FROM table where col = :col'
params = {'col':1} # and/or params = [{'col':1},{'col':2}]
OR
query = 'INSERT INTO table(col1,col2) VALUES(:col1,col2)'
params = {'col1':1,'col2':2} #