Monday, July 15, 2019

Internet Explorer XPath using MRI

MRI web developers

http://www.westciv.com/mri/

https://www.youtube.com/watch?v=sxNZ0dfg4OQ

Drag and drop the MRI

chropath

chropath supports chrome and Firefox

chrome://apps/
Click on Web Store

Add to Chrome

right click on element --> Inspect --> ChroPath

Sunday, July 14, 2019

Using app.config file to define a data source, odbc driver, access database engine, data driven testing , Excel

https://docs.microsoft.com/en-us/visualstudio/test/walkthrough-using-a-configuration-file-to-define-a-data-source?view=vs-2019

Install Access Database Engine

Install 32 bit

Add ODBC Data Source:

1. Create a CodedUI Project
2. Create a Excel sheet data. (Copy always)

2. Add App.config file

?xml version="1.0" encoding="utf-8" ?>

</configSections>

</connectionStrings>

<microsoft.visualstudio.testtools>

</dataSources>

</microsoft.visualstudio.testtools>

</configuration>

Write Test:

[TestMethod()]

[DeploymentItem("data.xlsx")]

[DataSource("MyExcelDataSource")]

public void MyTestMethod2()

{

Console.WriteLine(TestContext.DataRow["Val1"]);

Console.WriteLine(TestContext.DataRow["Val2"]);

}

Troubleshoot:

In App.config, Yellow highlighted is having same version of the visual studio Unit Framework dll.

--EoF--

Xpath and CSS selector , Developer Console XPath Parent : https://www.guru99.com/xpath-selenium.html

Contains Attribute:

//input[contains(@value,"Approve")]

Contains text alternative

https://stackoverflow.com/questions/23543044/how-to-use-xpath-preceding-sibling-correctly

//label[contains(.,"Name")]

contains attributes

//img[contains(@src,"wla")]

element attribute or condition

parent::tr/td/span[text()="Accepted" or text()="Processed"]

https://robotframework.org/SeleniumLibrary/SeleniumLibrary.html#Press%20Keys

Press Keys  ENTER

text contains after line break <br>

//li/a[contains(.,'FREIGHT')]
https://stackoverflow.com/questions/36718817/xpath-for-text-after-br

ancestor with attributes

//span[text()="Update"]/ancestor::div[@class="ng-star-inserted"]

particular cell and text contains
td position

tr/td[2][text()="${From}"]/ancestor::tr/td[3][text()="${To}"]/ancestor::tr/td[4]//span[contains(text(),"${VtsStatus}")]

multiple class

//div[@class="dropdown-menu show"]//a[contains(text(),"User Management")]

href contains

//li/a[contains(@href,"warehouse")]

https://stackoverflow.com/questions/26640746/xpath-syntax-for-and-not-contains/26641239

Class not contains
//div[text()="10" and not(contains(@class,'mute'))]

Xpath 2:

What browsers support Xpath 2.0?

https://stackoverflow.com/questions/16658799/what-browsers-support-xpath-2-0

element and child element with conditions

https://stackoverflow.com/questions/10247978/xpath-with-multiple-conditions

//category[@name='Sport' and ./author/text()='James Small']

text case insensitive & check in lower case

https://stackoverflow.com/questions/8474031/case-insensitive-xpath-contains-possible

equal:
//table/tbody/tr[2]/td[5][translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz')= 'port']

contains:

//td[contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), 'company113054')]

//table/tbody/tr[2]/td[5][contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), 'textvaluexyz')]

Not tried yet:
https://stackoverflow.com/questions/2893551/case-insensitive-matching-in-xpath

Select index and Attributes (Property)

//table/tbody/tr[1]/td[1][contains(.,'Permits and Certificates_Daily')]

https://stackoverflow.com/questions/16732508/how-to-find-2nd-td-in-html-using-xpath

contains id:

//div[contains(@id,"content-body")]//p

document.evaluate('//*[@id="kwindowVesselCallSp"]/div/div[1]/div[7]/div', document, null, XPathResult.FIRST_ORDERED_NODE_TYPE, null).singleNodeValue.innerText

