#! /bin/sh
#
# Load the databasetables into postgreSQL and create the
# difference tables.
#
# Use: InsertCompressAudio [--SQL] [<name>]
#
# <name> name prefix of the compression type, e.g., Ogg or MP3
# --SQL  Do NOT load the tables, but only recalculate the SQL scripts
#
# Copyright (C) 2002  R.J.J.H. van Son
#
#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
# 
#    
# Copyright (C) 2002  R.J.J.H. van Son
#
#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
# 
#
#
# Save current working directory
LASTPWD=$PWD
#
# Construct the difference tables
# Switch to the directory with the psql scripts
cd ../DatabaseFiles/scripts/SQL/
#
# Get the database address and name from the Links file
dbaddress=$(perl -e 'require "../../../../../Links.pl";print "$DBMSaddress";')
dbname=$(perl -e 'require "../../../../../Links.pl";print "$DBMSname";')
# Run the PostgreSQL scripts
# Pitch
echo "-h $dbaddress -d $dbname -f compressPitchdiff.sql"
psql -h $dbaddress -d $dbname -f compressPitchdiff.sql
# Center of Gravity
echo "-h $dbaddress -d $dbname -f compresscogdiff.sql"
psql -h $dbaddress -d $dbname -f compresscogdiff.sql
# Formants 
echo "-h $dbaddress -d $dbname -f compressF1diff.sql"
psql -h $dbaddress -d $dbname -f compressF1diff.sql
#
echo "-h $dbaddress -d $dbname -f compressF2diff.sql"
psql -h $dbaddress -d $dbname -f compressF2diff.sql
#
echo "-h $dbaddress -d $dbname -f compressF3diff.sql"
psql -h $dbaddress -d $dbname -f compressF3diff.sql
#
# Go back
cd $LASTPWD