sysbench测试oracle自定义lua以使用绑定变量

pathtest = string.match(test,"(.*/)") or ""

dofile(pathtest .. "common.lua")


function thread_init(thread_id)
   local table_name
   set_vars()
   table_name = "equ_run_data"
   stmt = db_prepare("UPDATE ".. table_name .." SET col10=(substr((dbms_random.value),1,11)),col24=(substr((dbms_random.value),11)) WHERE eid= to_number(:x) and 'a' = :y")
   params = {}
   params[1] = '123'
   params[2] = 'a'
   db_bind_param(stmt,params)
end

function event(thread_id)
   local table_name
   params[1] = string.format("%d",sb_rand(1,oltp_table_size))
   params[2] = 'a'
   db_execute(stmt)
   db_query('COMMIT')
end

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!