From 194ef383e2a61b8c9dcf85bc5ca0fc377089d349 Mon Sep 17 00:00:00 2001 From: Robert Zorko Date: Fri, 18 Sep 2015 18:42:06 +0200 Subject: added a parameter to the get problems python function, which accepts the language (either 'prolog' or 'python') --- server/problems.py | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'server/problems.py') diff --git a/server/problems.py b/server/problems.py index 1c87345..a036602 100644 --- a/server/problems.py +++ b/server/problems.py @@ -6,8 +6,8 @@ import threading import os.path from db import get_connection, return_connection -#sys.path.append('/home/aless/job/codeq/source/codeq-problems/') -_path_prefix = '/home/aless/job/codeq/source/codeq-problems/' +#sys.path.append('/home/robert/git/codeq-problems/') +_path_prefix = '/home/robert/git/codeq-problems/' _module_loading_lock = threading.RLock() # TODO: make a more fine-grained locking import machinery def load_module(fullname): @@ -83,13 +83,13 @@ def solutions_for_problems(language, tuples): pass return '\n'.join(solutions) -def list_problems(): +def list_problems(language): conn = get_connection() try: cur = conn.cursor() try: cur.arraysize = 1000 - cur.execute('select l.identifier, l.name, g.identifier, g.name, p.identifier, p.name from problem p inner join language l on l.id = p.language_id inner join problem_group g on g.id = p.problem_group_id order by l.identifier, g.identifier, p.identifier') + cur.execute('select l.identifier, l.name, g.identifier, g.name, p.identifier, p.name from problem p inner join language l on l.id = p.language_id and l.identifier = \''+language+'\' inner join problem_group g on g.id = p.problem_group_id order by l.identifier, g.identifier, p.identifier') result = [] previous_language = '' previous_group = '' -- cgit v1.2.1