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
