#! /bin/sh


ODDB_HOME='/home/masa/ywesee'

yyyy=`date -d '1 days ago' +"%Y"`
mm=`date -d '1 days ago' +"%m"`
dd=`date -d '1 days ago' +"%d"`

m=(dummy January February March April May June July August September October November December)
#echo ${m[01]}
nm=`expr $mm + 0`
#echo ${m[nm]}


#sudo -u postgres dropdb oddb
#sudo -u postgres dropdb oddb.org
sudo -u postgres dropdb oddb.org.ruby193
#sudo -u postgres createdb -E UTF8 -T template0 oddb
#sudo -u postgres createdb -E UTF8 -T template0 oddb.org
sudo -u postgres createdb -E UTF8 -T template0 oddb.org.ruby193
#cd /home/masa/ywesee/oddb.org/
cd $ODDB_HOME/oddb.org


mkdir data/sql


#scp ywesee@thinpower.ywesee.com:/var/backup/thinpower/db/postgresql/August-2010/2010-08-10/22\:00-postgresql_database-oddb_dot_org-backup.gz data/sql/oddb.2010.08.10.sql.gz
#echo "ywesee@thinpower.ywesee.com:/var/backup/thinpower/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/22\:00-postgresql_database-oddb_dot_org-backup.gz data/sql/oddb.$yyyy$mm$dd.sql.gz"
#scp ywesee@thinpower.ywesee.com:/var/backup/thinpower/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-0$dd/22\:00-postgresql_database-oddb_dot_org-backup.gz data/sql/oddb.$yyyy$mm$dd.sql.gz


#scp ywesee@thinpower.ywesee.com:/var/backup/thinpower/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/22\:00-postgresql_database-oddb_dot_org-backup.gz data/sql/oddb.org.$yyyy$mm$dd.sql.gz
scp ywesee@thinpower.ywesee.com:/var/backup/thinpower/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/22\:00-postgresql_database-oddb.org.ruby193-backup.gz data/sql/oddb.org.ruby193.$yyyy$mm$dd.sql.gz


cd data/sql

#zcat oddb.2010.08.10.sql.gz | psql -U postgres oddb
#echo "oddb.$yyyy$mm$dd.sql.gz | psql -U postgres oddb"
zcat oddb.org.ruby193.$yyyy$mm$dd.sql.gz | psql -U postgres oddb.org.ruby193