Database application to manage tutorweb question assignment and scores.

See https://github.com/tutorweb/tutorweb.buildout for more information.

During the unit tests, the database is available through:

sqlite3 $(ls -1t /tmp/tmp*twquizdb.db | head -1)

SET global log_output = 'FILE'; SET global general_log_file='/tmp/mysql_general.log'; SET global general_log = 1;

Useful for upgrades, you can print out the SQL for a table using CreateTable:

>>> from sqlalchemy.schema import CreateTable
>>> from sqlalchemy.dialects import mysql
>>> from tutorweb.quizdb import db
>>> print CreateTable(db.Allocation.__table__).compile(dialect=mysql.dialect())

• tutorweb.quizdb returns timestamps as seconds-since-epoch (UTC-ish)
• sqlalchemy takes / returns TZ-naive Python datetime
  • Need to ensure datetime conversion is done using UTC.
• Stored as MySQL datetime, so no timezone conversion or storage.