FrontPage
»
RelationalStorage
»
BrewingIdeas
»
UndoUnpopulatedRecords
def UndoUnpopulatedRecords(serial, transaction_id): do this sql: INSERT INTO zodb_data (z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv, z_dataserial) SELECT pre.z_oid, ?, rec.z_serial, "c", pre.z_datalen, rec.z_version, pre.z_nv, rec.z_pre FROM zodb_data rec, zodb_data pre WHERE rec.z_serial = ? AND pre.z_dataserial = '' AND rec.z_pre = pre.z_serial AND rec.z_oid = pre.z_oid
Self join!