Ready-to-use data set

[CatalinFrancu]

Right now we start off with a mostly empty data set. It takes time for a developer to set up a meaningful database with users, roles, problems, rounds, submitted sources and everything.

It would be nice to have a way to set up a ready-to-use data set. Then we could just run a script or import some SQL statements and have some meaningful data covering many cases: upcoming / ongoing / finished rounds, sources submitted for problems before / during / after a round, evaluation reports and so on.

One simple idea is to have one SQL file. The reset procedure would then be

• drop the database
• create the database
• run the SQL file
• run migration.php in case the SQL file uses a slightly older schema

This won't work for attachments - attachments have both a DB record and a file under uploads. Hopefully we can automate this part too.