def get_sid(conn, tvdbid): with conn: c = conn.cursor() c.execute(u'''SELECT sid FROM sids WHERE tvdbid = ?''', (tvdbid,)) result = c.fetchone() if not result: # not in db, we have to get it from bierdopje sid = bierdopje.get_show_id(tvdbid) if sid: c.execute(u'''INSERT INTO sids VALUES (?, ?)''', (tvdbid, sid)) result = sid else: result = result[0] return result
def update_tvdbids(sids, tvdbid): if tvdbid not in sids: sid = bierdopje.get_show_id(tvdbid) sids[tvdbid] = sid return sids