def get_score_in(low, high):
try:
conn = sqlite3.connect(db_file)
cursor = conn.cursor()
cursor.execute(r"select name from user where score >= ? and score <= ? order by score asc", (low, high))
values = cursor.fetchall()
finally:
cursor.close()
conn.close()
results = []
for i in values:
results.append(i[0])
return results
千羽王爵
def get_score_in(low, high): try: conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute(r"select name from user where score >= ? and score <= ? order by score asc", (low, high)) values = cursor.fetchall() finally: cursor.close() conn.close() results = [] for i in values: results.append(i[0]) return results