Discuss / Python / 不会SQL,强行写出来了,看完评论心好累

不会SQL,强行写出来了,看完评论心好累

Topic source
    conn = sqlite3.connect(db_file)
    cursor = conn.cursor()
    cursor.execute('select * from user')
    values = cursor.fetchall()
    cursor.close()
    conn.close()
    name = []
    def by_score(t):
        for i in t:
            if isinstance(i,int):
                return(i)
    L = sorted(values, key=by_score)
    for i in range(len(L)):
        if isinstance(i,int) and low <= L[i][2] <= high:
            name.append(L[i][1])
    return name

  • 1

Reply