data/stats/import-tsv.sh

pipe=/tmp/strix-import
db=a3c

if [ -z "$1" ] ; then
        echo "Usage: $0 export.tsv"
        exit
else
        file=$1
        table="strix_`basename $file | sed 's/.tsv$//'`";
fi

mkfifo $pipe

echo "** importing $table from $1"

psql -c "delete from $table" $db
psql -c "\copy $table from '$pipe' with delimiter '     '" $db &
cat -n $file | sed 's/^ *//' > $pipe
psql -c "select count(*) from $table" $db
1	pipe=/tmp/strix-import
2	db=a3c
3
4	if [ -z "$1" ] ; then
5	echo "Usage: $0 export.tsv"
6	exit
7	else
8	file=$1
9	table="strix_`basename $file \| sed 's/.tsv$//'`";
10	fi
11
12	mkfifo $pipe
13
14	echo "** importing $table from $1"
15
16	psql -c "delete from $table" $db
17	psql -c "\copy $table from '$pipe' with delimiter ' '" $db &
18	cat -n $file \| sed 's/^ *//' > $pipe
19	psql -c "select count(*) from $table" $db