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)
