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

Log in
Name

Password

 
 

History for InsertCommittedVersionAsNew

??changed:
-
These should be insert selects.
<pre>
 SELECT z_oid, %s, z_serial, 'c', 0, '', '',
              z_dataserial
              FROM %s
              WHERE z_version = %s
              AND z_status = 'c'
              AND z_dataserial != '' """ % (_sql_quote(s_serial),
                                            tables!['data'],
                                            _sql_quote(version))
</pre>
<br>
for each record there:

<pre>
 INSERT INTO %(data)s
                 (z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
                 z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?) 
</pre>
<br>
then (interbase has no if)
<pre>
 SELECT z_oid, %s, z_serial, 'c', 0, '', '',
              z_serial
              FROM %s
              WHERE z_version = %s
              AND z_status = 'c'
              AND z_data IS NOT NULL
              AND z_dataserial = '' """ % (_sql_quote(s_serial),
                                           tables!['data'],
                                           _sql_quote(version))
</pre>
<br>
for each record returned:
<br>
<pre>

 INSERT INTO %(data)s
                 (z_oid, z_serial, z_pre, z_status, z_datalen, z_version, z_nv,
                 z_dataserial) values (?, ?, ?, ?, ?, ?, ?, ?) 

</pre>