This is correct but the problem is that one of the fields is supposed to be a date and it is not
On Jan 11, 5:16 am, Johann Spies <[email protected]> wrote: > I am trying to sanitise data from different sources programatically. > The following function is part of my effort: > > def artikel(datum,ti,wod_id,publ_id,di): > titel = ti.strip().upper() > if db(db.artikel.titel == titel).count() < 1: # Is titel > already in database? > artikel_id = db.artikel.insert(titel = titel, > publikasie_id = publ_id, > wos_id = wos_id, > datum = datum, > id_nr = di.strip().upper()) # > insert if not. > else: # get the id if it is already there > artikel_id = db(db.artikel.titel == titel).select()[0].id > return(artikel_id) > > It tries to determine whether there is already such a value for > 'titel'. If it is not already there, insert the record, else get the > id. > > But this function fails at the line after "else:" with: > > Traceback (most recent call last): > File "<console>", line 1, in <module> > File "/home/js/web2py/gluon/sql.py", line 2987, in select > return self.parse(db,rows,self.colnames) > File "/home/js/web2py/gluon/sql.py", line 3034, in parse > str(value)[:10].strip().split('-')] > ValueError: need more than 1 value to unpack > > What is the best way of doing this? > > Should I create a unique index on field "titel" and then insert with a > "try ... except" ? > > Regards > Johann
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
