Discuss / Python / 1

_Dvel

#1 Created at ... [Delete] [Delete and Lock User]
def get_score_in(low, high):
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()
        cursor.execute(r'select * from user where score>=? and score<=?', (low, high))
        values = cursor.fetchall()
        values.sort(key=lambda x:x[2])
        names = [v[1] for v in values]
        print(names)
        return names
    finally:
        cursor.close()
        conn.close()

  • 1

Reply