build_site.sh

#!/usr/bin/env bash
# build_site.sh by Amory Meltzer
# Parse data, build index, piece together html


function get_help {
    cat <<END_HELP

Usage: $(basename $0) -i <current_season.xlsx> [-u]

  -i		Specify input XLS/XLSX data file.  Required.
  -u		Pass -u to makeMLSTable.pl (updates 'current as of' date)
  -h		this help
END_HELP
}

while getopts 'i:ulhH?' opt; do
    case $opt in
	i) input=$OPTARG;;
	u) upDate='-u';;
	h) get_help $0
	   exit 0;;
    esac
done


# Coming from perl, bash's flexibility with variables makes me uncomfortable
function print() {
    cat $top > $index
    cat $news >> $index
    cat $chart >> $index
    cat $table >> $index
    cat $arc >> $index
    cat $bottom >> $index
    cat templates/site_footer >> $index

    # Indent html
    emacs -batch $index --eval '(indent-region (point-min) (point-max) nil)' -f save-buffer 2>/dev/null
}

# Simple error handling
function dienice() {
    echo "$1"
    exit 1
}


# some basic checks before getting started
if [ ! "$input" ]; then
    dienice "Please specify an XLS/XLSX data file"
elif [[ ! -a "$input" ]]; then
    dienice "$input does not exist"
elif [ ! $(echo "$input" | grep -oE "\.xlsx?$") ]; then
    dienice "$input is not an XLS/XLSX file"