preceding-sibling can be indexing it will go relative to the element

${elementLoc}/preceding-sibling::td[1]

Xpath Multiple column data verification:
Verifying two values in the table column

ex: name = "Pradeep"
place = ""Mysore

//table/tbody/tr/td[1]/span[contains(text(),"Pradeep")]/../../td[4][contains(text(),"Mysore")]

XPath Ancestor:

//div[text()='building1' and @class='wrap']/ancestor::tr/td/div/div[@class='x-grid-row-checker']

Attributes:
//div[@name="Quantity"]
//*[@name="Quantity"]

Following-Sibling searches for the all the attributes ::td/div/i

//*[@id="other"]/table//td[contains(@title," Services")]/following-sibling::td/div/i

following-sibling::td[2]

//*[@id="other"]/table//td[contains(@title,"Services")]/following-sibling::td[contains(text(),"VA")]/following-sibling::td[2]

Identify the controls in the developer command prompt or internet console with JavaScript and JQuery

https://stackoverflow.com/questions/22571267/how-to-verify-an-xpath-expression-in-chrome-developers-tool-or-firefoxs-firebug

Click through XPath:

https://stackoverflow.com/questions/5626168/automating-a-javascript-button-click

var xPathRes = document.evaluate ('//div[1]/a[1]', document, null, XPathResult.FIRST_ORDERED_NODE_TYPE, null);

xPathRes.singleNodeValue.click();

Get Inner Text XPath:

${value}= Execute JavaScript return document.evaluate('//h5[contains(text(),"abc")]/following-sibling::h4', document, null, XPathResult.FIRST_ORDERED_NODE_TYPE, null).singleNodeValue.innerHTML

document.getElementsByName("q")[0].value="search"
document.getElementsByName("q")[0].click()
document.getElementById("abcd").click()

$("input[name='q']").value="j"
$("input[name='btnK']").click()

document.getElementsByName("btnK")[1].style.border="5px solid red";
$("input[name='q']").className

Class with multiple atrributes:

