install-windows-bin.ps1

Param(
    $main_url = $(throw "Usage: install-windows-bin.ps1 MAIN_URL ODBC_URL"),
    $odbc_url = $(throw "Usage: install-windows-bin.ps1 MAIN_URL ODBC_URL")
)

# one day we'll make this configurable
$main_prefix = "C:\Program Files\MonetDB\MonetDB5"
$odbc_prefix = "C:\Program Files\MonetDB\MonetDB ODBC Driver"


Write-Output "main_url=$main_url"
Write-Output "odbc_url=$odbc_url"
Write-Output "main_prefix=$main_prefix"
Write-Output "odbc_prefix=$odbc_prefix"

Write-Output "========== MONETDB ========="
$main_file="c:\monetdb-main.msi"
Write-Output "---------- Download '$main_file' from '$main_url'"
(New-Object System.Net.WebClient).DownloadFile("$main_url", "$main_file");
Get-ChildItem $main_file
Write-Output "---------- Install '$main_file'"
#$main_proc = Start-Process "$main_file" -ArgumentList '/quiet /passive /qn /norestart INSTALLLEVEL=1000 MSIRMSHUTDOWN=2' -Wait
Start-Process "$main_file" -ArgumentList '/passive /norestart INSTALLLEVEL=1000 MSIRMSHUTDOWN=2' -Wait
Write-Output "---------- OK"

Write-Output "========== ODBC ========="
$odbc_file="c:\monetdb-odbc.msi"
Write-Output "---------- Download '$odbc_file' from '$odbc_url'"
(New-Object System.Net.WebClient).DownloadFile("$odbc_url", "$odbc_file");
Get-ChildItem $odbc_file
Write-Output "---------- Install '$odbc_file'"
Start-Process "$odbc_file" -ArgumentList '/quiet /passive /qn /norestart INSTALLLEVEL=1000 MSIRMSHUTDOWN=2' -Wait
Write-Output "---------- OK"

Write-Output "========== disable embedded Python =========="
# The version of Python embedded in MonetDB is unlikely to match this system's Python.
Remove-Item "$main_prefix\pyapi_locatepython3.bat"

Write-Output "========== Update PATH =========="
Write-Output "old PATH: $env:PATH"
# write it to $GITHUB_PATH so future steps have it
Add-Content $env:GITHUB_PATH "$main_prefix"
# add it to the environment so the rest of this script has it
$env:PATH += "$main_prefix"
# verbose is good
Write-Output "new PATH: $env:PATH"

Write-Output "========== Start the server =========="
$opts = @{
    FilePath = "$main_prefix\MSQLserver.bat"
    #NoNewWindow = $true
    #ArgumentList = "--set","embedded_py=false"
}
Start-Process @opts

Write-Output "========== Update GitHub contexts =========="
# We write to 'github.output' rather than $env:GITHUB_OUTPUT
# because all the install scripts in this Action do that.
# Another step in the Action then copies it to $env:GITHUB_OUTPUT
Add-Content github.output "prefix=$main_prefix"
Add-Content github.output "bindir=$main_prefix"
Add-Content github.output "includedir=$main_prefix\include\monetdb"
Add-Content github.output "libdir=$main_prefix\lib"
Add-Content github.output "dynsuffix=dll"
Write-Output "---------- github.output ----------"
Get-Content $env:GITHUB_OUTPUT
Write-Output "---------- GITHUB_PATH ($env:GITHUB_PATH) ----------"
Get-Content $env:GITHUB_PATH


Write-Output "========== DONE =========="