#!/bin/bash
dbhost="localhost"
dbuser="kodi"
dbpassword="kodi"
kodihome="/home/kodi"

if [[ $# -lt 2 ]] || [[ $# -gt 2 ]]
then
    echo "Usage: ${0##*/} old_path new_path"
    echo "Escape special characters in paths or enclose in double quotes"
    exit 0
fi

echo -e "Updating Kodi media sources \nfrom '$1' \nto '$2'"
read -r -p "Are you sure? [y/N] " response
response=${response,,}    # tolower
if [[ ! "$response" =~ ^(yes|y)$ ]]
then
    exit 0
fi

#find highest numeric MyVideos / MyMusic db
videodb=$(mysql -h$dbhost -u$dbuser -p$dbpassword -e "show databases like 'MyVideos%';" 2>/dev/null | sort -g -r | head -1)
audiodb=$(mysql -h$dbhost -u$dbuser -p$dbpassword -e "show databases like 'MyMusic%';" 2>/dev/null | sort -g -r | head -1)
texturedb=$(ls $kodihome/.kodi/userdata/Database/Textures* | sort -g -r | head -1)

echo "Databases to adjust: $videodb $audiodb "$(basename $texturedb)" ..."

# Escaping paths for MySQL/SQLite3 inserts
printf -v from "%q" "$1"
printf -v to "%q" "$2"

# updating databases
echo "Updating mysql databases from '$1' to '$2' ..."
#exit 0
mysql -h$dbhost -u$dbuser -p$dbpassword 2>/dev/null <<EOF
use $videodb
UPDATE ignore path SET strPath = REPLACE(strPath,'$from', '$to');
UPDATE ignore movie SET c22 = REPLACE(c22,'$from', '$to');
UPDATE ignore episode SET c18 = REPLACE(c18,'$from', '$to');
UPDATE ignore art SET url = REPLACE(url,'$from', '$to');
UPDATE ignore tvshow SET c16 = REPLACE(c16,'$from', '$to');
UPDATE ignore files SET strFilename = REPLACE(strFilename,'$from', '$to');
use $audiodb
UPDATE ignore path SET strPath = REPLACE(strPath,'$from', '$to');
EOF

echo "Updating sqlite database from '$1' to '$2' ..."
sqlite3 $texturedb <<EOF
UPDATE path SET url = REPLACE(url,"$1","$2o");
UPDATE path SET texture = REPLACE(texture,"$1","$2");
EOF

echo "Updating sources.xml file from '$1' to '$2' ..."
# updating sources file (using pipe separator avoiding forward slash issues)
sed -i "s|$1|$2|g" $kodihome/.kodi/userdata/sources.xml

echo "Updating favourites.xml file from '$1' to '$2' ..."
# updating sources file (using pipe separator avoiding forward slash issues)
sed -i "s|$1|$2|g" $kodihome/.kodi/userdata/favourites.xml

echo "Kodi restart is required to apply new sources and paths"
read -r -p "Restart Kodi now? [y/N] " response
response=${response,,}    # tolower
if [[ "$response" =~ ^(yes|y)$ ]]
then
    service kodi restart
    echo "Kodi restarted."
fi

echo "All done"