Wednesday, November 23, 2016

First matching record using XPATH query

In order to select first matching record found using XPATH query I used

(//div[@class='container']//h1[@class='page-header'])[1]   instead of //div[@class='container']//h1[@class='page-header'][1]

Thursday, November 10, 2016

Web Request using PowerShell and Parse JSON response as PowerShell object

To send web request and read JSON response using PowerShell I used following commands

$response = Invoke-WebRequest -Uri "http://myserver.com" -Method Get -Headers @{"apikey"="toekn"}
$responseAsPSObject = $response.Content | ConvertFrom-Json
$myValue = $responseAsPSObject.Value."mykey"
Write-Host "$myValue"


Monday, June 27, 2016

Stop IIS Apppool only when it is Started using appcmd

In order to stop IIS apppool using appcmd only when apppool is started I used following command

%windir%\system32\inetsrv\appcmd list apppool /name:MyAppPoolName /state:Started /xml | %windir%\system32\inetsrv\appcmd stop apppool /in


Wednesday, June 22, 2016

Robocopy exit code 0

In order Robocopy to exit code 0, I used following

(robocopy C:\Source D:\Destionation /e /move /np /njh /njs) ^& IF %ERRORLEVEL% LEQ 4 exit /B 0

Tuesday, June 21, 2016

Get text from the textbox using Selenium 2.0

In order to get text from the textbox using Selenium 2.0 I used following

String myText = driver.FindElement(By.XPath("//input[@id='myTextBox']")).GetAttribute("value");

Wednesday, June 08, 2016

Get parameter and enviornment variable in Jenkins 2.0 pipeline job's Groovy script

In order to get Pipeline job parameter (defined by user) in the Groovy script I used following

${ENV:environment}

while to get enviornment variables to the Pipeline job I used following

$env.BUILD_NUMBER

Friday, June 03, 2016

Allow HTML report containing inline scripts and styles in Jenkins

In Order Jenkins to display HTML reports which uses JS and CSS, I executed following command from Manage Jenkins => Scripe Console

System.setProperty("hudson.model.DirectoryBrowserSupport.CSP","sandbox allow-scripts allow-same-origin; default-src 'self'; script-src 'self' 'unsafe-inline'; img-src 'self' 'unsafe-inline'; style-src 'self' 'unsafe-inline';")

Thursday, March 03, 2016

Find all NUnit test assemblies recursively and run them using PowerShell

In order to grab all unit tests assemblies recursively within folder and run them using NUnit I used following PowerShell script. Here I am filtering assemblies found in obj folder.

$nunit = "C:\Program Files (x86)\NUnit 2.6.4\bin\nunit-console.exe"
$assemblies = ""
$items = Get-ChildItem  -Path .\Test  -Filter *UnitTests.dll -Recurse | Where {$_.FullName -notlike "*\obj\*"} 

foreach ($item in $items)
{
$assemblies = $assemblies + " " + $item.FullName  
}

$nunitcmd = """C:\Program Files (x86)\NUnit 2.6.4\bin\nunit-console.exe"" $assemblies /nologo /xml=c:\dump.xml"
$nunitcmd
cmd /c $nunitcmd

Tuesday, February 09, 2016

Execute MS SQL commands from PowerShell

In order to execute MS SQL commands from PowerShell I used following script.

$sqlquery=@"
USE [DBName]
GO
select * from table
"@

Invoke-Sqlcmd -ServerInstance "ServerName" -Query $sqlquery -Verbose