A number of issues have mentioned a need for some work on the database schema.
Currently results are not stored (they are recalculated every time its needed),
and some of the data is stored in a serialized format, making writing efficient
queries impossible.
Specifically, this makes view integration
difficult if not impossible. Storing more regular results could not only allow views,
but all sorts of reporting possibilities.
Additionally, to make the module more suitable for academic applications, using
drupal's node revisioning system could really help out. It would be totally optional
to use, but allow both questions and quizzes to be revisioned. So for example a quiz
is created with some questions, and some people take it and get results. Then an
admin edits a question, or adds a new question, and now its (optionally) a new version
of the quiz. So results from the original quiz are not equivalent to results from the new revision.
As long as there were update scripts to move from the old schema to the new schema,
the versioning system is pretty transparent to the user, and uses the standard drupal system.
I plan on having a patch available this week for folks to evaluate, so please let me know
if there are other related features that would be a good idea.
Comments
Comment #1
westwesterson commentedThis is great news. And I think a necessary step in development of the module. This will make quizzes more meaningful, and if you accidentally change something, or some other administrator does, you have the backup right there. Can't wait for this improvement. Was gonna do it myself, but this will have a much more reliable upgrade path.
Comment #2
goose2000 commentedYes, views is always good. Revisions too, thank you for the hard work .
Comment #3
kscheirerI've committed some changes to HEAD for testing purposes.
I wanted to get them into CVS for safety, and so other people
can see whats going on.
known problems:
the "number of questions" or "random questions" is still broken. I didn't update this to use the new db schema, since we're likely going to change the way this works anyway.
the quiz revision checkbox on the manage questions page is ignored, it always makes a new revision right now.
no update hook for the install files to migrate old data.
Comment #4
turadg commentedThis is fixed in Quiz 3.0, right?
Comment #7
djdevin