def display_all(): try: students = session.query(Student_Details).all() if (students): return jsonify(Student_Details = [student.serialize for student in students]) else: return 'No Data found!!' except KeyError as k: return 'Exception Occured'
def display_student_details(): if (request.method == 'POST'): try: roll_no = request.form['roll'] student = session.query(Student_Details).filter_by( roll_no=roll_no).first() if (student): return render_template('display_details.html', student=student) else: return 'No such student found!!' except KeyError as k: return 'No arguments found in post request' else: return render_template('request_details.html')
def get_key(): seed(time()) count = session.query(func.count('*')).select_from(Key).scalar() id = randint(1, count) return session.query(Key).get(id)
def get_newest_key(): return session.query(Key).order_by(Key.UpdateTime.desc()).first()
def wrapper(*args, **kwargs): k = session.query(Key).with_lockmode('update').get(key.id) k.UseTimes += 1 session.commit() return func(*args, **kwargs)
def wrapper(*args, **kwargs): b = session.query(Blog).with_lockmode('update').get(args[0].blog_id) b.loaded_video += 1 session.commit() return func(*args, **kwargs)
def get_all_key(): return session.query(Key).all()
def mark_dead_blog(blog): b = session.query(Blog).with_lockmode('update').get(blog.id) b.alive = 0 session.commit()
def load_download_item(class_name): item_list = session.query(class_name).filter_by(file_path=None).all() return item_list
def load_all_blog(): return session.query(Blog).all()
def same_item_count(class_name, obj): return session.query(func.count('*')).select_from(class_name).filter_by( url=obj.url, blog_id=obj.blog_id).scalar()
def load_alive_blog_list(): return session.query(Blog).filter(Blog.alive == 1).all()
def get_item_blog(item): return session.query(Blog).get(item.blog_id)
def get_blog(id): return session.query(Blog).get(id)
def get_item(class_name, id): return session.query(class_name).get(id)
def load_all_downloaded_item(class_name): item_list = session.query(class_name).filter( not_(class_name.file_path is None)).all() return item_list