#!/bin/sh
DATADIR="data"
DESTDIR="."
LISTLONG="$DESTDIR/materials_long.txt"
LISTSHORT="$DESTDIR/materials_short.txt"
LISTCSV="$DESTDIR/materials.csv"
LISTPHP="$DESTDIR/materials.inc.php"
LISTMAT="$DESTDIR/materials.pm"

# Create the long list
echo "Generating long list..."
echo -n "Last updated: " > "$LISTLONG"
date >> "$LISTLONG"
echo "" >> "$LISTLONG"
for i in $DATADIR/*.mat; do
	echo "-------------------------------------------------------------------------------" >> "$LISTLONG"
	cat "$i" >> "$LISTLONG"
done


# Create the short and CSV lists
echo "Generating short list"
echo -n "Last updated: " > "$LISTSHORT"
date >> "$LISTSHORT"
echo "" >> "$LISTSHORT"
perl parsematerial.pl -head >> "$LISTSHORT"
cat $DATADIR/*.mat | perl -w parsematerial.pl >> "$LISTSHORT"

echo "Generating CSV"
cat $DATADIR/*.mat | perl -w parsematerial.pl -csv > "$LISTCSV"

echo "Generating PHP ..."
perl -w csv2phpsql.pl -php < "$LISTCSV" > "$LISTPHP"

echo "Generating Perl data ..."
perl -w csv2phpsql.pl -mat < "$LISTCSV" > "$LISTMAT"

echo "Uploading ..."
scp -C "$LISTLONG" "$LISTSHORT" "$LISTCSV" ccr@low.fi:public_html/bat/ &&
scp -C "$LISTPHP" ccr@low.fi:public_html/bat/mat/