#!/bin/bash
for i in flipkey_production pm_scraping pil source_manager fatjoe 
do
    echo $i
    dbsync $i schema
    dbsync $i data
    rm /data/flippy/dbcache/$i.*
done

echo $i
dbsync cache_backup schema

for i in owner partner scraping flipkey
do
    echo "source_$i"
    sed "s/SOURCE_DB_TEMPLATE/source_$i/" ~/schema/source_template_schema_sync.sql > ~/schema_temp.sql
    mysql -u flipkey -pfl1p3gg5 source_$i < ~/schema_temp.sql
    mysql -u flipkey -pfl1p3gg5 source_$i -e "call source_${i}_schema_sync();"
done
rm ~/schema_temp.sql