internal/dynamicparams/mailaccount.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
#region Initialize Cache if (-not [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"]) { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"] = @{ } } #endregion Initialize Cache #region Tepp Data return $ScriptBlock = { param ( $commandName, $parameterName, $wordToComplete, $commandAst, $fakeBoundParameter ) $server = $fakeBoundParameter['SqlInstance'] if (-not $server) { $server = $fakeBoundParameter['Source'] } if (-not $server) { $server = $fakeBoundParameter['ComputerName'] } if (-not $server) { return } try { [DbaInstanceParameter]$parServer = $server | Select-Object -First 1 } catch { return } if ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"][$parServer.FullSmoName.ToLowerInvariant()]) { foreach ($name in ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"][$parServer.FullSmoName.ToLowerInvariant()] | Where-DbaObject -Like "$wordToComplete*")) { New-DbaTeppCompletionResult -CompletionText $name -ToolTip $name } return } try { $serverObject = Connect-SqlInstance -SqlInstance $parServer -SqlCredential $fakeBoundParameter['SqlCredential'] -ErrorAction Stop foreach ($name in ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"][$parServer.FullSmoName.ToLowerInvariant()] | Where-DbaObject -Like "$wordToComplete*")) { New-DbaTeppCompletionResult -CompletionText $name -ToolTip $name } return } catch { return } } Register-DbaTeppScriptblock -ScriptBlock $ScriptBlock -Name MailAccount #endregion Tepp Data return #region Update Cache $ScriptBlock = { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["mailaccount"][$FullSmoName] = $server.Mail.Accounts.Name } Register-DbaTeppInstanceCacheBuilder -ScriptBlock $ScriptBlock #endregion Update Cache |