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)