it feels very row-level to me; i.e. use timestamp and version ID columns in the tables, pickle straight rowsets, then when synchronizing just loop through all tables, grab all the rows where timestamp < last sync time and then work out the version ids. Id use the ORM to handle the app outside of the synchronization step, including to save version ids and timestamps (both of which are supported by SA). but the sync step i would do outside of the ORM.
On Jul 12, 2006, at 5:31 PM, Steve Zatz wrote: > 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
