Lines Matching refs:id

67 unset -nocomplain data i max_rowid todel n rec max1 id origres newres
83       id INTEGER PRIMARY KEY,
90     foreach {id u1 z u2} $rec break
91     db eval {INSERT INTO t1 VALUES($id,$u1,zeroblob($z),$u2)}
93   db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
111     set id [lindex $rec 0]
112     if {$id>$max1} {set max1 $id}
116     db eval "DELETE FROM t1 WHERE id IN ([join $todel ,])"
117     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
124   foreach id $todel {
125     set rec [list $id [random_uuid] \
131     set id [expr {$max_rowid+$j}]
132     lappend todel $id
133     set rec [list $id [random_uuid] \
145       foreach {id u1 z u2} $rec break
146       set s "INSERT INTO t1 VALUES($id,'$u1',zeroblob($z),'$u2');"
151     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
161           z = CASE WHEN id<$max_rowid
166     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
173     set s "DELETE FROM t1 WHERE id IN ([join $todel ,]);"
176     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
185           z = CASE WHEN id<$max1
190     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
198     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
205     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
215           z = CASE WHEN id<$max1
221           z = CASE WHEN id<$max1
225     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
230 unset -nocomplain data i max_rowid todel n rec max1 id origres newres