$ErrorActionPreference = "SilentlyContinue"

# CHANGE ME IF DB CHANGES
$server   = "10.208.8.48"
$username = "sa"
$password = "password25"
$olddb    = "mysql"
$newdb    = "survivor25"

#LEAVE ALONE FROM HERE

if (Get-Command mysql -errorAction SilentlyContinue)
{
    $passwordcat = "-p" + $password

    write-host "Copy from: " + $olddb
    $newdb = Read-Host 'Copy to:'
    # write-Host "Copy to: " + $newdb

    if ($olddb -and $newdb) {
        echo drop database $($newdb) | mysql -h $($server) -u $($username) $($passwordcat)
        echo create database $($newdb) | mysql -h $($server) -u $($username) $($passwordcat)
        
        # copy default engine tables
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'projects'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'project_repos_db'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'renamable_enumerations'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        # copy default project tables
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'asset_library'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'asset_library_history'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'default_assets'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'objects'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'unique_file_id'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
        # copy project tables
        mysqldump -h $($server) -u $($username) $($passwordcat) $($olddb) $(mysql -h $($server) -u $($username) $($passwordcat) -D $($olddb) -Bse "show tables like 'survivor_%'") | mysql -h $($server) -u $($username) $($passwordcat) $($newdb) 
    } else {
        write-host "Database name cannot be empty"
    }
}
else
{
    write-host "PLEASE INSTALL MYSQL CLIENT AND ADD IT TO YOUR PATH"
}