Tuesday, 10 May 2022

User Login, Logout on Edge, Chrome, Firefox using Java with Selenium | Learn Coding

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.edge.EdgeDriver;
import org.openqa.selenium.firefox.FirefoxDriver;

import io.github.bonigarcia.wdm.WebDriverManager;

public class locatorpractice {

public static void main(String[] args) throws InterruptedException {


WebDriverManager.chromedriver().setup();
WebDriver driver= new ChromeDriver();
driver.get("https://demoqa.com/books");
driver.manage().window().maximize();
Thread.sleep(2000);
driver.findElement(By.id("login")).click();
driver.findElement(By.id("userName")).sendKeys("btester");
driver.findElement(By.id("password")).sendKeys("Btester@1234");
driver.findElement(By.id("login")).click();
Thread.sleep(2000);
driver.findElement(By.linkText("Git Pocket Guide")).click();
Thread.sleep(1000);
driver.findElement(By.id("submit")).click();

// driver.quit();



// Login Test on Edge Browser


WebDriverManager.edgedriver().setup();
WebDriver driver1= new EdgeDriver();
driver1.get("https://demoqa.com/books");
driver1.manage().window().maximize();
Thread.sleep(2000);
driver1.findElement(By.id("login")).click();
driver1.findElement(By.id("userName")).sendKeys("btester");
driver1.findElement(By.id("password")).sendKeys("Btester@1234");
driver1.findElement(By.id("login")).click();
Thread.sleep(2000);
driver1.findElement(By.linkText("Git Pocket Guide")).click();
Thread.sleep(1000);
driver1.findElement(By.id("submit")).click();
//driver1.quit();


// Login Test on Firefox Browser

WebDriverManager.firefoxdriver().setup();
WebDriver driver2= new FirefoxDriver();
driver2.get("https://demoqa.com/books");
driver2.manage().window().maximize();
Thread.sleep(2000);
driver2.findElement(By.id("login")).click();
driver2.findElement(By.id("userName")).sendKeys("btester");
driver2.findElement(By.id("password")).sendKeys("Btester@1234");
driver2.findElement(By.id("login")).click();
Thread.sleep(2000);
driver2.findElement(By.linkText("Git Pocket Guide")).click();
Thread.sleep(1000);
driver2.findElement(By.id("submit")).click();
//driver1.quit();
}

}

Wednesday, 4 May 2022

Using Locators in Selenium using Java | Learning Automation | Eclipse


import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;

public class locatorpractice {

public static void main(String[] args) {


System.setProperty("webdriver.chrome.driver","C:/chromedriver_win32/chromedriver.exe");
WebDriver driver = new ChromeDriver();

driver.get("https://www.google.co.in/");
driver.manage().window().maximize();
driver.findElement(By.linkText("Sign in")).click();
driver.findElement(By.id ("identifierId")).sendKeys("test@gmail.com");
driver.findElement(By.className("VfPpkd-vQzf8d")).click();



}

}

Tuesday, 3 May 2022

Database Basic Query for Beginner | Learn MySQL | Using PgAdmin


select * from employees;

Select * from employees where firstname='Rohit';

Select * from employees where firstname like '_o%';

select * from employees order by city asc;

select * from employees limit 2;


CREATE TABLE Persons (
    ID int NOT NULL UNIQUE,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

select * from Persons;

INSERT INTO persons (ID, LastName, FirstName, Age)
VALUES (6,null, 'Rohit', 34);

INSERT INTO persons (ID, LastName, FirstName, Age)
VALUES (6,'Sahoo', 'Rohit', 34);

update Persons set lastname='Sahoo' where id=5;

UPDATE Persons
SET lastname='Soni' where id='6';

select firstname ||' '|| lastname as Name from persons order by id limit 2;

select SUM(age) from persons;

select count(age) from persons where age=34;

select round(AVG (age)) from persons;

select MIN(age) from persons;

select MAX(age) from persons;

SELECT DISTINCT age FROM persons;

UPDATE persons SET age = age*1.2
where firstname like 'Ro%';

select * from employees;
select * from persons;

SELECT employees.firstname, employees.lastname
FROM employees
INNER JOIN persons
ON persons.lastname = employees.lastname;



Invoking Browser in Java | Learning Selenium

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.edge.EdgeDriver;
import org.openqa.selenium.firefox.FirefoxDriver;


public class selintroduction {

//public class selintroduction implements WebDriver {

public static void main(String[] args) {
// Invoking Browser
//ChromeDriver = All Method to automate on chrome browser like Open or close
//Create object

//WebDriver - only method name with empty body -  Need to add implements
// Web driver method + Own method

// ChromeDriver driver = new ChromeDriver();

//Chromedriver.exe Middle man - Open the browser
//Webdriver.chrome.driver= value of path

// System.setProperty("webdriver.chrome.driver","C:/chromedriver_win32/chromedriver.exe");
      //  String baseUrl = "https://www.google.co.in/";
       
       
      //  System.setProperty("webdriver.gecko.driver","C:/geckodriver-v0.30.0-win64/geckodriver.exe");
     //   String baseUrl = "https://www.google.co.in/";
       
       
      System.setProperty("webdriver.edge.driver","C:/edgedriver_win64/msedgedriver.exe");
        String baseUrl = "https://www.google.co.in/";
       
       
// WebDriver driver = new ChromeDriver();

// WebDriver driver = new FirefoxDriver();

WebDriver driver = new EdgeDriver();

driver.get(baseUrl);
driver.manage().window().maximize();

System.out.println(baseUrl);

// driver.close();

// driver.quit();



}

}

Writing POM File with Maven Dependencies | Learning Selenium | Automation


<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>Introgroup01</groupId>
  <artifactId>artifact01-java</artifactId>
  <version>0.0.1-SNAPSHOT</version>
 
  <dependencies>
 
  <!-- https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java -->
<dependency>
    <groupId>org.seleniumhq.selenium</groupId>
    <artifactId>selenium-java</artifactId>
    <version>4.1.2</version>
</dependency>
 
  <!-- https://mvnrepository.com/artifact/org.testng/testng -->
<!-- https://mvnrepository.com/artifact/org.testng/testng -->
<dependency>
    <groupId>org.testng</groupId>
    <artifactId>testng</artifactId>
    <version>7.5</version>
    <scope>test</scope>
</dependency>

 
 
  </dependencies>
 
  <build>
    <sourceDirectory>src</sourceDirectory>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.8.1</version>
        <configuration>
          <release>17</release>
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>

Use of Match Functions in Java | Learning Selenium


public class math {

public static void main(String[] args) {
// TODO Auto-generated method stub
   
       double x = 24;    
       double y = 4;
         
       // return the maximum of two numbers  
       System.out.println("Maximum number of x and y is: " +Math.max(x, y));  
         
       // return the square root of y  
       System.out.println("Square root of y is: " + Math.sqrt(y));  
         
       //returns 28 power of 4 i.e. 28*28*28*28    
       System.out.println("Power of x and y is: " + Math.pow(x, y));      
     
}    

}

User Login, Logout on Edge, Chrome, Firefox using Java with Selenium | Learn Coding

import org.openqa.selenium.By ; import org.openqa.selenium.WebDriver; import org.openqa.selenium.chrome.ChromeDriver; import org.openqa.sele...