Kraken

0.1

Private/Get-SQLInstance.ps1

function Get-SQLInstance {
    [OutputType('void')]
    [CmdletBinding(DefaultParameterSetName='All')]
    param
    (

        [Parameter(Mandatory, ValueFromPipeline, ParameterSetName = 'ById')]
        [ValidateNotNullOrEmpty()]
        [int[]]$Id,

        [Parameter(Mandatory, ValueFromPipeline, ParameterSetName = 'ByName')]
        [ValidateNotNullOrEmpty()]
        [string[]]$Name,

        [Parameter(Mandatory, ParameterSetName = 'ByEnv')]
        [ValidateNotNullOrEmpty()]
        #[ValidateSet("DEV", "TST", "STG", "PRD")]
        [string[]]$Environment,

        [Parameter(ParameterSetName = 'All')]
        [switch]$All
    )

    begin {
        $ErrorActionPreference = 'Stop'
        $connSettings = Get-ConnectionString
        $dbCredential = Get-DBCredential
        $ModulePath = (Split-Path $PSScriptRoot)
        $GetSQLInstance = "$ModulePath\Private\SQLScripts\Get-SQLInstance.sql"
    }

    process {

        $SQLInstanceList = Invoke-Sqlcmd -ServerInstance $connSettings.server -Database $connSettings.database -Credential $dbCredential -InputFile $GetSQLInstance

        switch ($PSCmdlet.ParameterSetName) { #$PSBoundParameters.Keys

            'ById' {
                $SQLInstanceList | Where-Object { $_.id -in $Id}
            }
            'ByName' {
                $SQLInstanceList | Where-Object { $_.instance_name -in $Name}
            }
            'ByEnv'{
                $SQLInstanceList | Where-Object { $_.environment -in $Environment}
            }
            'All' {
                $SQLInstanceList
            }
        } 
    }
}