def get_task(category, score):

    task = db.query('''select t.* from tasks t, categories c, cat_task ct 
        where t.id = ct.task_id and c.id = ct.cat_id 
        and t.score=:score and lower(c.short_name)=:cat''',
        score=score, cat=category)
    return list(task)[0]
Finds a task with a given category and score
dataset/ETHPy150Open huner2/Tiny-CTF-Platform/server.py/get_task