def get(self, page, limit):
start = (page - 1) * limit
data = session.query(Cla).limit(limit).offset(start)
arr = [EditTime(marshal(item, classes_fields)) for item in data]
num = session.query(Cla).count()
pageNum = math.ceil(num / limit)
return {'code': 200, 'data': arr, 'pagenum': pageNum}
def __init__(self, user: discord.Member):
self.user = user
character = session.query(db.Player)\
.filter(db.Player.user_id == self.user.id)\
.one_or_none()
self.sex = character.sex
self.level = character.level
self.xp = character.xp
self.strength = character.strength
self.agility = character.agility
self.resistance = character.resistance
self.endurance = character.endurance
self.intelligence = character.intelligence
self.perception = character.perception
self.luck = character.luck
if character is None:
player = db.Player()
player.user_id = self.user.id
player.sex = "male"
equipment = db.Player()
equipment.user_id = self.user.id
session.add(player)
session.commit()
def get(self):
data = session.query(Cla).all()
print(data)
# 序列化
arr = [EditTime(marshal(item, classes_fields)) for item in data]
# 时间处理
return {'msg': 'ok', 'data': arr}, 201
def updateUserById(user_id):
try:
if not user_id.isdigit(): raise ValueError('Id must be integer')
user_id = int(user_id)
if user_id < 1: raise ValueError('Id must be bigger than 0')
user = session.query(User).get(user_id)
if user is None: return jsonify({"message": 'Not found'}), 404
data = request.form
for key in getModelKeys(User):
if key is 'password' and key in data: user.setPassword(data[key])
else:
if key in data: user.__setattr__(key, data[key])
session.commit()
session.refresh(user)
return jsonify(user=JSONEncoder(user)), 200
except ValueError as err:
return jsonify({"message": str(err)}), 400
except AssertionError as err:
return jsonify({"message": str(err)}), 400
except Exception as err:
print(err)
return jsonify({"message": str(err)}), 500
def getUsers():
try:
all_users = session.query(User).all()
return jsonify(users=JSONEncoder(all_users)), 200
except Exception as err:
print(err)
return jsonify({"message": str(err)}), 500
def dels():
c = session.query(Classes).filter(Classes.id).first()
try:
session.delete(c)
session.commit()
except:
return jsonify({'code':200,'status':'no','msg':'数据库异常，请重试'})
return jsonify({'code':200,'status':'yes','msg':'提交成功'})
def classesuri():
if request.method == "GET":
cid = request.args.get('id', None)
if cid:
pass
else:
data = session.query(Classes).all()
print(data)
return jsonify({'code': 200, 'msg': 'ok'})
def validate_email(self, key, email):
if not email:
raise AssertionError('No email provided')
if not isEmailValid(email):
raise AssertionError('Provided email is not an email address')
if session.query(User).filter(User.email == email).first():
raise AssertionError('This email is already in use')
return email
def list_settings():
'''List settings'''
settings = [setting for setting in session.query(Setting).all()]
if settings:
click.echo('Setting ID\tSetting Key\tSetting Value')
for setting in settings:
click.echo(f'{setting.setting_id}\t\t{setting.setting_name}\t\t'
f'{setting.setting_value}')
else:
click.echo('No settings available')
def deleteUserById(user_id):
try:
if not user_id.isdigit(): raise ValueError('Id must be integer')
user_id = int(user_id)
if user_id < 1: raise ValueError('Id must be bigger than 0')
user = session.query(User).get(user_id)
if user is None: return jsonify({"message": 'Not found'}), 404
session.query(User).filter(User.id == user_id).delete()
session.commit()
return jsonify(user=JSONEncoder(user)), 200
except ValueError as err:
return jsonify({"message": str(err)}), 400
except Exception as err:
print(err)
return jsonify({"message": str(err)}), 500
def delete(self, id):
if not id or not id_validator(id):
return {'message': 'Provide valid id!'}, 400
img = session.query(Images).get(int(id))
if not img:
return {'message': 'Image does not exist'}, 400
delete_image(img)
return {'message': 'Image deleted successfully.'}, 200
def get(self, id):
if id:
img = session.query(Images).get(id)
if not img:
return jsonify(
{'message': 'Image with this id does not exist!'})
result = []
file_path = os.getcwd(
) + '/database/images/' + img.img_name + '.jpeg'
result.append({
'image_id': img.id,
'image_name': img.img_name,
'image_path': file_path
})
return jsonify(images=result)
return api.abort(404)
def get(self, name=None):
# TODO: make name filter
# if name:
# all_images = session.query(Images).get(name)
# result = []
# for img in all_images:
# file_path = os.getcwd() + '/database/images/' + img.img_name + '.jpeg'
# result.append((img.img_name, file_path))
# return jsonify(images=result)
all_images = session.query(Images).all()
result = []
for img in all_images:
file_path = os.getcwd(
) + '/database/images/' + img.img_name + '.jpeg'
result.append({
'image_id': img.id,
'image_name': img.img_name,
'image_path': file_path
})
return jsonify(result)
def get_by_id(prject_id):
try:
return session.query(Project).filter_by(id=prject_id).one()
except NoResultFound:
return abort(404)
def search(project_name):
return session.query(Project).filter(
Project.name.like('%' + project_name + '%')).all()
def login(_email, _password): try: return session.query(Account).filter_by(email=_email, password=_password).one() except NoResultFound: return None
def get_data(id): try: return session.query(Account).filter_by(id=id).one() except NoResultFound: return abort(404)
def get_by_name(project_name):
try:
return session.query(Project).filter_by(name=project_name).one()
except NoResultFound:
return abort(404)
def home():
projects = session.query(Project).order_by(desc(Project.id)).all()
return render_template('index.html', projects=projects)
