- to make passenger restart: touch /pub/www/compendium-acc/tmp/restart.txt
- RAILS_ENV=acceptance rails c to start console in acceptance environment (as compendium user obviously!)
- 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!)
Create a /lib/legacy/2010/schema.rb with the custom table 'translations' and add the new database environment to config/database.yml
Now import the legacy database to the new compendium:
$ rake legacy:answers_2010
This will create /db/legacy/2010/answers.yml
Running the seed
To prevent everything from being seeded, comment out the imports you do NOT want
$ rake db:migrate:reset db:seed