def interactive(self):
while True:
user_input = input("请输入名字和QQ：").strip()
user_info = user_input.split()
if len(user_info) != 2: continue
status = DbAPI.query_stud_id(user_info[0].strip(),
user_info[1].strip())
self.stud_id = int(status)
# print("status_id: %s"%self.stud_id)
if int(status) == -1:
print("学员不存在")
continue
break
print("学员课程信息".center(50, "-"))
data = DbAPI.query_stud_info_by_id(int(status))
for obj in data:
print("课程：%s; 课程记录：%s" % (obj[0], obj[1]))
print("-" * 55)
self.ops_list()
while True:
user_opt = input("please input your choice:").strip()
if user_opt in self.data:
if hasattr(self, self.data.get(user_opt)[1]):
func = getattr(self, self.data.get(user_opt)[1])
func()
else:
print("实例属性不存在")
else:
print("选项不存在")
def query_all_stud_record(self, class_name, date):
data = DbAPI.query_class_stud_record(class_name, date)
# print(data)
for obj in data:
print("score: %s; name: %s; QQ: %s" %
(obj.get('score'), obj.get('stud_name'), obj.get('stud_qq')))
def query_all_student(self):
data = DbAPI.query_all_stud()
# print(data)
for obj in data:
# print(obj)
print("姓名：{}； QQ：{}； 课程：{}".format(obj.get('name'), obj.get('qq'),
obj.get('learn_class')))
def query_all_class(self):
'''查询班级'''
data = DbAPI.query_class_all()
if len(data) == 0:
print("没有班级。。。。")
else:
for obj in data:
print("班级名称：%s" % obj.get('class_name'))
def query_stud_by_class(self, class_name):
'''查询班级成员'''
data = DbAPI.query_class_by_name(class_name)
if data != [] and data != None:
for stud in data:
print("-" * 50)
print("姓名：%s; qq: %s" % (stud.get('name'), stud.get('qq')))
# print("-" * 50)
else:
print("没有学生。。。")
def modify_stud_score(self, score, date, class_name, qq):
DbAPI.modify_stud_score(score, date, class_name, qq)
def query_class_record(self, class_name):
data = DbAPI.query_a_class_all_records(class_name)
print("###%s 课程记录###" % class_name)
for class_record in data:
print("上课时间：%s" % class_record.get('class_time'))
def add_stud_to_class_by_qq(self, qq, class_name):
'''根据学员qq号把学员加入班级'''
DbAPI.add_stud_to_class_by_qq(qq, class_name)
def create_class_recors(self, class_name):
'''创建上课记录，并为每一个学生创建记录'''
DbAPI.initialize_class_records(class_name)
def create_stud(self, name, qq):
DbAPI.create_student(name, qq)
def create_class(self, class_name):
'''创建班级'''
DbAPI.create_class(class_name)
def query_score(self, class_name):
data = DbAPI.query_stud_score(self.stud_id, class_name)
print("名次：%s" % data[1])
for obj_data in data[0]:
print("分数：%s, 课程时间：%s, 作业： %s" %
(obj_data['score'], obj_data['time'], obj_data['stud_task']))
def submit_task(self, class_name, time, text_name):
DbAPI.modify_stud_record_task(self.stud_id, class_name, time,
text_name)