• to make passenger restart: touch /pub/www/compendium-acc/tmp/restart.txt
• RAILS_ENV=acceptance rails c to start console in acceptance environment
• Reset db on acceptance (shouldnt ever have to do this)
  service apache2 stop (as root)
  RAILS_ENV=acceptance rake db:migrate:resetdb:seed (as compendium user)
  service apache2 start (as root)

molotov.terena.org

acceptance and integration

import legacy compendia

Parse legacy HTML pages.

Visit a legacy compendium, go to all the sections and click on edit and save the file to /lib/legacy/<year>/file.html

Also create a folder in /db/legacy/<year>

run: rake legacy:convert:questions_2010 to import the questions to the new compendium.

Import legacy db

Make an .sql dump of the legacy compendium

Locally create a new database and import the legacy data in it:

$ psql -h localhost -U compendium postgres

postgres=> create database compendium2010;

$ psql -h localhost -U compendium compendium2010 < compendium2010.sql

(You might want to remove all the GRANT calls from the .sql file first!)

Another thing to note is that you have to run this as compendium user.

rake legacy:answers_2010