Continuous Integration Test Plan

Setup

OS

Linux (Ubuntu, Lucid)

 apt-get install -y default-jre default-jdk
 apt-get install -y postgresql libpq-dev
 apt-get install -y mysql-server # leave password blank when prompted

OSX (10.6.5)

 cd /tmp # important
 port install mysql5-server
   # follow setup instrs
   port load mysql5-server
 port install postgresql90-server
   # follow setup instrs
   port load postgresql90-server

Interpreters

 rvm install ruby-1.8.7-p334
 rvm install ruby-1.9.2-p180
 rvm install rbx-1.2.1
 rvm install jruby-1.5.6
 rvm install jruby-1.6.0.RC2

System Gems

 for interp in ruby-1.8.7-p334 ruby-1.9.2-p180 rbx-1.2.1 jruby-1.5.6 jruby-1.6.0.RC2; do
   rvm use $interp;
   rvm gemset create do;
   rvm gemset use do;
   rvm gemset import do.gems;
 done

do.gems

 addressable -v2.2.4 --ignore-dependencies
 bacon -v1.1.0 --ignore-dependencies
 bundler -v1.0.10 --ignore-dependencies
 git -v1.2.5 --ignore-dependencies
 jeweler -v1.5.2 --ignore-dependencies
 rake-compiler -v0.7.0 --ignore-dependencies
 jdbc-mysql 
 jdbc-postgres
 jdbc-sqlite3
 jdbc-h2
 jdbc-hsqldb
 jdbc-derby

Databases

PostgreSQL

Database

 # ensure last 3 active lines of /etc/postgresql/*/main/pg_hba.conf read:
   local   all         all                               trust
   host    all         all         127.0.0.1/32          trust
   host    all         all         ::1/128               trust
 # restart database
 sudo createdb do_test

User Permissions

 sudo -u postgres createuser --superuser root

MySQL

Database

 mysqladmin -u root create do_test

Ramdisk

 /etc/init.d/mysql stop
 cd /var/lib
 mv mysql mysql.hd
 mkdir mysql.mem
 mount -t tmpfs -o size=128M none mysql.mem
 cp -rav mysql.hd/* mysql.mem/
 ln -s mysql.mem mysql
 /etc/init.d/mysql start