You are not logged in Log in Join
You are here: Home » Members » jim » ZODB » UndoUnpopulatedRecords » wikipage_view

Log in
Name

Password

 
 
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!