def _get_metadata_id(self, key, value): # normalize key, value key, value = document.normalize(key), document.normalize(value) ret = self.cursor.execute("SELECT id FROM metadata_dict WHERE metadata_key = ? AND metadata_value = ?", (key, value)).fetchone() return ret[0] if ret != None else None
def _get_or_create_metadata_id(self, key, value): # normalize key, value key, value = document.normalize(key), document.normalize(value) ret = self.cursor.execute("SELECT id FROM metadata_dict WHERE metadata_key = ? AND metadata_value = ?", (key, value)).fetchone() if ret != None: return ret[0] else: return self.cursor.execute("INSERT INTO metadata_dict (metadata_key, metadata_value) VALUES (?,?)", (key, value)).lastrowid