def put_gradual(self, addr_str, zipcode): self.cur.execute(''' select zipcode from gradual where addr_str = ?; ''', (addr_str,)) row = self.cur.fetchone() if row is None: stored_zipcode = None else: stored_zipcode = row[0] self.cur.execute('replace into gradual values (?, ?);', ( addr_str, Directory.get_common_part(stored_zipcode, zipcode), )) return self.cur.rowcount
def put_gradual(self, addr_str, zipcode): self.cur.execute( ''' select zipcode from gradual where addr_str = ?; ''', (addr_str, )) row = self.cur.fetchone() if row is None: stored_zipcode = None else: stored_zipcode = row[0] self.cur.execute('replace into gradual values (?, ?);', ( addr_str, Directory.get_common_part(stored_zipcode, zipcode), )) return self.cur.rowcount