I have done the following
try:
db.table.insert(name = name_var, freq = 1 )
except:
db.executesql('update table set freq=freq+1 where name="%s";'
%name_var)
seems to be working fine. Any thoughts ??(if it could be improved)
On Oct 31, 11:11 pm, Niphlod <[email protected]> wrote:
> does db.executesql not fit ?
>
> Niphlod
>
> On 31 Ott, 18:01, siddharth <[email protected]> wrote:
>
> > 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.
>
>
