[sqlalchemy] attempting something like a bulk insert ignore

2009-10-21 Thread strattonbrazil
From what I've read of sqlalchemy, I originally wanted to have a main table with one attribute foreign keyed to another table's autoincremented integer primary key userId and a userName. I thought I could join the tables together and set that as the mapper. The save every object in my session.

[sqlalchemy] purpose of class_mapper

2009-10-19 Thread strattonbrazil
What is the purpose of class_mapper? I can't find it in the .4 docs for the tutorials I'm looking at, yet when I don't call it as https://svn.enthought.com/svn/enthought/sandbox/EnvisageSQLAlchemy/enthought/sqlalchemy/has_traits_orm.py notes, I get a AttributeError: #

[sqlalchemy] large/fast inserts

2009-10-16 Thread strattonbrazil
I'm trying to setup fast insertions using sqlalchemy/sqlite and it seems to be taking an unnecessarily long amount of time to do many of the inserts. It looks like the main call that inserts into a few tables takes about 1-2 seconds each for the first few calls, but then drops down to around