#Assembly
add-type -assemblyName "System.Data"

  #Param(
  #[Parameter(
  #Mandatory = $true,
  #ParameterSetName = '',
  #ValueFromPipeline = $true)]
  #[string]$Query
  #)


Write-Host "::::::            Vylejvač       ::::::"
Write-Host "---------------------------------------"



  #Tady to můžeš měnit, Vojto

$MySQLAdminUserName = 'root'
$MySQLAdminPassword = ''
$MySQLDatabase = 'arsys5'
$MySQLHost = 'localhost'
$MySQLPort = '3306'

$Query1 = 'select * from archiv'
$Query2 = 'select * from identif'
$Query3 = 'select * from dokutyp'

$soubor1 = "C:\temp\1.csv"
$soubor2 = "C:\temp\2.csv"
$soubor3 = "C:\temp\3.csv"

Write-Host "MySQL DB: "$MySQLDatabase
Write-Host "MySQL user: "$MySQLAdminUserName
Write-Host "Server: "$MySQLHost
Write-Host "Port: "$MySQLPort

Start-Sleep -s 5


#Vylití archivu

$ConnectionString = "server=" + $MySQLHost + ";port=" + $MySQLPort + ";uid=" + $MySQLAdminUserName + ";pwd=" + $MySQLAdminPassword + ";database="+$MySQLDatabase +";SslMode=none"
Try {
  [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
  $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
  $Connection.ConnectionString = $ConnectionString
  $Connection.Open()
  $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query1, $Connection)
  $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
  $DataSet = New-Object System.Data.DataSet
  $RecordCount = $dataAdapter.Fill($dataSet, "data")
  $DataSet.Tables[0] | Export-Csv -Path $soubor1 -NoTypeInformation -Encoding UTF8
   }
Catch {
  Write-Host "ERROR : Unable to run query : $query `n$Error[0]"
 }
Finally {
  $Connection.Close()
  }

Write-Host "archiv vylitej"
Start-Sleep -s 1

#Vylití identif
Try {
  [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
  $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
  $Connection.ConnectionString = $ConnectionString
  $Connection.Open()
  $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query2, $Connection)
  $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
  $DataSet = New-Object System.Data.DataSet
  $RecordCount = $dataAdapter.Fill($dataSet, "data")
  $DataSet.Tables[0] | Export-Csv -Path $soubor2 -NoTypeInformation -Encoding UTF8
   }
Catch {
  Write-Host "ERROR : Unable to run query : $query `n$Error[0]"
 }
Finally {
  $Connection.Close()
  }

Write-Host "identif vylitej"
Start-Sleep -s 1

#Vylití dokutyp
Try {
  [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
  $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
  $Connection.ConnectionString = $ConnectionString
  $Connection.Open()
  $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query3, $Connection)
  $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
  $DataSet = New-Object System.Data.DataSet
  $RecordCount = $dataAdapter.Fill($dataSet, "data")
  $DataSet.Tables[0] | Export-Csv -Path $soubor3 -NoTypeInformation -Encoding UTF8
   }
Catch {
  Write-Host "ERROR : Unable to run query : $query `n$Error[0]"
 }
Finally {
  $Connection.Close()
  }

  Write-Host "dokutyp vylitej"
Start-Sleep -s 1