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

westwesterson’s picture

This 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.

goose2000’s picture

Yes, views is always good. Revisions too, thank you for the hard work .

kscheirer’s picture

I'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.

turadg’s picture

This is fixed in Quiz 3.0, right?

  • Commit 2656795 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x by kscheirer:
    issue #169023 committed for testing, has open bugs
    
    

  • Commit 2656795 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, quiz-pages by kscheirer:
    issue #169023 committed for testing, has open bugs
    
    
djdevin’s picture

Component: Code » Code - Quiz core
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (fixed)

  • Commit 2656795 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, quiz-pages, 2269219 by kscheirer:
    issue #169023 committed for testing, has open bugs
    
    

  • Commit 2656795 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, 2269219 by kscheirer:
    issue #169023 committed for testing, has open bugs