[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-04 Thread az
one question to sqlalchemy experts: is it possible to reduce the number of queries? i noticed that objects are reloaded every time insert/update is done even though in many cases the session already contains the data (and it would be ok just to check that insert/update operations on the db

[sqlalchemy] Re: Two foreignkey's to the same table, rendering a join error.

2008-10-04 Thread Jorge Vargas
hi I finally made this work. Thanks for the doc link although it wasn't clear enough. As it's using the classical syntax. But the last paragraph of that section gave me a good hint. I have extracted the relevant parts of my model and I got to something that could become a FAQ item or a tutorial

[sqlalchemy] Re: Cannot adapt for insert

2008-10-04 Thread Sean Davis
On Oct 3, 10:58 pm, Sean Davis [EMAIL PROTECTED] wrote: ProgrammingError: (ProgrammingError) can't adapt 'INSERT INTO runbrowser_image (id, nobj, focusmetric, focusuniformity, choffset_x, choffset_y, blu, flu, int_min, int_mean, int_stdev, int_max, int_median, int_q87, nse_min, nse_mean,