#!/bin/bash

#echo Content-type: text/plain

#echo ""

## Creating a realized view for analysis from Data Warehouse, a single useful table of specimen records plus plot abundances

## 22 May 2010 at NCEAS server Nimoy

## Executed June 2011 from /home/condit at Nimoy

## ./CreateViews.bat bien2 100000 both condit darter329  (100000 entries for testing)

## ./CreateViews.bat bien2 0 both condit darter329       (full table)

db=$1

rows=$2

addindex=$3

user=$4

pwd=$5

if [ -z $rows ]

 then  

   echo "Create viewFullOccurrence table"

   echo "first argument: database"

   echo "second: number of rows for testing; enter 0 for full table"

   echo "third argument: no to create table without indices; yes to add indices without creating table; both to do both"

   echo "fourth: mysql user"

   echo "last: password"

   exit

fi

locktb="LOCK TABLES viewFullOccurrence WRITE, 

                    IndividualObservation AS IO WRITE, 

                    ObservationSpecimen AS OS WRITE, 

                    TaxonDimension AS TD WRITE, 

                    SpecimenSourceData AS SSD WRITE, 

                    PlotAggregateFact AS PAF WRITE, 

                    PlotMetaDataDimension AS PMD WRITE, 

                    PlotTimeDimension AS PTD WRITE,

                    geoPlotMetaDataDimension AS gPMDD WRITE, 

                    geoIndividualObservation AS gIO WRITE;"

mysql -u "$user" -p"$pwd" --database="$db" --execute="$locktb"

# echo $locktb

if [ $addindex != "yes" ] 

  then

   mysql -u "$user" -p"$pwd" --database="$db" --execute="CALL CreateView($rows,0);"

fi

if [ $addindex != "no" ] 

 then

   mysql -u "$user" -p"$pwd" --database="$db" --execute="CALL AddViewIndex();"

fi

# These could depend on command-line arguments as well

mysql -u "$user" -p"$pwd" --database="$db" --execute="CALL CorrectPctCover;"

# mysql -u "$user" -p"$pwd" --database="$db" --execute="CALL CTFSFamily;"

mysql -u "$user" -p"$pwd" --database="$db" --execute="UNLOCK tables;"