app.py

import copy
import falcon
import json
import os
import shutil
import subprocess
import sys
import traceback
from datetime import datetime, timedelta
from sqlalchemy import func, desc
from sqlalchemy.exc import SQLAlchemyError

import model
import endpoint
import util
from db import engine, session
from util import UserInfo

# sets CORS header to *, applied when running in a docker container
DISABLE_CORS = False

# Cache of the current year.
c_year = None
c_year_update = None


class JSONTranslator(object):

    def process_request(self, req, resp):
        return

    def process_response(self, req, resp, endpoint):
        if 'result' not in req.context:
            return

        resp.body = json.dumps(
            req.context['result'],
            sort_keys=True,
            indent=4,
            ensure_ascii=False,
        )


class Authorizer(object):

    def process_request(self, req, resp):
        if req.auth:
            token_str = req.auth.split(' ')[-1]
            try:
                token = session.query(model.Token).get(token_str)

                if token is not None:
                    if (req.relative_uri != '/auth' and
                       token.expire < datetime.utcnow()):
                        # user timeouted
                        req.context['user'] = UserInfo()
                        return

                    try:
                        req.context['user'] = UserInfo(
                            session.query(model.User).get(token.user),
                            token_str
                        )
                        return
                    except AttributeError:
                        pass
            except:
                session.rollback()

        req.context['user'] = UserInfo()


class SourceAddressFill:
    def process_request(self, req, resp):
        try:
            ip = req.env['HTTP_X_FORWARDED_FOR'].split(',')[-1].strip()
        except KeyError:
            ip = req.env['REMOTE_ADDR']

        req.context['source_ip'] = ip


class Year_fill(object):

    # This middleware has 2 purposes:
    #  1) Get current year.
    #  2) Test connection with db. (this is very important!)
    def process_request(self, req, resp):
        if req.method == 'OPTIONS':
            return
        try:
            if ('YEAR' in req.headers):
                req.context['year'] = req.headers['YEAR']
                req.context['year_obj'] = session.query(model.Year).\
                                          get(req.context['year'])
            else:
                year_obj = session.query(model.Year).\
                           order_by(desc(model.Year.id)).first()
                req.context['year_obj'] = year_obj
                req.context['year'] = year_obj.id
        except SQLAlchemyError:
            session.rollback()
            try:
                if ('YEAR' in req.headers):
                    req.context['year'] = req.headers['YEAR']
                    req.context['year_obj'] = session.query(model.Year).\
                                              get(req.context['year'])
                else:
                    year_obj = session.query(model.Year).\
                               order_by(desc(model.Year.id)).first()
                    req.context['year_obj'] = year_obj
                    req.context['year'] = year_obj.id
            except:
                session.rollback()
                raise


class AddCORS:
    def process_request(self, req, resp):
        return

    def process_response(self, req, resp, *_):
        if DISABLE_CORS:
            resp.set_header('Access-Control-Allow-Origin', '*')


def log(req, resp):
    user = req.context.get("user")
    user_id = user.id if user else '_'
    ip = req.context['source_ip']

    print(f'[{datetime.now().strftime("%Y-%m-%d %H:%M:%S")}] '
          f'[INFO] [HTTP] '
          f'[{ip}] '
          f'[{req.method}] '
          f'[{resp.status.split()[0]}] '
          f'[{user_id}] '
          f'{req.relative_uri}')
    sys.stdout.flush()


class Logger(object):
    def process_request(self, req, resp):
        pass
    def process_response(self, req, resp, resource, req_succeeded):
        log(req, resp)


def log_sink(req, resp):
    resp.status = falcon.HTTP_404

    # Uncomment this to log sink
    log(req, resp)


class Corser(object):

    def process_response(self, request, response, resource):
        response.set_header('Access-Control-Allow-Headers',
                            'authorization,content-type,year')
        response.set_header('Access-Control-Allow-Methods',
                            'OPTIONS,PUT,POST,GET,DELETE')


def error_handler(ex, req, resp, params):
    if isinstance(ex, falcon.HTTPError):
        req.context['result'] = {
            'errors': [ {
                'status': ex.status,
                'title': ex.title,
                'detail': ex.description,
            } ]
        }
        resp.status = ex.status
    else:
        req.context['result'] = {
            'errors': [ {
                'status': '500',
                'title': 'Internal server error',
                'detail': 'Vnitřní chyba serveru, kontaktujte správce backendu.',
            } ]
        }
        resp.status = falcon.HTTP_500

    log(req, resp)
    if resp.status == falcon.HTTP_500:
        dt = datetime.now().strftime('[%Y-%m-%d %H:%M:%S]')
        lines = '\n'.join(
            [dt + ' ' + line for line in traceback.format_exc().split('\n')]
        )
        print(lines)


# Add Logger() to middleware for logging
api = falcon.API(middleware=[SourceAddressFill(), JSONTranslator(), Authorizer(), Year_fill(),
                 Corser(), AddCORS(), Logger()])
api.add_error_handler(Exception, handler=error_handler)
api.req_options.auto_parse_form_urlencoded = True

# Odkomentovat pro vytvoreni tabulek v databazi
# model.Base.metadata.create_all(engine)

# Create /tmp/box with proper permissions (for sandbox)
if os.path.isdir(util.programming.EXEC_PATH):
    shutil.rmtree(util.programming.EXEC_PATH, ignore_errors=True)

try:
    os.makedirs(util.programming.EXEC_PATH)
except FileExistsError:
    pass

