sql update
parse the log into dict