DMETestUtility 1.2.2

DMETestUtility

Library with utility methods for autotest development speedup and QOL

Classes

• DriverManager
• Logger
• SQLHandler
• Utility

Installation

Installation from Nuget

 dotnet add package DMETestUtility 
 using DMETestUtility
 using DMETestUtility.Logger
 using DMETestUtility.Drivers

To begin work with library you need to install a Selenium libraries for related drivers

 dotnet add package Selenium.WebDriver.ChromeDriver 
 dotnet add package Selenium.WebDriver.GeckoDriver 
 dotnet add package Selenium.WebDriver.MSEdgeDriver 

Usage

Webdriver initialisation

using DMETestUtility.Drivers
using DMETestUtility

public TestLogger Logs = new TestLogger();

DriverManager _driver = new DriverManager()
 {
 browser = chrome/firefox/edge,
 Logs = this.Logs,
 _url = "https://url.com"
 windowSize = "1900, 1600",
 };
///
LoadTimeSpanMin - Wait time for page load in minutes 
WaitTimeSec - Implicit wait for web elements locators
///
_webDriver = _driver.DriverInitialise(int LoadTimeSpanMin, int WaitTimeSec);

Logs method

using DMETestUtility.Logger
using DMETestUtility

public TestLogger Logs = new TestLogger();

///
This metods puts a message in a queue
///
Logs.AddLog(string message)
Logs.AddWarningLog(string message)
Logs.AddErrorLog(Exception exception)

///
This method creates a folder Logs in MyDocs directory and writs down a messages from the queue in file passed in the params of this method or Logs.txt by default
///
Logs.WriteLogToFile(string logfilename)

Database connection method

using DMETestUtility
///
Params: 
1) string dataSource - Database server
2) string userId - Username for connection
3) string password - Password for user
4) string catalog - Database where expression is executed 
5) bool trustCertificate - SSL certificate trust
///
SqlHandler sqlHandler = new(dataSource, userId, password, catalog, trustCertificate);
string expression = $"expression";
sqlHandler._catalog = "Database catalog";
sqlHandler._expression = expression;
string _connectionString = sqlHandler.BuildConnectionString();
SqlDataReader _dataReader = sqlHandler.SqlConnect(_connectionString);
/// 
Second parameter is index from which column data is taken
///
List<object> _keys = sqlHandler.RetrieveInfo(_dataReader, 1);