p = subprocess.Popen(["setfacl", "-d", "-m", "group:ksi:rwx",
                      util.programming.EXEC_PATH])
p.wait()
if p.returncode != 0:
    raise Exception("Cannot change umask to %s!" %
                    (util.programming.EXEC_PATH))

api.add_route('/robots.txt', endpoint.Robots())
api.add_route('/csp', endpoint.CSP())
api.add_route('/articles', endpoint.Articles())
api.add_route('/articles/{id}', endpoint.Article())
api.add_route('/achievements', endpoint.Achievements())
api.add_route('/achievements/{id}', endpoint.Achievement())
api.add_route('/achievements/special/successful', endpoint.AchievementSuccessfulParticipant())
api.add_route('/posts', endpoint.Posts())
api.add_route('/posts/{id}', endpoint.Post())
api.add_route('/tasks', endpoint.Tasks())
api.add_route('/tasks/{id}', endpoint.Task())
api.add_route('/taskDetails/{id}', endpoint.TaskDetails())
api.add_route('/modules/{id}', endpoint.Module())
api.add_route('/modules/{id}/submit', endpoint.ModuleSubmit())
api.add_route('/modules/{id}/submitFiles', endpoint.ModuleSubmit())  # alias required for swagger
api.add_route('/submFiles/{id}', endpoint.ModuleSubmittedFile())
api.add_route('/threads', endpoint.Threads())
api.add_route('/threads/{id}', endpoint.Thread())
api.add_route('/threadDetails/{id}', endpoint.ThreadDetails())
api.add_route('/users', endpoint.Users())
api.add_route('/users/{id}', endpoint.User())
api.add_route('/users/{id}/discord', endpoint.DiscordInviteLink())
api.add_route('/profile/picture', endpoint.PictureUploader())
api.add_route('/profile/{id}', endpoint.OrgProfile())
api.add_route('/profile/', endpoint.Profile())
api.add_route('/basicProfile/', endpoint.BasicProfile())
api.add_route('/images/{context}/{id}', endpoint.Image())
api.add_route('/content', endpoint.Content())
api.add_route('/taskContent/{id}', endpoint.TaskContent())
api.add_route('/task-content/{id}/{view}', endpoint.TaskContent())
api.add_route('/registration', endpoint.Registration())
api.add_route('/auth', endpoint.Authorize())
api.add_route('/logout', endpoint.Logout())
api.add_route('/runCode/{id}/submit', endpoint.RunCode())
api.add_route('/feedback', endpoint.FeedbackEmail())
api.add_route('/settings/changePassword', endpoint.ChangePassword())
api.add_route('/forgottenPassword', endpoint.ForgottenPassword())
api.add_route('/waves', endpoint.Waves())
api.add_route('/waves/{id}', endpoint.Wave())
api.add_route('/years', endpoint.Years())
api.add_route('/years/{id}', endpoint.Year())
api.add_route('/feedbacks', endpoint.FeedbacksTask())
api.add_route('/feedbacks/{id}', endpoint.FeedbackTask())
api.add_route('/diplomas/{user}', endpoint.Diploma())
api.add_route('/diplomas/{user}/{year}/show', endpoint.DiplomaDownload())

"""
task-content endpoint contains: (defined in endpoint/content.py, see also
./gunicorn_cfg.py)
 * /taskContent/{id}/zadani/{file_path}
 * /taskContent/{id}/reseni/{file_path}
 * /taskContent/[id]/icon/{file_name}
"""

api.add_route('/admin/evaluations/{id}', endpoint.admin.Evaluation())
api.add_route('/admin/corrections', endpoint.admin.Corrections())
api.add_route('/admin/corrections/{id}', endpoint.admin.Correction())
api.add_route('/admin/correctionsInfos', endpoint.admin.CorrectionsInfo())
api.add_route('/admin/correctionsInfos/{id}', endpoint.admin.CorrectionInfo())
api.add_route('/admin/correctionsEmail/{id}', endpoint.admin.CorrectionsEmail())
api.add_route('/admin/corrections/{id}/publish', endpoint.admin.CorrectionsPublish())
api.add_route('/admin/subm/eval/{eval_id}/', endpoint.admin.SubmFilesEval())
api.add_route('/admin/subm/task/{task_id}/', endpoint.admin.SubmFilesTask())
api.add_route('/admin/e-mail/', endpoint.admin.Email())
api.add_route('/admin/atasks/', endpoint.admin.Tasks())
api.add_route('/admin/atasks/{id}', endpoint.admin.Task())
api.add_route('/admin/atasks/{id}/deploy', endpoint.admin.TaskDeploy())
api.add_route('/admin/atasks/{id}/merge', endpoint.admin.TaskMerge())
api.add_route('/admin/waves/{id}/diff', endpoint.admin.WaveDiff())
api.add_route('/admin/achievements/grant', endpoint.admin.AchievementGrant())
api.add_route('/admin/user-export', endpoint.admin.UserExport())
api.add_route('/admin/evalCodes/{id}', endpoint.admin.EvalCode())
api.add_route('/admin/execs', endpoint.admin.Execs())
api.add_route('/admin/execs/{id}', endpoint.admin.Exec())
api.add_route('/admin/monitoring-dashboard', endpoint.admin.MonitoringDashboard())
api.add_route('/admin/diploma/{id}/grant', endpoint.admin.DiplomaGrant())

api.add_route('/unsubscribe/{id}', endpoint.Unsubscribe())

api.add_sink(log_sink)