(//div[text()="Enter Port"]/../div[@class="ng-value ng-star-inserted"]/span[@class="ng-value-label ng-star-inserted"])[2]

(//div[text()="Enter Terminal"]/../div[@class="ng-value ng-star-inserted"]/span[@class="ng-value-label ng-star-inserted"])[1]

Xpath Ancestor with attributes:
https://stackoverflow.com/questions/10076618/xpath-to-find-ancestor-node-containing-css-class

./ancestor::div[contains(concat(' ', @class, ' '), ' x-grid-view ')][1]

https://www.youtube.com/watch?v=W9_q7tZon2M&list=PLhW3qG5bs-L83gLEZVIDHOvgTTz27po_0

Open web page : F12 -Developer tool bar

// :relative Xpath
/ :absolute XPath

//tagname[@attribute='value'] //input[@name='q']

Chrome extensions to find XPath:

eskry
chropath

And Condition:

Syntax:
//tag[@attribute='value1'][@attribute2='value2']
Examples:
//input[@type='text'][@name='txtUsernmae']
//*[@type='text'][@name='txtUsernmae']

Search By Text:
//a[text()='Share This']

Contains:

//a[contains(text(),'Share')]

Starts with:

//*[starts-with(@id,'home')]

//*[starts-with(@id,'home') or @id='txtUsername' ]

And Or Condition

//*[@id='txtUsername' and @name='txtUsername' ]
//*[@id='txtUsername' or @name='txtUsername' ]

XPath Parent:

https://stackoverflow.com/questions/28237694/xpath-get-parent-node-from-child-nodeUse with the parent node's name.

//*[title="50"]/parent::store

This XPath will only select the parent node if it is a store.

But you can also use one of these

//*[title="50"]/parent::*
//*[title="50"]/..

todo read
https://stackoverflow.com/questions/22571267/how-to-verify-an-xpath-expression-in-chrome-developers-tool-or-firefoxs-firebug

Xpath finding in Chrome:
https://yizeng.me/2014/03/23/evaluate-and-validate-xpath-css-selectors-in-chrome-developer-tools/

xpath in Developer Tool bar Console Tab
$x("XPATH")
$x(".//div") or $x('.//input')

CSS Path in Developer Tool bar Console Tab
$$("header")
$("#btnNo").css("border-color","red");

http://aksahu.blogspot.in/2014/01/selenium-tricks-for-css-and-xpath-locators.html

(4) Direct Child:
A direct child of an element is denoted as "/" in Xpath and ">" in CSS selector. See the example below for a direct child "li" for a "ul" element:
In Xpath locator

//ul/li

In CSS selector

css=ul > li

(5) Child or Subchild:
A direct child of an element is denoted as "//" in Xpath and a wehite-space(" ") in CSS selector. See the example below for a child/subchild "li" for a "ul" element:
In Xpath locator

//ul//li

In CSS selector

css=ul li

Note that "ul li" and "ul > li" are different. If you are confusing please go through this article.

Firewall

Block IP Packets from Certain region(Country).

Firewall can be software or Dedicated hardware or (Mix of both)

One method firewall uses is Packet filtering.

Firewalls can block ports.

It checks details in the packet header, such as it source and destination, ip address, port number and the protocol its running.

If a request coming from a unknown source or going to an unexpected port. It can block it.
Advance firewall can detect malware in the packets.

Proxy Server

Proxy Server: Server placed in between Client and Internet.

Before forwarding response back to the client, it can filter them to ensure they are safe to receive.

Network Security:
Any request need to be passed through Proxy Server and real IP of the client is not shown. Instead Proxy Server provides its own logical IP address to the Web Server. So any hacker is unable to hack Client as IP is made unavailable.

Network Performance Improvement:
Proxy Server has a cache, so if any client looking for updates then for first time the Proxy will download from internet and saves in the cache. For subsequent client requires the same updates instead of downloading from internet it provides from Cache. Thus, provides congestion free.

Monitor User in the Network:

Block Website: A network admin can block a particular website.

Access Control: Block Facebook and set rule to bypass for particular users.

PhantomJS HTMLUnitDriver Headless -todo-

hi

http://www.automationtestinghub.com/selenium-headless-chrome-firefox/

synchronous vs asynchronous

Link:
https://stackoverflow.com/questions/36213948/what-is-the-difference-between-asynchronous-calls-and-callbacks

Synchronous: Consumer and Provider should be present at same time to communication take page.
Ex: Web Page

In API, the code will be blocked until callback is returned.This means that until a response is returned by the API, your application will not execute any further.

asynchronous: Sender and Receiver does not need to present at same time.
Email or SMS.

Asynchronous calls do not block (or wait) for the API call to return from the server. Execution continues on in your program, and when the call returns from the server, a "callback" function is executed.

ORM : Object Relational Mapping

Mapping data which is in row and columns wise (relational database) to Object

Serialization vs De-serialization

Serialization: Converting an object into stream of bytes.

De-Serialization: Creating an object from the stream of bytes.

.Net Memory Management : Garbage Collector

Allocates Objects into one of 2 heaps

SOH : Small Object Heap : < 85KB : Allocated on Contiguous heap, Objects allocated continuously.

When Object B and Object A finishes its work.(no longer is used) it looses it root reference, when the function allocates and finishes.

Garbage collector: Reclaims memory from rootless objects.
GC: runs whenever the memory usage reaches certain threshold.
GCollector: Freezes all execution threads during Garbage Collection and hits the performance of your application.

LOH : Large : > = 85KB

You allocate on to heap whenever you are using new Keyword in Code.

Conditions for a garbage collection

https://docs.microsoft.com/en-us/dotnet/standard/garbage-collection/fundamentals#conditions_for_a_garbage_collection

Garbage collection occurs when one of the following conditions is true:

The system has low physical memory. This is detected by either the low memory notification from the OS or low memory indicated by the host.
The memory that is used by allocated objects on the managed heap surpasses an acceptable threshold. This threshold is continuously adjusted as the process runs.
The GC.Collect method is called. In almost all cases, you do not have to call this method, because the garbage collector runs continuously. This method is primarily used for unique situations and testing.

Technical Information