Hi, I need to do an upsert in a database table. I need to insert a row
if it does not exist already and and update it if it does.
using python sqlite module I was writing the code as
code (python : curs holds the cursor to table ):
curs.execute("insert or ignore into table values(?,?)",(name_var,0))
curs.execute("update docs set freq=freq+1 where name ='"+name_var+
"'")
The table contains two columns : name (type text, primary key) and
freq (type integer). it name_var is a variable that holds the name to
query the database.
How do I achieve the same code in web2py? I tried db.executesql() but
am having problem with it because of the quotes involved.
Thank you.
