Development

Selenium, data driven testing using NUnit and SQL queries.

I am developing a Selenium Test Automation Framework for the purpose of testing multiple websites.

I have currently set up the Framework in Visual Studio using C# and implementing the Page Object Model.

The Framework itself is a C# project and the Test project is separate but references the Framework.

I am happy with the fundamentals of the Framework but I want to implement some Data Driven aspects in order to increase the durability of the tests. I currently have NUnit running paramaterised test using [TestCase] but the data is hardcoded by me.

The ideal scenario would be to add a DatabaseHelper class to the Framework which would allow me to define queries on the database under test to return values and Nunit would repeat the same test for each row of the SQL query.

Has anyone here implemented a similar method and how would you go about creating it?

jmeter v5.1.1 – cannot generate html report

I have a result file of Concurrency Thread Group test of 500 users.
The file has aproximetly 58K rows and 16Mb

1) I tried generating a report through “Tool > Generate html report” but get time-out exception, I have increased the timer to 480000 but the result was the same.

2) I tried generate report through cmd -> it was running for a few hours and again no result, no report, all logs files have no exceptions.

Is there limitation of a report’s rows?
please help!

Development

How to load chrome profile with Selenium correctly?

So I am trying to write a test in which the first step is logging in, but it is denying me access as it detected automation tools because the javascript has not been enabled and there is no profile. So I am trying to load my default profile. The problem I’m getting is that the browser does open, but it quickly fails as I get a SessionNotCreatedException. The failure occurs in the service hooks:
@Before(“@FrontendTest”)
public void setup() {

System.setProperty(“webdriver.chrome.driver”,
“E:\interview_notcodegod\src\drivers\chromedriver.exe” );

ChromeOptions options = new ChromeOptions();

options.addArguments(“–enable-javascript”);

options.addArguments(“–user-data-dir=C:/Users/[username]/AppData/Local/Google/Chrome/User Data”);

WebDriverManager.chromedriver().setup();
driver = new ChromeDriver(options); // intellij points here (nullpointerexception)
driver.manage().window().maximize();
}

Is there a line of code that i’m missing? I’ve updated my chromedriver already because I thought that was the issue (chrome Version 99.0.4844.74 (Official Build) (64-bit), chromedriver:99.0.4844.51)