#!/bin/bash
#Mantiki imageMediaLoader
#by Zarren Spry <zarren.spry@virginwines.co.uk>

# Don't run as root
if [ $USER = "root" ]; then
        echo "ERROR: The deploy script should not be run as root user"
        echo "Please run it as the 'env user' "
        echo usage
        exit 1
fi

#VARS
DATADIR="/vwnfs/mantiki/imageMediaLoader/interfaces/data/inbox/imageMediaLoader"
MYSQL_HOST="masterdb.ferrum.local"
MYSQL_USER="vwshopstg"
MYSQL_PASSWORD="vwshopstg"
MYSQL_DB="vwshopstg"
BOTTLEIMG_DIR="/vwnfs/mantiki/bottleImages"
MEDIA_DIR="/vwnfs/mantiki/media"

echo "Clean up old files!"
rm -rf $DATADIR/work/*
rm -rf $DATADIR/control/*
rm -rf $DATADIR/images/*

echo "Create control files."
echo "Creating $DATADIR/control/create-image-control-file-png.sql"
cat >$DATADIR/control/create-image-control-file-png.sql <<EOL
select '"Filename","Media Class","Media subclass","Store code"," Key","Attribute","Preserve filename","Description","Alt Text","Title","Caption","Tags","Remove original"' as ''
union
select concat('"', p.product_code, '.png",  "Product", "", "default", "', p.product_code, '", "product_images", "0", "', p.name , '", "', p.name, '", "', p.name, '", "', p.name, '", "', p.name, '", "0"') as ''
from product p
where p.product_code like 'Z%'
union
select concat('"', left(p.product_code, 6), '_XL.jpg",  "Product", "", "default", "', p.product_code, '", "product_images", "0", "', p.name , '", "', p.name, '", "', p.name, '", "', p.name, '", "', p.name, '", "0"') as ''
from product p
where p.product_code like 'Y%';
EOL

echo "$DATADIR/images/create-wgets.sql"
cat >$DATADIR/images/create-wgets.sql <<EOL
select concat('wget http://d1f6pkbpgobziu.cloudfront.net/media2/lib/images/productimages/', p.product_code, '_HiRes.jpg') as ''
from product p
where p.product_code like 'Z%'
union
select concat('wget http://d1f6pkbpgobziu.cloudfront.net/media2/lib/images/caseshots/', left(p.product_code, 6), '_XL.jpg') as ''
from product p
where p.product_code like 'Y%';
EOL

echo "Running processes."
mysql -D$MYSQL_DB -u$MYSQL_USER -p$MYSQL_PASSWORD -h$MYSQL_HOST < $DATADIR/control/create-image-control-file-png.sql > $DATADIR/control/control.csv
rm -f $DATADIR/control/create-image-control-file-png.sql

cp $BOTTLEIMG_DIR/* $DATADIR/images/
mysql -D$MYSQL_DB -u$MYSQL_USER -p$MYSQL_PASSWORD -h$MYSQL_HOST < $DATADIR/images/create-wgets.sql > $DATADIR/images/wget.sh
chmod u+x $DATADIR/images/wget.sh
rm -f $DATADIR/images/create-wgets.sql

$DATADIR/images/wget.sh

mysql -D$MYSQL_DB -u$MYSQL_USER -p$MYSQL_PASSWORD -h$MYSQL_HOST <<EOL
SELECT * FROM process_control_attribute  WHERE process_control_id  IN (SELECT id FROM process_control WHERE name='Media Images Loader');

UPDATE process_control_attribute SET value='$DATADIR/processed' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='processed.dir';
UPDATE process_control_attribute SET value='$DATADIR/work' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='working.dir';
UPDATE process_control_attribute SET value='$DATADIR/error' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='error.dir';
UPDATE process_control_attribute SET value='$DATADIR/control' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='control.dir';
UPDATE process_control_attribute SET value='$DATADIR/images' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='images.dir';
UPDATE process_control_attribute SET value='$DATADIR/log' WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader') AND name='log.dir';


DELETE FROM mantiki_config WHERE name='media.format.aspect.ratio.tolerance';
INSERT INTO mantiki_config
( name, value, version, created_by, created_on,last_modified_by,last_modified_on)
VALUES
('media.format.aspect.ratio.tolerance', 10, 1, 1, now(), 1, now());

UPDATE  process_control SET state='Idle', sequence_number_handling='None' WHERE name='Media Images Loader';

DELETE FROM process_run WHERE process_control_id=(SELECT id FROM process_control WHERE name='Media Images Loader');
EOL

rm -rf $MEDIA_DIR/staging-media-base/shared/Product/*
rm -rf $MEDIA_DIR/staging-media-base/shared/product/*

echo "Running imageMediaLoader, this may take over an hour so please be patient."
$DATADIR/bin/imageMediaLoader.sh 2>&1 /dev/null

echo "Process complete ! Please rebuild index."