40 lines
748 B
Bash
40 lines
748 B
Bash
|
# Dec. 2004, M. Spiekermann
|
||
|
|
#
|
||
|
|
# This script creates the relations of the TPC-H
|
||
|
|
# database and imports the data into a Postgres
|
||
|
|
# database. The data created by dbgen must be located
|
||
|
|
# in the current directory.
|
||
|
|
|
||
|
|
if [ "$1" == "" ]; then
|
||
|
|
echo -e "\n Usage: $0 <dbname> [<table-dir>]\n\n"
|
||
|
|
exit 1
|
||
|
|
fi
|
||
|
|
|
||
|
|
db="$1"
|
||
|
|
PATH=".:$PATH"
|
||
|
|
|
||
|
|
tbl_dir="$PWD"
|
||
|
|
if [ "$2" != "" ]; then
|
||
|
|
tbl_dir="$2"
|
||
|
|
fi
|
||
|
|
|
||
|
|
|
||
|
|
# convert data suitable for the Postgres copy command
|
||
|
|
echo -e "\n*** Preparing data files ***\n"
|
||
|
|
for file in $tbl_dir/*.tbl
|
||
|
|
do
|
||
|
|
if [ ! -e $file.pg ]; then
|
||
|
|
echo -e "Converting $file ...\n"
|
||
|
|
rm-lastsep.sh $file
|
||
|
|
fi
|
||
|
|
done
|
||
|
|
|
||
|
|
# create a database
|
||
|
|
createdb $db
|
||
|
|
|
||
|
|
# create relations
|
||
|
|
psql -e -f"create_tbls_64bit.sql" -d"$db"
|
||
|
|
|
||
|
|
# import data
|
||
|
|
import_tbls.sh $db $tbl_dir
|