23
23
This module provides functions for tutorial and worksheet computations.
26
from storm.locals import And, Asc, Desc, Store
26
from storm.locals import And, Asc, Desc
29
27
import ivle.database
30
from ivle.database import ExerciseAttempt, ExerciseSave, Worksheet, \
31
WorksheetExercise, Exercise
28
from ivle.database import ExerciseAttempt, ExerciseSave, Worksheet
33
30
__all__ = ['get_exercise_status', 'get_exercise_stored_text',
34
31
'get_exercise_attempts', 'get_exercise_attempt',
37
def get_exercise_status(store, user, worksheet_exercise, as_of=None):
34
def get_exercise_status(store, user, exercise, worksheet):
38
35
"""Given a storm.store, User and Exercise, returns information about
39
36
the user's performance on that problem.
40
@param store: A storm.store
42
@param worksheet_exercise: An Exercise.
43
@param as_of: Optional datetime. If supplied, gets the status as of as_of.
44
37
Returns a tuple of:
45
38
- A boolean, whether they have successfully passed this exercise.
46
39
- An int, the number of attempts they have made up to and
50
43
# A Storm expression denoting all active attempts by this user for this
52
45
is_relevant = ((ExerciseAttempt.user_id == user.id) &
53
(ExerciseAttempt.ws_ex_id == worksheet_exercise.id) &
54
(ExerciseAttempt.active == True))
56
is_relevant &= ExerciseAttempt.date <= as_of
46
(ExerciseAttempt.exercise_id == exercise.id) &
47
(ExerciseAttempt.active == True) &
48
(ExerciseAttempt.worksheetid == worksheet.id))
58
50
# Get the first successful active attempt, or None if no success yet.
59
51
# (For this user, for this exercise).
76
68
return first_success is not None, num_attempts
78
def get_exercise_stored_text(store, user, worksheet_exercise):
79
"""Given a storm.store, User and WorksheetExercise, returns an
70
def get_exercise_stored_text(store, user, exercise, worksheet):
71
"""Given a storm.store, User and Exercise, returns an
80
72
ivle.database.ExerciseSave object for the last saved/submitted attempt for
81
73
this question (note that ExerciseAttempt is a subclass of ExerciseSave).
82
74
Returns None if the user has not saved or made an attempt on this
88
80
# Get the saved text, or None
89
81
saved = store.find(ExerciseSave,
90
82
ExerciseSave.user_id == user.id,
91
ExerciseSave.ws_ex_id == worksheet_exercise.id).one()
83
ExerciseSave.exercise_id == exercise.id,
84
ExerciseSave.worksheetid == worksheet.id).one()
93
86
# Get the most recent attempt, or None
94
87
attempt = store.find(ExerciseAttempt,
95
88
ExerciseAttempt.user_id == user.id,
89
ExerciseAttempt.exercise_id == exercise.id,
90
ExerciseAttempt.worksheetid == worksheet.id,
96
91
ExerciseAttempt.active == True,
97
ExerciseAttempt.ws_ex_id == worksheet_exercise.id
98
92
).order_by(Asc(ExerciseAttempt.date)).last()
100
94
# Pick the most recent of these two
117
111
# Get the most recent attempt before as_of, or None
118
112
return store.find(ExerciseAttempt,
119
113
ExerciseAttempt.user_id == user.id,
120
ExerciseAttempt.ws_ex_id == worksheet_exercise.id,
114
ExerciseAttempt.exercise_id == exercise.id,
115
ExerciseAttempt.worksheetid == worksheet.id,
121
116
True if allow_inactive else ExerciseAttempt.active == True,
122
117
True if as_of is None else ExerciseAttempt.date <= as_of,
123
118
).order_by(Desc(ExerciseAttempt.date))
125
def get_exercise_attempts(store, user, worksheet_exercise, as_of=None,
120
def get_exercise_attempts(store, user, exercise, worksheet, as_of=None,
126
121
allow_inactive=False):
127
122
"""Given a storm.store, User and Exercise, returns a list of
128
123
ivle.database.ExerciseAttempt objects, one for each attempt made for the
132
127
attempts made before or at this time.
133
128
allow_inactive: If True, will return disabled attempts.
135
return list(_get_exercise_attempts(store, user, worksheet_exercise, as_of,
130
return list(_get_exercise_attempts(store, user, exercise, worksheet, as_of,
138
def get_exercise_attempt(store, user, worksheet_exercise, as_of=None,
133
def get_exercise_attempt(store, user, exercise, worksheet, as_of=None,
139
134
allow_inactive=False):
140
"""Given a storm.store, User and WorksheetExercise, returns an
135
"""Given a storm.store, User and Exercise, returns an
141
136
ivle.database.ExerciseAttempt object for the last submitted attempt for
143
138
Returns None if the user has not made an attempt on this
147
142
attempts made before or at this time.
148
143
allow_inactive: If True, will return disabled attempts.
150
return _get_exercise_attempts(store, user, worksheet_exercise, as_of,
145
return _get_exercise_attempts(store, user, exercise, worksheet, as_of,
151
146
allow_inactive).first()
153
def save_exercise(store, user, worksheet_exercise, text, date):
148
def save_exercise(store, user, exercise, worksheet, text, date):
154
149
"""Save an exercise for a user.
156
Given a store, User, WorksheetExercise, text and date, save the text to the
151
Given a store, User, Exercise and text and date, save the text to the
157
152
database. This will create the ExerciseSave if needed.
159
154
saved = store.find(ivle.database.ExerciseSave,
160
155
ivle.database.ExerciseSave.user_id == user.id,
161
ivle.database.ExerciseSave.ws_ex_id == worksheet_exercise.id
156
ivle.database.ExerciseSave.exercise_id == exercise.id,
157
ivle.database.ExerciseSave.worksheetid == worksheet.id
163
159
if saved is None:
164
saved = ivle.database.ExerciseSave(user=user,
165
worksheet_exercise=worksheet_exercise)
160
saved = ivle.database.ExerciseSave(user=user, exercise=exercise,
168
164
saved.date = date
169
165
saved.text = text
171
def calculate_score(store, user, worksheet, as_of=None):
167
def calculate_score(store, user, worksheet):
173
169
Given a storm.store, User, Exercise and Worksheet, calculates a score for
174
170
the user on the given worksheet.
175
@param store: A storm.store
177
@param worksheet: A Worksheet.
178
@param as_of: Optional datetime. If supplied, gets the score as of as_of.
179
171
Returns a 4-tuple of ints, consisting of:
180
172
(No. mandatory exercises completed,
181
173
Total no. mandatory exercises,
190
182
# Get the student's pass/fail for each exercise in this worksheet
191
183
for worksheet_exercise in worksheet.worksheet_exercises:
192
184
exercise = worksheet_exercise.exercise
193
worksheet = worksheet_exercise.worksheet
194
185
optional = worksheet_exercise.optional
196
done, _ = get_exercise_status(store, user, worksheet_exercise, as_of)
187
done, _ = get_exercise_status(store, user, exercise)
197
188
# done is a bool, whether this student has completed that problem
203
194
if done: mand_done += 1
205
196
return mand_done, mand_total, opt_done, opt_total
207
def calculate_mark(mand_done, mand_total):
208
"""Calculate a subject mark, given the result of all worksheets.
209
@param mand_done: The total number of mandatory exercises completed by
210
some student, across all worksheets.
211
@param mand_total: The total number of mandatory exercises across all
212
worksheets in the offering.
213
@return: (percent, mark, mark_total)
214
percent: The percentage of exercises the student has completed, as an
215
integer between 0 and 100 inclusive.
216
mark: The mark the student has received, based on the percentage.
217
mark_total: The total number of marks available (currently hard-coded
220
# We want to display a students mark out of 5. However, they are
221
# allowed to skip 1 in 5 questions and still get 'full marks'.
222
# Hence we divide by 16, essentially making 16 percent worth
223
# 1 star, and 80 or above worth 5.
225
percent_int = (100 * mand_done) // mand_total
227
# Avoid Div0, just give everyone 0 marks if there are none available
229
# percent / 16, rounded down, with a maximum mark of 5
231
mark = min(percent_int // 16, max_mark)
232
return (percent_int, mark, max_mark)
234
def update_exerciselist(worksheet):
235
"""Runs through the worksheetstream, generating the appropriate
236
WorksheetExercises, and de-activating the old ones."""
238
# Turns the worksheet into an xml stream, and then finds all the
239
# exercise nodes in the stream.
240
worksheetdata = genshi.XML(worksheet.get_xml())
241
for kind, data, pos in worksheetdata:
242
if kind is genshi.core.START:
243
# Data is a tuple of tag name and a list of name->value tuples
244
if data[0] == 'exercise':
250
if attr[0] == 'optional':
251
optional = attr[1] == 'true'
253
exercises.append((src, optional))
255
# Set all current worksheet_exercises to be inactive
256
db_worksheet_exercises = Store.of(worksheet).find(WorksheetExercise,
257
WorksheetExercise.worksheet_id == worksheet.id)
258
for worksheet_exercise in db_worksheet_exercises:
259
worksheet_exercise.active = False
261
for exerciseid, optional in exercises:
262
worksheet_exercise = Store.of(worksheet).find(WorksheetExercise,
263
WorksheetExercise.worksheet_id == worksheet.id,
264
Exercise.id == WorksheetExercise.exercise_id,
265
Exercise.id == exerciseid).one()
266
if worksheet_exercise is None:
267
exercise = Store.of(worksheet).find(Exercise,
268
Exercise.id == exerciseid
272
worksheet_exercise = WorksheetExercise()
273
worksheet_exercise.worksheet_id = worksheet.id
274
worksheet_exercise.exercise_id = exercise.id
275
Store.of(worksheet).add(worksheet_exercise)
276
worksheet_exercise.active = True
277
worksheet_exercise.seq_no = ex_num
278
worksheet_exercise.optional = optional
added
removed
ivle/worksheet.py
