#!/bin/bash

DATE=$(date +"%Y%m%d%H%M")

TITAN_DB=./Databases/Prisma_Titan_$DATE
IAPETUS_DB=./Databases/Prisma_Iapetus_$DATE
ENCALADUS_DB=./Databases/Prisma_Encaladus_$DATE

TITAN_CSV=./CSVDumps/Prisma_Titan.csv
IAPETUS_CSV=./CSVDumps/Prisma_Iapetus.csv
ENCALADUS_CSV=./CSVDumps/Prisma_Encaladus.csv

cp "/home/alphasheep/puzzletimer.h2.db" $TITAN_DB.h2.db
scp alphasheep@192.168.8.143:~/puzzletimer.h2.db $IAPETUS_DB.h2.db
scp alphasheep@192.168.8.144:~/puzzletimer.h2.db $ENCALADUS_DB.h2.db


java -cp h2-latest.jar org.h2.tools.RunScript -url jdbc:h2:$TITAN_DB -user sa -driver org.h2.Driver -script csvwrite.sql
mv dump.csv $TITAN_CSV

java -cp h2-latest.jar org.h2.tools.RunScript -url jdbc:h2:$IAPETUS_DB -user sa -driver org.h2.Driver -script csvwrite.sql
mv dump.csv $IAPETUS_CSV

java -cp h2-latest.jar org.h2.tools.RunScript -url jdbc:h2:$ENCALADUS_DB -user sa -driver org.h2.Driver -script csvwrite.sql
mv dump.csv $ENCALADUS_CSV