b.larik

#!/bin/bash

db=$1

# This script updates all dbs to use unicode

dbhost='localhost'
username='larik'
odir=${HOME}/CMS_UPGRADE

if [ "${db}X" == "X" ]
then
   echo "I need a db for host ${dbhost} and username ${username} $db"
   exit
fi

if [ ! -d $odir ]
then
   mkdir $odir || exit "Exit at mkdir"
fi

dump_sql=${odir}/${db}_out.sql
conv_sql=${odir}/${db}_conv.sql
result_sql=${odir}/${db}_result.txt
sql_diff=${odir}/${db}.diff

extra_string="database: ${db}, host: ${dbhost}, user: ${username}"

# Wat dient er te gebeuren:

# 1. Dump database

pg_dump --host=$dbhost --username=$username -D --file=$dump_sql --format=p $db || exit "exit at pg_dump ${extra_string}"

# 2. Remove invalid characters from the dump

/sw/bin/iconv -c -f UTF-8 -t UTF-8 ${dump_sql} > ${conv_sql}  || exit "exit at iconv ${extra_string}"

# 3 Make a diff from the dump

diff $dump_sql $conv_sql > $sql_diff

# 4. Remove current database

dropdb --host=$dbhost --username=$username $db || exit "exit at dropdb ${extra_string}"

# 5. Create a new databse

createdb --encoding='unicode' --host=$dbhost --username=$username $db || exit "exit at createdb ${extra_string}"

# 6. Load the data into the database you've created in step 2
psql -f $conv_sql -o $result_sql -h $dbhost -U $username $db || exit "exit at psql ${extra_string}"