15
15
# along with this program; if not, write to the Free Software
16
16
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
18
# Module: TutorialService
22
# Provides the AJAX backend for the tutorial application.
23
# This allows several actions to be performed on the code the student has
24
# typed into one of the exercise boxes.
28
# The arguments determine what is to be done on this file.
30
# "action". One of the tutorialservice actions.
31
# "exercise" - The path to a exercise file (including the .xml extension),
32
# relative to the subjects base directory.
33
# action "save" or "test" (POST only):
34
# "code" - Full text of the student's code being submitted.
35
# action "getattempts": No arguments. Returns a list of
36
# {'date': 'formatted_date', 'complete': bool} dicts.
37
# action "getattempt":
38
# "date" - Formatted date. Gets most recent attempt before (and including)
40
# Returns JSON string containing code, or null.
42
# Returns a JSON response string indicating the results.
49
from common import (db, util)
53
# If True, getattempts or getattempt will allow browsing of inactive/disabled
54
# attempts. If False, will not allow this.
55
HISTORY_ALLOW_INACTIVE = False
58
"""Handler for Ajax backend TutorialService app."""
59
# Set request attributes
60
req.write_html_head_foot = False # No HTML
63
req.throw_error(req.HTTP_BAD_REQUEST)
64
fields = req.get_fieldstorage()
65
act = fields.getfirst('action')
66
exercise = fields.getfirst('exercise')
67
if act is None or exercise is None:
68
req.throw_error(req.HTTP_BAD_REQUEST)
70
exercise = exercise.value
72
if act == 'save' or act == 'test':
74
if req.method != 'POST':
75
req.throw_error(req.HTTP_BAD_REQUEST)
77
code = fields.getfirst('code')
79
req.throw_error(req.HTTP_BAD_REQUEST)
83
handle_save(req, exercise, code, fields)
85
handle_test(req, exercise, code, fields)
86
elif act == 'getattempts':
87
handle_getattempts(req, exercise)
88
elif act == 'getattempt':
89
date = fields.getfirst('date')
91
req.throw_error(req.HTTP_BAD_REQUEST)
93
# Convert into a struct_time
94
# The time *should* be in the same format as the DB (since it should
95
# be bounced back to us from the getattempts output). Assume this.
97
date = time.strptime(date, db.TIMESTAMP_FORMAT)
99
# Date was not in correct format
100
req.throw_error(req.HTTP_BAD_REQUEST)
101
handle_getattempt(req, exercise, date)
103
req.throw_error(req.HTTP_BAD_REQUEST)
105
def handle_save(req, exercise, code, fields):
106
"""Handles a save action. This saves the user's code without executing it.
108
# Need to open JUST so we know this is a real exercise.
109
# (This avoids users submitting code for bogus exercises).
110
exercisefile = util.open_exercise_file(exercise)
111
if exercisefile is None:
112
req.throw_error(req.HTTP_NOT_FOUND,
113
"The exercise was not found.")
116
req.write('{"result": "ok"}')
121
conn.write_problem_save(
122
login = req.user.login,
123
exercisename = exercise,
124
date = time.localtime(),
129
def handle_test(req, exercise, code, fields):
130
"""Handles a test action."""
132
exercisefile = util.open_exercise_file(exercise)
133
if exercisefile is None:
134
req.throw_error(req.HTTP_NOT_FOUND,
135
"The exercise was not found.")
137
# Parse the file into a exercise object using the test suite
138
exercise_obj = test.parse_exercise_file(exercisefile)
140
# Run the test cases. Get the result back as a JSONable object.
142
test_results = exercise_obj.run_tests(code)
146
conn.insert_problem_attempt(
147
login = req.user.login,
148
exercisename = exercise,
149
date = time.localtime(),
18
# Author: Matt Giuca, Nick Chadwick
20
'''AJAX backend for the tutorial application.'''
25
from storm.locals import Store
28
from ivle.database import Exercise, ExerciseAttempt, ExerciseSave, Worksheet, \
29
Offering, Subject, Semester, User, WorksheetExercise
30
import ivle.worksheet.utils
31
from ivle.webapp.base.rest import (JSONRESTView, write_operation,
33
from ivle.webapp.errors import NotFound
36
TIMESTAMP_FORMAT = '%Y-%m-%d %H:%M:%S'
39
class AttemptsRESTView(JSONRESTView):
40
'''REST view of a user's attempts at an exercise.'''
42
@require_permission('edit')
44
"""Handles a GET Attempts action."""
45
attempts = req.store.find(ExerciseAttempt,
46
ExerciseAttempt.ws_ex_id == self.context.worksheet_exercise.id,
47
ExerciseAttempt.user_id == self.context.user.id)
48
# attempts is a list of ExerciseAttempt objects. Convert to dictionaries
49
time_fmt = lambda dt: datetime.datetime.strftime(dt, TIMESTAMP_FORMAT)
50
attempts = [{'date': time_fmt(a.date), 'complete': a.complete}
56
@require_permission('edit')
57
def PUT(self, req, data):
58
""" Tests the given submission """
59
test_results = ivle.worksheet.utils.test_exercise_submission(
60
req.config, req.user, self.context.worksheet_exercise.exercise,
63
attempt = ivle.database.ExerciseAttempt(user=req.user,
64
worksheet_exercise = self.context.worksheet_exercise,
65
date = datetime.datetime.now(),
150
66
complete = test_results['passed'],
67
text = unicode(data['code'])
70
req.store.add(attempt)
153
72
# Query the DB to get an updated score on whether or not this problem
154
73
# has EVER been completed (may be different from "passed", if it has
155
74
# been completed before), and the total number of attempts.
156
completed, attempts = conn.get_problem_status(req.user.login,
75
completed, attempts = ivle.worksheet.utils.get_exercise_status(
76
req.store, req.user, self.context.worksheet_exercise)
158
77
test_results["completed"] = completed
159
78
test_results["attempts"] = attempts
161
req.write(cjson.encode(test_results))
165
def handle_getattempts(req, exercise):
166
"""Handles a getattempts action."""
169
attempts = conn.get_problem_attempts(
170
login=req.user.login,
171
exercisename=exercise,
172
allow_inactive=HISTORY_ALLOW_INACTIVE)
173
req.write(cjson.encode(attempts))
177
def handle_getattempt(req, exercise, date):
178
"""Handles a getattempts action. Date is a struct_time."""
181
attempt = conn.get_problem_attempt(
182
login=req.user.login,
183
exercisename=exercise,
185
allow_inactive=HISTORY_ALLOW_INACTIVE)
186
# attempt may be None; will write "null"
187
req.write(cjson.encode(attempt))
83
class AttemptRESTView(JSONRESTView):
84
'''REST view of an exercise attempt.'''
86
@require_permission('view')
88
return {'code': self.context.text}
91
class WorksheetExerciseRESTView(JSONRESTView):
92
'''REST view of a worksheet exercise.'''
94
@write_operation('view')
95
def save(self, req, text):
96
# Find the appropriate WorksheetExercise to save to. If its not found,
97
# the user is submitting against a non-existant worksheet/exercise
99
old_save = req.store.find(ExerciseSave,
100
ExerciseSave.ws_ex_id == self.context.id,
101
ExerciseSave.user == req.user).one()
103
#Overwrite the old, or create a new if there isn't one
105
new_save = ExerciseSave()
106
req.store.add(new_save)
110
new_save.worksheet_exercise = self.context
111
new_save.user = req.user
112
new_save.text = unicode(text)
113
new_save.date = datetime.datetime.now()
115
return {"result": "ok"}
118
class WorksheetsRESTView(JSONRESTView):
119
"""View used to update and create Worksheets."""
121
@write_operation('edit_worksheets')
122
def move_up(self, req, worksheetid):
123
"""Takes a list of worksheet-seq_no pairs and updates their
124
corresponding Worksheet objects to match."""
126
worksheet_below = req.store.find(Worksheet,
127
Worksheet.offering_id == self.context.id,
128
Worksheet.identifier == unicode(worksheetid)).one()
129
if worksheet_below is None:
130
raise NotFound('worksheet_below')
131
worksheet_above = req.store.find(Worksheet,
132
Worksheet.offering_id == self.context.id,
133
Worksheet.seq_no == (worksheet_below.seq_no - 1)).one()
134
if worksheet_above is None:
135
raise NotFound('worksheet_above')
137
worksheet_below.seq_no = worksheet_below.seq_no - 1
138
worksheet_above.seq_no = worksheet_above.seq_no + 1
140
return {'result': 'ok'}
142
@write_operation('edit_worksheets')
143
def move_down(self, req, worksheetid):
144
"""Takes a list of worksheet-seq_no pairs and updates their
145
corresponding Worksheet objects to match."""
147
worksheet_above = req.store.find(Worksheet,
148
Worksheet.offering_id == self.context.id,
149
Worksheet.identifier == unicode(worksheetid)).one()
150
if worksheet_above is None:
151
raise NotFound('worksheet_below')
152
worksheet_below = req.store.find(Worksheet,
153
Worksheet.offering_id == self.context.id,
154
Worksheet.seq_no == (worksheet_above.seq_no + 1)).one()
155
if worksheet_below is None:
156
raise NotFound('worksheet_above')
158
worksheet_below.seq_no = worksheet_below.seq_no - 1
159
worksheet_above.seq_no = worksheet_above.seq_no + 1
161
return {'result': 'ok'}