row = db.postcode_cache(postcode=postcode) if not row: db.postcode_cache.insert(postcode=postcode,nearset=nearest) elif not row.nearest: row.update_record(nearset=nearest) else: pass # do nothing
On Oct 10, 8:22 am, Chris Rowson <christopherrow...@gmail.com> wrote: > Hi list, > > I have a database table which looks like this: > > postcode_cache > ------------------------ > postcode (UNIQUE) > lat > lon > nearest > > I want to test first whether or not a record exists for 'postcode' and > if a record does exist, I want to check whether the 'nearest' field > contains any data. > > I've tried this: > > if db(db.postcode_cache.postcode==postcode).select().first()==None: > create_a_new_postcode_record() > > elif > db(db.postcode_cache.postcode==postcode).select(db.postcode_cache.nearest)= > =None: > populate_the_nearest_field() > > else: > nothing_to_do() > > And while the check to establish whether or not a record exists seems > to work, the check to see whether or not the 'nearest' field within > the record is populated doesn't seem to work. > > Can anyone tell me what I'm doing wrong please? > > Thank you, > > Chris
