query = self.SELECT_MULTIPLE % ', '.join([self.IN_MATCH] * len(values[index: index + batch_size]))_
SELECT_MULTIPLE = f"""
SELECT HEX(`{FIELD_HASH}`), `{FIELD_SONG_ID}`, `{FIELD_OFFSET}`
FROM `{FINGERPRINTS_TABLENAME}`
WHERE '{FIELD_HASH}' IN (%s);
"""
IN_MATCH = f"UNHEX(%s)"
其中 SELECT_MULTIPLE , IN_MATCH是数据库相关语句,values是一个数组,batch_size是数组模块大小。