def get_lang_id(file):
"""
File extension validator and identificator
:param file: Input file
:return: Language ID, if extension is valid, or None.
"""
from lib.database import db_session
from models import Language
filename, ext = os.path.splitext(file)
return db_session.query(Language.id).filter_by(file_ext=ext).first()
def problemset(page):
"""
Problems list
"""
from models import Problem, Solution
from lib.database import db_session
from lib.pagination import Pagination
per_page = centipede.config['PER_PAGE']
total = Problem.query.count()
problems = db_session.query(Problem.id, Problem.title).order_by(Problem.id).\
limit(per_page).offset((page - 1) * per_page).all()
pagination = Pagination(page, per_page, total)
for problem in problems:
problem.total = Solution.query.filter_by(problem_id = problem.id).count()
problem.success = Solution.query.filter_by(
problem_id = problem.id,
status = Solution.STATUS['tested']['accept']
).count()
return render_template('problemset.html', problems = problems, active_problems = True, pagination = pagination)
def find_one(cls, id):
return db_session.query(
cls
).filter(cls.id == id).first()
def find_all_id(cls):
return db_session.query(
cls.id
).filter(cls.id > 10798).all()
def find_all(cls):
return db_session.query(
cls
).filter().all()
def find_by_logId(cls, log_id):
return db_session.query(cls).filter(cls.log_id == log_id).first()