#!/bin/sh

# primero hacemos un revert de todo
echo "svn revert"
svn revert -R *


# empezamos con postgresql 8.2
if [[ "$1" == "pg8.2" ]] ; then
  echo "##########################"
  echo "#  postgresql 8.2 test   #"
  echo "##########################"
elif  [[ "$1" == "pg8.3" ]] ; then
  echo "##########################"
  echo "#  postgresql 8.3 test   #"
  echo "##########################"
elif  [[ "$1" == "oracle" ]] ; then
  echo "##########################"
  echo "#  oracle test           #"
  echo "##########################"
else
  echo "unsoported database"
  exit 0
fi
cp config/Openbravo.properties.$1 config/Openbravo.properties
echo "create database 1"
ant create.database >> testlog/$1_cd_1.log
echo "export database 1"
ant export.database >> testlog/$1_ed_1.log
echo "diff complete 1"
svn diff >> testlog/$1_diff_1.diff
echo "diff triggers 1"
svn diff database/model/triggers >> testlog/$1_triggers_1.diff
echo "diff functions 1"
svn diff database/model/functions >> testlog/$1_functions_1.diff
echo "create database 2"
ant create.database >> testlog/$1_cd_2.log
echo "export database 2"
ant export.database >> testlog/$1_ed_2.log
echo "diff complete 2"
svn diff >> testlog/$1_diff_2.diff
echo "diff results"
diff testlog/$1_diff_1.log testlog/$1_diff_2.diff