def get(self): user_datas = UserModel.get_all() result_data = [] for user in user_datas: if user.locked: continue result_data.append(user) self.render('control/show.html', data=result_data, uri=self.request.uri)
def get(self): result_data = { 'error_code': 0, 'reason': 'ok', 'data': [], } user_datas = UserModel.get_all() for user in user_datas: temp_info = {} temp_info['id'] = user.id temp_info['uuid'] = user.uuid temp_info['username'] = user.username temp_info['nickname'] = user.nickname result_data['data'].append(temp_info) self.write_json(result_data)
def get(self): user_datas = UserModel.get_all() result_data = [] for user in user_datas: if user.locked: continue #获取对应用户答题数据 score = SourceModel.get_by_userid(user.id) # print(score) # print(score[0].score) setattr(user, 'source_obj', score) result_data.append(user) self.render('control/show-answer.html', data=result_data, uri=self.request.uri)
def capture_data(): # 抓取数据 #获取数据至数据库 from util.capture.savedata import SaveQuestionData from util import db from model.user import UserModel from model import carquestion def _initialize_db(): ''' 创件数据表 :return: ''' print('初始化数据库') try: db.create_all() except Exception as e: print('Error:{}'.format(e)) else: print('初始化数据库表完成!') def _init_admin(): admin_info = '初始化管理员失败!!!' admin_user = UserModel.new( username='******', password='******', nickname='超级管理员', ) db.datebase_session.add(admin_user) try: db.datebase_session.commit() except Exception as e: print(e) db.datebase_session.rollback() else: print('管理员初始化成功!') admin_info = ''' 管理员用户名: 11111111111 管理员密码: 123456a ''' finally: db.datebase_session.close() return admin_info try: _initialize_db() print('正在请求数据!!!!') SaveQuestionData('small').save_to_database() SaveQuestionData('truck').save_to_database() SaveQuestionData('bus').save_to_database() SaveQuestionData('4').save_to_database() # 科目4题库 print('保存完成!') if not UserModel.get_all(): is_success_admin = _init_admin() print(is_success_admin) except Exception as e: print('请检查你的网络!!!!') sys.exit(0)