summaryrefslogtreecommitdiff
path: root/tests/lexers/powershell/example.txt
diff options
context:
space:
mode:
Diffstat (limited to 'tests/lexers/powershell/example.txt')
-rw-r--r--tests/lexers/powershell/example.txt1066
1 files changed, 1066 insertions, 0 deletions
diff --git a/tests/lexers/powershell/example.txt b/tests/lexers/powershell/example.txt
new file mode 100644
index 00000000..5c4b943a
--- /dev/null
+++ b/tests/lexers/powershell/example.txt
@@ -0,0 +1,1066 @@
+---input---
+<#
+.SYNOPSIS
+Runs a T-SQL Query and optional outputs results to a delimited file.
+.DESCRIPTION
+Invoke-Sql script will run a T-SQL query or stored procedure and optionally outputs a delimited file.
+.EXAMPLE
+PowerShell.exe -File "C:\Scripts\Invoke-Sql.ps1" -ServerInstance "Z003\sqlprod2" -Database orders -Query "EXEC usp_accounts '12445678'"
+This example connects to Z003\sqlprod2.Orders and executes a stored procedure which does not return a result set
+.EXAMPLE
+PowerShell.exe -File "C:\Scripts\Invoke-Sql.ps1" -ServerInstance "Z003\sqlprod2" -Database orders -Query "SELECT * FROM dbo.accounts" -FilePath "C:\Scripts\accounts.txt" -Delimiter ","
+This example connects to Z003\sqlprod2.Orders and selects the records from the accounts tables, the data is outputed to a CSV file
+.NOTES
+Version History
+v1.0 - Chad Miller - 12/14/2010 - Initial release
+IMPORTANT!!! The EventLog source which is set to the application needs to be registered with
+the Event log:
+New-EventLog -LogName Application -Source $Application
+#>
+param(
+#ServerInstance is Mandatory!
+[Parameter(Position=0, Mandatory=$false)] [string]$ServerInstance,
+#Database is Mandatory!
+[Parameter(Position=1, Mandatory=$false)] [string]$Database,
+#Query is Mandatory!
+[Parameter(Position=2, Mandatory=$false)] [string]$Query,
+[Parameter(Position=3, Mandatory=$false)] [string]$Application="Invoke-Sql.ps1",
+[Parameter(Position=4, Mandatory=$false)] [string]$FilePath,
+[Parameter(Position=7, Mandatory=$false)] [string]$Delimiter="|",
+#If UserName isn't supplied a trusted connection will be used
+[Parameter(Position=5, Mandatory=$false)] [string]$UserName,
+[Parameter(Position=6, Mandatory=$false)] [string]$Password,
+[Parameter(Position=8, Mandatory=$false)] [Int32]$QueryTimeout=600,
+[Parameter(Position=9, Mandatory=$false)] [Int32]$ConnectionTimeout=15
+)
+
+
+#This must be run as administrator on Windows 2008 and higher!
+New-EventLog -LogName Application -Source $Application -EA SilentlyContinue
+$Error.Clear()
+
+#######################
+function Invoke-SqlCmd2
+{
+ param(
+ [Parameter(Position=0, Mandatory=$true)] [string]$ServerInstance,
+ [Parameter(Position=1, Mandatory=$true)] [string]$Database,
+ [Parameter(Position=2, Mandatory=$true)] [string]$Query,
+ [Parameter(Position=3, Mandatory=$false)] [string]$UserName,
+ [Parameter(Position=4, Mandatory=$false)] [string]$Password,
+ [Parameter(Position=5, Mandatory=$false)] [Int32]$QueryTimeout,
+ [Parameter(Position=6, Mandatory=$false)] [Int32]$ConnectionTimeout
+ )
+
+ try {
+ if ($Username)
+ { $ConnectionString = "Server={0};Database={1};User ID={2};Password={3};Trusted_Connection=False;Connect Timeout={4}" -f $ServerInstance,$Database,$Username,$Password,$ConnectionTimeout }
+ else
+ { $ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerInstance,$Database,$ConnectionTimeout }
+ $conn=new-object System.Data.SqlClient.SQLConnection
+ $conn.ConnectionString=$ConnectionString
+ $conn.Open()
+ $cmd=new-object system.Data.SqlClient.SqlCommand($Query,$conn)
+ $cmd.CommandTimeout=$QueryTimeout
+ $ds=New-Object system.Data.DataSet
+ $da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd)
+ [void]$da.fill($ds)
+ Write-Output ($ds.Tables[0])
+ }
+ finally {
+ $conn.Dispose()
+ }
+
+} #Invoke-SqlCmd2
+
+#######################
+# MAIN #
+#######################
+if ($PSBoundParameters.Count -eq 0)
+{
+ get-help $myInvocation.MyCommand.Path -full
+ break
+}
+
+try {
+ $msg = $null
+ $msg += "Application/Job Name: $Application`n"
+ $msg += "Query: $Query`n"
+ $msg += "ServerInstance: $ServerInstance`n"
+ $msg += "Database: $Database`n"
+ $msg += "FilePath: $FilePath`n"
+
+ Write-EventLog -LogName Application -Source "$Application" -EntryType Information -EventId 12345 -Message "Starting`n$msg"
+ $dt = Invoke-SqlCmd2 -ServerInstance $ServerInstance -Database $Database -Query $Query -UserName $UserName -Password $Password -QueryTimeOut $QueryTimeOut -ConnectionTimeout $ConnectionTimeout
+ if ($FilePath)
+ {
+ if ($dt)
+ { $dt | export-csv -Delimiter $Delimiter -Path $FilePath -NoTypeInformation }
+ else #Query Returned No Output!
+ {Write-EventLog -LogName Application -Source "$Application" -EntryType Warning -EventId 12345 -Message "NoOutput`n$msg" }
+ }
+
+ Write-EventLog -LogName Application -Source "$Application" -EntryType Information -EventId 12345 -Message "Completed`n$msg"
+}
+catch {
+ $Exception = "{0}, {1}" -f $_.Exception.GetType().FullName,$( $_.Exception.Message -replace "'" )
+ Write-EventLog -LogName Application -Source "$Application" -EntryType Error -EventId 12345 -Message "Error`n$msg`n$Exception"
+ throw
+}
+
+---tokens---
+'<#' Comment.Multiline
+'\n' Comment.Multiline
+
+'.SYNOPSIS' Literal.String.Doc
+'\nRuns a T-SQL Query and optional outputs results to a delimited file' Comment.Multiline
+'.' Comment.Multiline
+'\n' Comment.Multiline
+
+'.DESCRIPTION' Literal.String.Doc
+'\nInvoke-Sql script will run a T-SQL query or stored procedure and optionally outputs a delimited file' Comment.Multiline
+'.' Comment.Multiline
+'\n' Comment.Multiline
+
+'.EXAMPLE' Literal.String.Doc
+'\nPowerShell' Comment.Multiline
+'.' Comment.Multiline
+'exe -File "C:\\Scripts\\Invoke-Sql' Comment.Multiline
+'.' Comment.Multiline
+'ps1" -ServerInstance "Z003\\sqlprod2" -Database orders -Query "EXEC usp_accounts \'12445678\'"\nThis example connects to Z003\\sqlprod2' Comment.Multiline
+'.' Comment.Multiline
+'Orders and executes a stored procedure which does not return a result set\n' Comment.Multiline
+
+'.EXAMPLE' Literal.String.Doc
+'\nPowerShell' Comment.Multiline
+'.' Comment.Multiline
+'exe -File "C:\\Scripts\\Invoke-Sql' Comment.Multiline
+'.' Comment.Multiline
+'ps1" -ServerInstance "Z003\\sqlprod2" -Database orders -Query "SELECT * FROM dbo' Comment.Multiline
+'.' Comment.Multiline
+'accounts" -FilePath "C:\\Scripts\\accounts' Comment.Multiline
+'.' Comment.Multiline
+'txt" -Delimiter ","\nThis example connects to Z003\\sqlprod2' Comment.Multiline
+'.' Comment.Multiline
+'Orders and selects the records from the accounts tables, the data is outputed to a CSV file\n' Comment.Multiline
+
+'.NOTES' Literal.String.Doc
+'\nVersion History\nv1' Comment.Multiline
+'.' Comment.Multiline
+'0 - Chad Miller - 12/14/2010 - Initial release\nIMPORTANT!!! The EventLog source which is set to the application needs to be registered with\nthe Event log:\nNew-EventLog -LogName Application -Source $Application\n' Comment.Multiline
+
+'#>' Comment.Multiline
+'\n' Text
+
+'param' Keyword
+'(' Punctuation
+'\n' Text
+
+'#ServerInstance is Mandatory!' Comment
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'0' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$ServerInstance' Name.Variable
+',' Punctuation
+'\n' Text
+
+'#Database is Mandatory!' Comment
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'1' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Database' Name.Variable
+',' Punctuation
+'\n' Text
+
+'#Query is Mandatory!' Comment
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'2' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Query' Name.Variable
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'3' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Application' Name.Variable
+'=' Punctuation
+'"' Literal.String.Double
+'Invoke-Sql.ps1' Literal.String.Double
+'"' Literal.String.Double
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'4' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$FilePath' Name.Variable
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'7' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Delimiter' Name.Variable
+'=' Punctuation
+'"' Literal.String.Double
+'|' Literal.String.Double
+'"' Literal.String.Double
+',' Punctuation
+'\n' Text
+
+"#If UserName isn't supplied a trusted connection will be used" Comment
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'5' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$UserName' Name.Variable
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'6' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Password' Name.Variable
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'8' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[Int32]' Name.Constant
+'$QueryTimeout' Name.Variable
+'=' Punctuation
+'600' Name
+',' Punctuation
+'\n' Text
+
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'9' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[Int32]' Name.Constant
+'$ConnectionTimeout' Name.Variable
+'=' Punctuation
+'15' Name
+'\n' Text
+
+')' Punctuation
+'\n \n \n' Text
+
+'#This must be run as administrator on Windows 2008 and higher!' Comment
+'\n' Text
+
+'New-EventLog' Name.Builtin
+' ' Text
+'-LogName' Name
+' ' Text
+'Application' Name
+' ' Text
+'-Source' Name
+' ' Text
+'$Application' Name.Variable
+' ' Text
+'-EA' Name
+' ' Text
+'SilentlyContinue' Name
+'\n' Text
+
+'$Error' Name.Variable
+'.' Punctuation
+'Clear' Name
+'(' Punctuation
+')' Punctuation
+'\n \n' Text
+
+'#######################' Comment
+'\n' Text
+
+'function' Keyword
+' ' Text
+'Invoke-SqlCmd2' Name.Builtin
+'\n' Text
+
+'{' Punctuation
+'\n ' Text
+'param' Keyword
+'(' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'0' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$true' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$ServerInstance' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'1' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$true' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Database' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'2' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$true' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Query' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'3' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$UserName' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'4' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[string]' Name.Constant
+'$Password' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'5' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[Int32]' Name.Constant
+'$QueryTimeout' Name.Variable
+',' Punctuation
+'\n ' Text
+'[' Punctuation
+'Parameter' Keyword
+'(' Punctuation
+'Position' Keyword
+'=' Punctuation
+'6' Name
+',' Punctuation
+' ' Text
+'Mandatory' Keyword
+'=' Punctuation
+'$false' Name.Variable
+')' Punctuation
+']' Punctuation
+' ' Text
+'[Int32]' Name.Constant
+'$ConnectionTimeout' Name.Variable
+'\n ' Text
+')' Punctuation
+'\n \n ' Text
+'try' Keyword
+' ' Text
+'{' Punctuation
+'\n ' Text
+'if' Keyword
+' ' Text
+'(' Punctuation
+'$Username' Name.Variable
+')' Punctuation
+'\n ' Text
+'{' Punctuation
+' ' Text
+'$ConnectionString' Name.Variable
+' ' Text
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'Server={0};Database={1};User ID={2};Password={3};Trusted_Connection=False;Connect Timeout={4}' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-f' Operator
+' ' Text
+'$ServerInstance' Name.Variable
+',' Punctuation
+'$Database' Name.Variable
+',' Punctuation
+'$Username' Name.Variable
+',' Punctuation
+'$Password' Name.Variable
+',' Punctuation
+'$ConnectionTimeout' Name.Variable
+' ' Text
+'}' Punctuation
+'\n ' Text
+'else' Keyword
+'\n ' Text
+'{' Punctuation
+' ' Text
+'$ConnectionString' Name.Variable
+' ' Text
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'Server={0};Database={1};Integrated Security=True;Connect Timeout={2}' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-f' Operator
+' ' Text
+'$ServerInstance' Name.Variable
+',' Punctuation
+'$Database' Name.Variable
+',' Punctuation
+'$ConnectionTimeout' Name.Variable
+' ' Text
+'}' Punctuation
+'\n ' Text
+'$conn' Name.Variable
+'=' Punctuation
+'new-object' Name.Builtin
+' ' Text
+'System' Name
+'.' Punctuation
+'Data' Name
+'.' Punctuation
+'SqlClient' Name
+'.' Punctuation
+'SQLConnection' Name
+'\n ' Text
+'$conn' Name.Variable
+'.' Punctuation
+'ConnectionString' Name
+'=' Punctuation
+'$ConnectionString' Name.Variable
+'\n ' Text
+'$conn' Name.Variable
+'.' Punctuation
+'Open' Name
+'(' Punctuation
+')' Punctuation
+'\n ' Text
+'$cmd' Name.Variable
+'=' Punctuation
+'new-object' Name.Builtin
+' ' Text
+'system' Name
+'.' Punctuation
+'Data' Name
+'.' Punctuation
+'SqlClient' Name
+'.' Punctuation
+'SqlCommand' Name
+'(' Punctuation
+'$Query' Name.Variable
+',' Punctuation
+'$conn' Name.Variable
+')' Punctuation
+'\n ' Text
+'$cmd' Name.Variable
+'.' Punctuation
+'CommandTimeout' Name
+'=' Punctuation
+'$QueryTimeout' Name.Variable
+'\n ' Text
+'$ds' Name.Variable
+'=' Punctuation
+'New-Object' Name.Builtin
+' ' Text
+'system' Name
+'.' Punctuation
+'Data' Name
+'.' Punctuation
+'DataSet' Name
+'\n ' Text
+'$da' Name.Variable
+'=' Punctuation
+'New-Object' Name.Builtin
+' ' Text
+'system' Name
+'.' Punctuation
+'Data' Name
+'.' Punctuation
+'SqlClient' Name
+'.' Punctuation
+'SqlDataAdapter' Name
+'(' Punctuation
+'$cmd' Name.Variable
+')' Punctuation
+'\n ' Text
+'[void]' Name.Constant
+'$da' Name.Variable
+'.' Punctuation
+'fill' Name
+'(' Punctuation
+'$ds' Name.Variable
+')' Punctuation
+'\n ' Text
+'Write-Output' Name.Builtin
+' ' Text
+'(' Punctuation
+'$ds' Name.Variable
+'.' Punctuation
+'Tables' Name
+'[' Punctuation
+'0' Name
+']' Punctuation
+')' Punctuation
+'\n ' Text
+'}' Punctuation
+'\n ' Text
+'finally' Keyword
+' ' Text
+'{' Punctuation
+'\n ' Text
+'$conn' Name.Variable
+'.' Punctuation
+'Dispose' Name
+'(' Punctuation
+')' Punctuation
+'\n ' Text
+'}' Punctuation
+'\n \n' Text
+
+'}' Punctuation
+' ' Text
+'#Invoke-SqlCmd2' Comment
+'\n \n' Text
+
+'#######################' Comment
+'\n' Text
+
+'# MAIN #' Comment
+'\n' Text
+
+'#######################' Comment
+'\n' Text
+
+'if' Keyword
+' ' Text
+'(' Punctuation
+'$PSBoundParameters' Name.Variable
+'.' Punctuation
+'Count' Name
+' ' Text
+'-eq' Operator
+' ' Text
+'0' Name
+')' Punctuation
+'\n' Text
+
+'{' Punctuation
+'\n ' Text
+'get-help' Name.Builtin
+' ' Text
+'$myInvocation' Name.Variable
+'.' Punctuation
+'MyCommand' Name
+'.' Punctuation
+'Path' Name
+' ' Text
+'-full' Name
+'\n ' Text
+'break' Keyword
+'\n' Text
+
+'}' Punctuation
+'\n \n' Text
+
+'try' Keyword
+' ' Text
+'{' Punctuation
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'=' Punctuation
+' ' Text
+'$null' Name.Variable
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'+' Punctuation
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'Application/Job Name: ' Literal.String.Double
+'$' Literal.String.Double
+'Application' Literal.String.Double
+'`n' Literal.String.Escape
+'"' Literal.String.Double
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'+' Punctuation
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'Query: ' Literal.String.Double
+'$' Literal.String.Double
+'Query' Literal.String.Double
+'`n' Literal.String.Escape
+'"' Literal.String.Double
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'+' Punctuation
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'ServerInstance: ' Literal.String.Double
+'$' Literal.String.Double
+'ServerInstance' Literal.String.Double
+'`n' Literal.String.Escape
+'"' Literal.String.Double
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'+' Punctuation
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'Database: ' Literal.String.Double
+'$' Literal.String.Double
+'Database' Literal.String.Double
+'`n' Literal.String.Escape
+'"' Literal.String.Double
+'\n ' Text
+'$msg' Name.Variable
+' ' Text
+'+' Punctuation
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'FilePath: ' Literal.String.Double
+'$' Literal.String.Double
+'FilePath' Literal.String.Double
+'`n' Literal.String.Escape
+'"' Literal.String.Double
+'\n \n ' Text
+'Write-EventLog' Name.Builtin
+' ' Text
+'-LogName' Name
+' ' Text
+'Application' Name
+' ' Text
+'-Source' Name
+' ' Text
+'"' Literal.String.Double
+'$' Literal.String.Double
+'Application' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-EntryType' Name
+' ' Text
+'Information' Name
+' ' Text
+'-EventId' Name
+' ' Text
+'12345' Name
+' ' Text
+'-Message' Name
+' ' Text
+'"' Literal.String.Double
+'Starting' Literal.String.Double
+'`n' Literal.String.Escape
+'$' Literal.String.Double
+'msg' Literal.String.Double
+'"' Literal.String.Double
+'\n ' Text
+'$dt' Name.Variable
+' ' Text
+'=' Punctuation
+' ' Text
+'Invoke-SqlCmd2' Name.Builtin
+' ' Text
+'-ServerInstance' Name
+' ' Text
+'$ServerInstance' Name.Variable
+' ' Text
+'-Database' Name
+' ' Text
+'$Database' Name.Variable
+' ' Text
+'-Query' Name
+' ' Text
+'$Query' Name.Variable
+' ' Text
+'-UserName' Name
+' ' Text
+'$UserName' Name.Variable
+' ' Text
+'-Password' Name
+' ' Text
+'$Password' Name.Variable
+' ' Text
+'-QueryTimeOut' Name
+' ' Text
+'$QueryTimeOut' Name.Variable
+' ' Text
+'-ConnectionTimeout' Name
+' ' Text
+'$ConnectionTimeout' Name.Variable
+'\n ' Text
+'if' Keyword
+' ' Text
+'(' Punctuation
+'$FilePath' Name.Variable
+')' Punctuation
+'\n ' Text
+'{' Punctuation
+'\n ' Text
+'if' Keyword
+' ' Text
+'(' Punctuation
+'$dt' Name.Variable
+')' Punctuation
+'\n ' Text
+'{' Punctuation
+' ' Text
+'$dt' Name.Variable
+' ' Text
+'|' Punctuation
+' ' Text
+'export-csv' Name.Builtin
+' ' Text
+'-Delimiter' Name
+' ' Text
+'$Delimiter' Name.Variable
+' ' Text
+'-Path' Name
+' ' Text
+'$FilePath' Name.Variable
+' ' Text
+'-NoTypeInformation' Name
+' ' Text
+'}' Punctuation
+'\n ' Text
+'else' Keyword
+' ' Text
+'#Query Returned No Output!' Comment
+'\n ' Text
+'{' Punctuation
+'Write-EventLog' Name.Builtin
+' ' Text
+'-LogName' Name
+' ' Text
+'Application' Name
+' ' Text
+'-Source' Name
+' ' Text
+'"' Literal.String.Double
+'$' Literal.String.Double
+'Application' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-EntryType' Name
+' ' Text
+'Warning' Name
+' ' Text
+'-EventId' Name
+' ' Text
+'12345' Name
+' ' Text
+'-Message' Name
+' ' Text
+'"' Literal.String.Double
+'NoOutput' Literal.String.Double
+'`n' Literal.String.Escape
+'$' Literal.String.Double
+'msg' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'}' Punctuation
+'\n ' Text
+'}' Punctuation
+'\n \n ' Text
+'Write-EventLog' Name.Builtin
+' ' Text
+'-LogName' Name
+' ' Text
+'Application' Name
+' ' Text
+'-Source' Name
+' ' Text
+'"' Literal.String.Double
+'$' Literal.String.Double
+'Application' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-EntryType' Name
+' ' Text
+'Information' Name
+' ' Text
+'-EventId' Name
+' ' Text
+'12345' Name
+' ' Text
+'-Message' Name
+' ' Text
+'"' Literal.String.Double
+'Completed' Literal.String.Double
+'`n' Literal.String.Escape
+'$' Literal.String.Double
+'msg' Literal.String.Double
+'"' Literal.String.Double
+'\n' Text
+
+'}' Punctuation
+'\n' Text
+
+'catch' Keyword
+' ' Text
+'{' Punctuation
+'\n ' Text
+'$Exception' Name.Variable
+' ' Text
+'=' Punctuation
+' ' Text
+'"' Literal.String.Double
+'{0}, {1}' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-f' Operator
+' ' Text
+'$_' Name.Variable
+'.' Punctuation
+'Exception' Name
+'.' Punctuation
+'GetType' Name
+'(' Punctuation
+')' Punctuation
+'.' Punctuation
+'FullName' Name
+',' Punctuation
+'$' Punctuation
+'(' Punctuation
+' ' Text
+'$_' Name.Variable
+'.' Punctuation
+'Exception' Name
+'.' Punctuation
+'Message' Name
+' ' Text
+'-replace' Operator
+' ' Text
+'"' Literal.String.Double
+"'" Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+')' Punctuation
+'\n ' Text
+'Write-EventLog' Name.Builtin
+' ' Text
+'-LogName' Name
+' ' Text
+'Application' Name
+' ' Text
+'-Source' Name
+' ' Text
+'"' Literal.String.Double
+'$' Literal.String.Double
+'Application' Literal.String.Double
+'"' Literal.String.Double
+' ' Text
+'-EntryType' Name
+' ' Text
+'Error' Name
+' ' Text
+'-EventId' Name
+' ' Text
+'12345' Name
+' ' Text
+'-Message' Name
+' ' Text
+'"' Literal.String.Double
+'Error' Literal.String.Double
+'`n' Literal.String.Escape
+'$' Literal.String.Double
+'msg' Literal.String.Double
+'`n' Literal.String.Escape
+'$' Literal.String.Double
+'Exception' Literal.String.Double
+'"' Literal.String.Double
+'\n ' Text
+'throw' Keyword
+'\n' Text
+
+'}' Punctuation
+'\n' Text