else
    # Main process: parses master excel and produces/calculates all data
    perl multipleWorksheets.pl "$input"

    # Die angrily if xlsx processing fails
    if [ $? != 0 ]; then
	echo
	echo "Aborting.  Cleanup likely needed."
	exit
    else
	echo
    fi

    # Get all the games and seasons and tournaments that need linking to
    SUBS=$(find -E . -regex "./mls_.*_.*.csv" -o -regex "./mls_t....csv" | grep -v _site)
    # Generate archive index lists via
    perl makeArchiveIndex.pl $SUBS

    # Grab everything...
    FILES=$(find -E . -maxdepth 1 -regex "./.*_t?[sfu][0-9][0-9].*csv" | grep -v _site)
    FILES="$FILES ./mls_master.csv" # Add lifetime totals
    FILES="$FILES ./mls_running.csv" # Add running totals

    # Die if no proper files can be found
    if [ -z "$FILES" ]; then
	dienice "No valid files found!!!"
    fi

    # Build pages
    echo "Creating html..."
    for csv in $FILES
    do
	chartnav=0 # Used later to identify new season navs that need mofidying

	# find insists on a leading ./ - I won't be providing such things when
	# running this but it's a good thing to watch out for when sanitizing
	csv=$(echo $csv | perl -pe 's/^.\///;')
	# Prune file format
	file=$(echo $csv | perl -pe 's/\.csv$//;')

	# Generate names of subfolders
	season=$(echo $file | grep -oE "t?[sfu][0-9][0-9]")
	game=$(echo $file | grep -oE "[0-9][0-9]\.[0-9][0-9]")

	# Set default values ahead of time
	index=index.html
	news=/dev/null
	chart=templates/chart
	arc=/dev/null

	# Build tables
	table=$(echo $file.table)
	# Tournaments are halfway between seasons and games
	# Should be able to make this more efficient FIXME TODO
	if [ $(echo $season | grep -oE "t[sfu][0-9][0-9]") ]; then
	    perl makeMLSTable.pl -ag $csv $table # Game index
	    chart=/dev/null
	elif [ $(echo $file | grep -oE "mls_[sfu][0-9][0-9]") ]; then
	    if [ $(echo $file | grep -oE "mls_[sfu][0-9][0-9]_") ]; then
		perl makeMLSTable.pl -ag $csv $table # Game index
	    else
		perl makeMLSTable.pl -a $csv $table # Season index

		#  Only show season chart if at least 3 games have been played
		if [ $(grep -c ^ $season/data/AB.csv) -lt 5 ]; then
		    chartnav=1
		    chart=/dev/null
		fi

		# Set here to avoid tourny errors FIXME TODO
		arc=templates/$season.list
	    fi
	elif [ $(echo $csv | grep -oE "mls_[mr][a-z]{5,6}.csv") ]; then
	    perl makeMLSTable.pl $upDate $csv $table
	fi

	# Check each folder individually, avoid overwriting any data
	if [[ -n $game ]]; then	# Individual game data
	    if [[ ! -d $season/$game ]]; then
		mkdir -p $season/$game/
	    fi
	    index=$season/$game/$index
	    chart=/dev/null
	    top=templates/game.index.top
	    arc=/dev/null
	    bottom=templates/game.index.bottom
	    print

	    mv $csv $table $season/$game
	elif [[ -n $season ]]; then # Season-total
	    if [[ ! -d $season ]]; then
		mkdir -p $season/
	    fi
	    # Only generate if season total
	    if [ $(echo $file | grep -oE "mls_t?[sfu][0-9][0-9]") ]; then
		index=$season/$index
		top=templates/season.index.top
		bottom=templates/season.index.bottom

		# Include TOC on season index, not tournaments
		# Cleanup, this is all so awkward FIXME TODO
		if [ ! $(echo $file | grep -oE "mls_t[sfu][0-9][0-9]") ]; then
		    news=templates/season.news
		fi

		print
		echo "Generated $index"
		if [ $chartnav == 1 ]; then
		    sed -i '' 's/^.*<li>.*statsgraph.*<.li>.*$//' $index
		fi
		chartnav=0
	    elif [ ! $(echo $file | grep -oE "mls_t?[sfu][0-9][0-9]") ]; then
		# Rename and be done with season-based stats
		# Stash in data directory
		if [[ ! -d $season/data/ ]]; then
		    mkdir -p $season/data/
		fi

		mv $csv $season/data/$(echo $csv | sed -E 's/_[sfu][0-9][0-9]//')
		continue
	    fi

	    # Organize data appropriately for seasons, not tournaments
	    if [ ! $(echo $file | grep -oE "mls_t[sfu][0-9][0-9]") ]; then
		mv $csv $table $season/data/
	    else
		mv $csv $table $season/
	    fi
	elif [ $(echo $csv | grep -oE "mls_master.csv") ]; then
	    if [[ ! -d life/data/ ]]; then
		mkdir -p life/data/
	    fi
	    index=life/$index
	    top=templates/season.index.top
	    news=templates/season.news
	    arc=templates/arc.list
	    bottom=templates/season.index.bottom
	    print
	    echo "Generated $index"

	    # Cleanup TOC
	    sed -i '' 's/Individual game /Season /' $index
	    # Cleanup arc
	    sed -i '' 's/<p>.*Lifetime stats<\/a> \&bull; /<p>/' $index

	    mv $csv $table life/data/
	elif [ $(echo $csv | grep -oE "mls_running.csv") ]; then
	    top=templates/top
	    news=templates/news
	    arc=templates/arc.list
	    bottom=templates/bottom
	    print
	    echo "Generated $index"

	    if [[ ! -d data/ ]]; then
		mkdir -p data/
	    fi
	    mv $csv $table data/
	else
	    echo "Warning: unable to properly file $csv"
	fi
    done

    # Move lifetime stats as well
    FILES=$(find -E . -maxdepth 1 -regex "./.{1,4}\.csv" | grep -v _site)
    for csv in $FILES
    do
	mv $csv life/data/$csv
    done

    # Move running stats
    FILES=$(find -E . -maxdepth 1 -regex "./running_.{1,4}\.csv" | grep -v _site)
    for csv in $FILES
    do
	mv $csv "data/${csv/running_/}"
    done

    echo
    echo "Site ready!"
fi