Apps/Get-mySQLConnectorNET.ps1
|
function Get-mySQLConnectorNET { <# .NOTES Author: BornToBeRoot Twitter: @BornToBeRoot #> [OutputType([System.Management.Automation.PSObject])] [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseSingularNouns", "", Justification = "Product name is a plural")] [CmdletBinding(SupportsShouldProcess = $False)] param ( [Parameter(Mandatory = $False, Position = 0)] [ValidateNotNull()] [System.Management.Automation.PSObject] $res = (Get-FunctionResource -AppName ("$($MyInvocation.MyCommand)".Split("-"))[1]) ) # Get latest repo tag $Tags = Get-GitHubRepoTag -Uri $res.Get.Update.Uri $Version = ($Tags | Sort-Object -Property @{ Expression = { [System.Version]$_.Tag }; Descending = $true } | Select-Object -First 1).Tag # Build the output object if ($null -ne $Version) { foreach ($Architecture in $res.Get.Download.Uri.GetEnumerator()) { # https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-8.0.40-winx64.msi # redirect to # https://cdn.mysql.com//Downloads/MySQLGUITools/mysql-workbench-community-8.0.40-winx64.msi # # The version ist major.minor.patch, while the tag can have also have major.minor.patch.build $Uri = $res.Get.Download.Uri[$Architecture.Key] -replace $res.Get.Download.ReplaceVersion, (($Version -split '\.')[0..2] -join '.') Write-Verbose -Message "$($MyInvocation.MyCommand): Resolving: $Uri" # The website/CDN checks the user agent, which means that the call from e.g. Azure Automation is only possible by overwriting it $params = @{ Uri = $Uri UserAgent = "Curl/8" } $CdnUri = Resolve-SystemNetWebRequest @params $PSObject = [PSCustomObject] @{ Version = $Version Architecture = $Architecture.Name Type = Get-FileType -File $CdnUri.ResponseUri.AbsoluteUri URI = $CdnUri.ResponseUri.AbsoluteUri -replace "com//", "com/" } Write-Output -InputObject $PSObject } } } |