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
