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	dpavlin	245	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