fb_cursor.execute(query) # fb_dc = dict_cursor(fb_cursor) for fb in fb_dc: # print "\nProcessing:" + fb['uc_name'] if fb['obstat']: warnings.warn(fb['fbid'] +" " + fb['uc_name'] + " is obsolete ! Not adding to fb_feature.owl.") else: if not fb_feature.knowsClass(fb['fbid']): # Only add class if not obsolete. fb_feature.addClass(fb['fbid']) tmp = re.sub("<up\>", "[",fb['uc_name']) uc_name = re.sub("<\/up>", "]", tmp) fb_feature.label(fb['fbid'], uc_name) if re.match('FBtp\d+', fb['fbid']): fb_feature.subClassOf(fb['fbid'], 'SO_0000796') elif re.match('FBti\d+', fb['fbid']): fb_feature.subClassOf(fb['fbid'], 'SO_0001218') elif re.match('FBgn\d+', fb['fbid']): fb_feature.subClassOf(fb['fbid'], 'SO_0000704') elif re.match('FBal\d+', fb['fbid']): fb_feature.subClassOf(fb['fbid'], 'SO_0001023') else: warnings.warn("Ignoring this, as doesn't look like an FB feature: %s." % fb['fbid']) continue time.sleep(0.1) # vfb_ms_conn.close()