[sqlalchemy] Inserting Entry Fastest way

2013-03-11 Thread Arkilic, Arman
Hi, I am working on a database design that I am required to use lots of tables with one-to-many relationship. As a consequence of the design, I need to insert thousands of entries. I tried session.add(), session.merge, however none of them is fast enough for me to meet the requirements. I was

[sqlalchemy] Joining Algorithmically

2013-02-26 Thread Arkilic, Arman
Hi, I have four tables that I would like to join algorithmically. Element with element_prop, elementprop with element_typeprop in one direction and element with element_type in the other. I would like to do this in one line as I am concerned about the number queries must be minimal given I am

[sqlalchemy] Many to One using Different Modules

2013-02-15 Thread Arkilic, Arman
Hi, I am quite new to sqlalchemy. I am trying to implement a many-to-one relationship between classes in different modules. I was able to get this to work when classes are inside the same module however when I put the classes in different modules I get import errors. I made sure I used strings