#!/bin/sh

TABLES="envdata_ArunPlatform_met envdata_ArunPlatform_tide envdata_BidefordBay envdata_Boscombe envdata_Bracklesham envdata_Chesil envdata_Deal_met envdata_Deal_tide envdata_Folkestone envdata_Folkestone_met envdata_Goodwin envdata_HaylingIsland envdata_HerneBay_met envdata_HerneBay_tide envdata_Hornsea envdata_LooeBay envdata_LooeBay_met envdata_Lymington_met envdata_Lymington_tide envdata_Milford envdata_Minehead envdata_Penzance envdata_Perranporth envdata_PevenseyBay envdata_RhylFlats envdata_Rustington envdata_Rye envdata_SandownBay envdata_SandownPier_met envdata_SandownPier_tide envdata_Seaford envdata_StartBay envdata_SwanagePier_met envdata_SwanagePier_tide envdata_TeignmouthPier_met envdata_TeignmouthPier_tide envdata_Torbay envdata_WestBay envdata_WestBayPier_met envdata_WestBayPier_tide envdata_WestonBay envdata_Weymouth envdata_Weymouth_met"
# TABLES="envdata_ArunPlatform_met"

# DBLOCAL="mysql --user=riben --password=v0ucher1 --database=riben"
# DBREMOTE="mysqldump --user=riben --password=v0ucher1"

DBMIRROR="mysql --user=cco --password=55Btqn5uKLNGSEPA --host=env.ecs.soton.ac.uk --port=4040 --database=CCO"
DBORIG="mysqldump --user=cco --password=channel"
DB="cco"

update()
{

  # find the timestamp of the most recent data in the target table

  TIMESTAMP_LATEST=`$DBMIRROR -BN -e "select timestamp from $1 order by timestamp desc limit 1"`

  echo -- $1 $TIMESTAMP_LATEST `$DBMIRROR -BN -e "select from_unixtime(timestamp) from $1 order by timestamp desc limit 1"`

  # dump some newer data from the main database

  DUMP=`$DBORIG -et --comments=FALSE -w "timestamp>$TIMESTAMP_LATEST limit 200" $DB $1 | grep -E "^INSERT|LOCK|KEYS"`

  DUMP=${DUMP//INSERT/REPLACE}

  # echo $DUMP

  # bung it in the target database

  echo $DUMP | $DBMIRROR

}


for i in $TABLES
do
  update $i
done