Public Sub AddItem(item As Item)
lock.WriteLock
Try
Dim lastId As String = sql.ExecQuerySingleResult2("SELECT max(id) FROM data WHERE user = ?", Array(item.UserField))
If lastId = Null Then lastId = 0
Dim id As Long = lastId + 1
If item.TimeField < DateTime.Now - 3 * DateTime.TicksPerMinute Then
Log("checking old record")
'this is an old record. Maybe there is a newer one...
Dim rs As ResultSet = sql.ExecQuery2("SELECT time, value FROM data WHERE user = ? AND key = ?", Array(item.UserField, item.KeyField))
If rs.NextRow Then
Dim currentTime As Long = rs.GetLong("time")
If currentTime > item.TimeField Then
Log("Old record discarded.")
item.ValueField = rs.GetBlob("value")
item.TimeField = currentTime
End If
End If
rs.Close
End If
sql.ExecNonQuery2("INSERT OR REPLACE INTO data VALUES (?, ?, ?, ?, ?)", _
Array (item.UserField, item.KeyField, item.ValueField, id, Min(item.TimeField, DateTime.Now)))
Log("UserField = " & item.UserField)
Log("KeyField = " & item.KeyField)
Log("Time Tick = " & Min(item.TimeField, DateTime.Now))
Dim mybyte() As Byte = item.ValueField
For i = 0 To mybyte.Length - 1
Log("mybyte(" & i & ") = " & mybyte(i))
Next
Catch
Log(LastException)
End Try
lock.WriteRelease
End Sub