#初始数据
conn = sqlite3.connect(db_file)
cursor = conn.cursor()
cursor.execute('create table user(id varchar(20) primary key, name varchar(20), score int)')
cursor.execute(r"insert into user values ('A-001', 'Adam', 95)")
cursor.execute(r"insert into user values ('A-002', 'Bart', 62)")
cursor.execute(r"insert into user values ('A-003', 'Lisa', 78)")
cursor.close()
conn.commit()
conn.close()
def get_score_in(low,high):
#返回分数区间的名字，按分数从低到高排列
conn = sqlite3.connect(db_file)
cursor = conn.cursor()
cursor.execute('select name,score from user where score<=? and score>=?',(high,low))
results = cursor.fetchall()
cursor.close()
conn.close()
last_results= []
# print(results)
results = sorted(results,key=lambda x :x[1])
for i in results:
last_results.append(i[0])
return last_results
if name == 'main':
assert get_score_in(80,95) == ['Adam']
assert get_score_in(60,80) == ['Bart', 'Lisa']
assert get_score_in(60,100) == ['Bart', 'Lisa', 'Adam']
print('Pass')
王日天95
#encoding = utf-8 import os,sqlite3 db_file = os.path.join(os.path.dirname(file),'test.db') if os.path.isfile(db_file): os.remove(db_file)
#初始数据 conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute('create table user(id varchar(20) primary key, name varchar(20), score int)') cursor.execute(r"insert into user values ('A-001', 'Adam', 95)") cursor.execute(r"insert into user values ('A-002', 'Bart', 62)") cursor.execute(r"insert into user values ('A-003', 'Lisa', 78)") cursor.close() conn.commit() conn.close()
def get_score_in(low,high):
if name == 'main': assert get_score_in(80,95) == ['Adam'] assert get_score_in(60,80) == ['Bart', 'Lisa'] assert get_score_in(60,100) == ['Bart', 'Lisa', 'Adam'] print('Pass')