Project Page Download
#set ($cols = ["col1", "col2"])
#set ($vals = ["val1", "val2"])
<br>
cols = $cols<br>
<br>
vals = $vals<br>
<br>
#set ($insert = ${plugin.database.insert("test", $cols, $vals)})
insert = $insert<br>
<br>
#set ($insert = ${plugin.database.insert("test", $cols, $vals)})
insert = $insert <br>
<br>
${vals.set(1, "val3")}
${plugin.database.update("test", $insert, $cols, $vals)}
#set ($query = ${plugin.database.createQuery("test")})
query = $query
<br>
#set ($query = ${plugin.database.addFilter($query, "col2", "==", "val3")})
query = $query
<br>
#set ($res = ${plugin.database.selectRows($cols, $query)})
##res = $res <br>
#foreach ($row in $res)
row = $row <br>
#foreach ($col in $row)
col = $col <br>
#end
#end
<br>
#set ($keys = ${plugin.database.selectKeys($query)})
#foreach ($key in $keys)
key = $key
#end
${plugin.database.delete("test", $keys)}
<br>