gistfile1.txt

CREATE TABLE `workflows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `model_type` varchar(255) DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `params` text,
  `folder` text,
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8

CURRENT Schema for Workflows:

create_table "workflows", :force => true do |t|
t.integer "site_id", :null => false
t.integer "model_id", :null => false
t.string "hostname"
t.datetime "start_date"
t.datetime "end_date"
t.text "params"
t.text "outdir"
t.datetime "started_at"
t.datetime "finished_at"
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "advanced_edit", :default => false
end

my shell script:

!/bin/bash

wget -O betydump.sql http://isda.ncsa.illinois.edu/~kooper/EBI/betydump.sql
mysql -u bety -pbety -e 'DROP DATABASE IF EXISTS bety; CREATE DATABASE bety'
mysql -u bety -pbety bety < betydump.sql

echo "SELECT id from machines WHERE hostname='ebi-forecast.igb.uiuc.edu' INTO @mid;
UPDATE dbfiles SET file_path=REPLACE(file_path, 'ebi-forecast.igb.uiuc.edu:', ''), machine_id=@mid WHERE file_path LIKE 'ebi-forecast.igb.uiuc.edu:/%';
SELECT id from machines WHERE hostname='ebi-cluster.igb.uiuc.edu' INTO @mid;
UPDATE dbfiles SET file_path=REPLACE(file_path, 'ebi-cluster.igb.uiuc.edu:', ''), machine_id=@mid WHERE file_path LIKE 'ebi-cluster.igb.uiuc.edu:/%';
UPDATE dbfiles SET file_path=REPLACE(file_path, '//', '/') WHERE file_path LIKE '%//%';
UPDATE dbfiles SET machine_id=@mid WHERE ISNULL(machine_id);" | mysql -u bety -pbety bety

add remote sites back in

(cd ~/sites && ./addsites.sh)

add models back in

echo "INSERT INTO models (model_name, model_path, revision, created_at, updated_at) VALUES
('ED2.2', '${HOSTNAME}:/usr/local/bin/ed.r46', '46', NOW(), NOW()),
('ED2.2', '${HOSTNAME}:/usr/local/bin/ed.r82', '82', NOW(), NOW()),
('BIOCRO', '${HOSTNAME}:/usr/local/bin/ed.r82', '0', NOW(), NOW()),
('SIPNET', '${HOSTNAME}:/usr/local/bin/sipnet.runk', 'unk', NOW(), NOW());" | mysql -u bety -pbety bety

mysql -u bety -pbety bety -e 'DROP VIEW yieldsview'

(cd /usr/local/bety && sudo rake db:migrate)

echo " update inputs, dbfiles set format_id=10 where inputs.file_id=dbfiles.file_id and dbfiles.file_path like '%site';
update inputs, dbfiles set format_id=11 where inputs.file_id=dbfiles.file_id and dbfiles.file_path like '%css';
update inputs, dbfiles set format_id=15 where inputs.file_id=dbfiles.file_id and dbfiles.file_path like '%pss';
update inputs, dbfiles set format_id=24 where inputs.file_id=dbfiles.file_id and dbfiles.file_path like '%clim'; " | mysql -u bety -pbety bety