compendium2

• 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 (note that you have to run this import as compendium user)

$ 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!)

Now import the legacy database to the new compendium:

$ rake legacy:answers_2010