代码如下
def get_score_in(low, high): con=sqlite3.connect(db_file) cursor=con.cursor() cursor.execute('select * from user where score>=? and score<=?',(low,high)) results=[x[1] for x in cursor.fetchall()] print(results) cursor.close() con.close() return results 这是运行结果 ['Adam'] ['Bart', 'Lisa'] ['Adam', 'Bart', 'Lisa'] ['Adam', 'Bart', 'Lisa'] 最后一个assert抛出了错误，原因是['Adam', 'Bart', 'Lisa']!=['Bart', 'Lisa', 'Adam'],现在才发现[1,2]!=[2,1]
list是有顺序的set是无序的
list
set
Sign in to make a reply
舞雨口口窘
代码如下
def get_score_in(low, high): con=sqlite3.connect(db_file) cursor=con.cursor() cursor.execute('select * from user where score>=? and score<=?',(low,high)) results=[x[1] for x in cursor.fetchall()] print(results) cursor.close() con.close() return results 这是运行结果 ['Adam'] ['Bart', 'Lisa'] ['Adam', 'Bart', 'Lisa'] ['Adam', 'Bart', 'Lisa'] 最后一个assert抛出了错误，原因是['Adam', 'Bart', 'Lisa']!=['Bart', 'Lisa', 'Adam'],现在才发现[1,2]!=[2,1]