Thanks for all the comments. Let me be a little more clear. The synchronization does not take place in real-time. Users with laptops with no Internet access make a few changes to their local copy of the database. When they get an Internet connection they manually indicate that they want to synchronize their local copy of the database with the server version, which can also be accessed directly when people have Internet access. The local laptops and the server exchange rows marked as "dirty" via exchanging pickled SA objects without knowing what column(s) in the objects are changed. There is a pretty simple system to handle conflicts when the same server and local row is marked as "dirty." Michael answered my question that there is no API that I missed that allows you to simply mark some or all attributes of an SA row object as dirty therefore writing to the database when you flush the session. That is really what I was looking for but since the current method of just reading one object's attributes and setting the corresponding object's attributes works given the low volume of data transferred, I can keep doing that. Again, thanks for everyone's thoughts on this.
------------------------------------------------------------------------- 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
