Hello, I am new to sqlalchemy, curious about approach to save modified data back to database. I have a program which displays grid, user may edit the cells. Fast solution may be to clear the table and then re-insert all rows in one transaction; Second is to loop (at start) over all rows adding them with session.query to the python list, and at the end just do flush(); Third is to mark edited rows as modified and session.query only those which were changed, then flush(); etc There are a lot of ways doing that, so my question is, how do you guys usually do such job?
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
