co.edu.uniandes.csw.RigitalApp.test.SQLDevTest.java Source code

Introduction

Here is the source code for co.edu.uniandes.csw.RigitalApp.test.SQLDevTest.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package co.edu.uniandes.csw.RigitalApp.test;

import org.openqa.selenium.WebDriver;
import java.util.List;
import java.util.concurrent.TimeUnit;
import org.junit.*;
import static org.junit.Assert.*;
import org.junit.runner.RunWith;
import org.openqa.selenium.*;
import org.openqa.selenium.firefox.FirefoxDriver;

/**
 *
 * @author estudiante
 */
public class SQLDevTest {

    private static WebDriver driver;

    private static String baseUrl;

    private static boolean acceptNextAlert = true;
    private static StringBuffer verificationErrors = new StringBuffer();

    @BeforeClass
    public static void setUp() throws Exception {
        driver = new FirefoxDriver();

        baseUrl = "http://localhost:8080";

        driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
    }

    @Before
    public void setUpUrl() {
        driver.get(baseUrl + "/RigitalApp.web/sQLDev.html");
    }

    @Test
    public void testCrearMaquina() throws Exception {

        driver.findElement(By.xpath("//button[contains(@id,'button-create')]")).click();

        Thread.sleep(2000);

        driver.findElement(By.id("name")).clear();

        driver.findElement(By.id("name")).sendKeys("Imagine");

        Thread.sleep(2000);

        driver.findElement(By.id("descripcion")).clear();
        driver.findElement(By.id("descripcion")).sendKeys("Base de datos para el sitio Imagine");

        Thread.sleep(2000);

        driver.findElement(By.id("fechaCreacion")).clear();
        driver.findElement(By.id("fechaCreacion")).sendKeys("22/11/2014");

        Thread.sleep(2000);

        driver.findElement(By.className("onoffswitch-label")).click();

        Thread.sleep(2000);

        driver.findElement(By.id("fechaVencimiento")).clear();
        driver.findElement(By.id("fechaVencimiento")).sendKeys("20/02/2015");

        Thread.sleep(2000);

        driver.findElement(By.id("servidor")).clear();
        driver.findElement(By.id("servidor")).sendKeys("sistemas.uniandes.edu.co");

        Thread.sleep(2000);

        driver.findElement(By.id("pgwebId")).clear();
        driver.findElement(By.id("pgwebId")).sendKeys("imagine.uniandes.edu.co");

        Thread.sleep(2000);

        driver.findElement(By.xpath("//button[contains(@id,'button-save')]")).click();

        Thread.sleep(2000);

        WebElement dialog = driver.findElement(By.xpath("//div[contains(@style,'display: block;')]"));

        List<WebElement> table = driver
                .findElements(By.xpath("//table[contains(@class,'table-striped')]/tbody/tr"));
        boolean sucess = false;
        System.out.println(table);

        for (WebElement webElement : table) {
            List<WebElement> elems = webElement.findElements(By.xpath("td"));

            if (elems.get(1).getText().equals("Imagine") && elems.get(2).getText().equals("22/11/2014")
                    && elems.get(3).getText().equals("true")) {

                sucess = true;
            }

        }
        System.out.println(sucess);

        assertTrue(dialog != null && sucess);
    }

    @Test
    public void testDesactivarMaquina() throws Exception {

        Thread.sleep(2000);

        List<WebElement> table = driver
                .findElements(By.xpath("//table[contains(@class,'table-striped')]/tbody/tr"));

        for (WebElement webElement : table) {
            List<WebElement> elems = webElement.findElements(By.xpath("td"));
            if (elems.get(3).getText().equals("true")) {
                elems.get(0).findElement(By.tagName("input")).click();
            }
        }
        Thread.sleep(2000);
        driver.findElement(By.xpath("//button[contains(@id,'button-desactivar')]")).click();

        driver.get(baseUrl + "/RigitalApp.web/sQLDev.html");
        Thread.sleep(2000);
        List<WebElement> table2 = driver
                .findElements(By.xpath("//table[contains(@class,'table-striped')]/tbody/tr"));
        boolean def = true;
        for (WebElement webElement : table2) {
            List<WebElement> elems = webElement.findElements(By.xpath("td"));
            String val = elems.get(3).getText();
            boolean temp = !val.equals("true");
            System.out.println(temp);
            def = def && temp;
        }
        Thread.sleep(4000);
        assertTrue(def);
    }

    @Test
    public void testBuscarMaquina() throws Exception {

        driver.findElement(By.xpath("//button[contains(@id,'button-search')]")).click();

        Thread.sleep(2000);

        driver.findElement(By.id("btn_name")).click();

        Thread.sleep(2000);

        driver.findElement(By.id("name")).clear();

        driver.findElement(By.id("name")).sendKeys("Imagine");

        Thread.sleep(2000);

        driver.findElement(By.xpath("//button[contains(@id,'button-exec-search')]")).click();

        Thread.sleep(2000);

        List<WebElement> table = driver
                .findElements(By.xpath("//table[contains(@class,'table-striped')]/tbody/tr"));
        boolean success = true;

        for (WebElement webElement : table) {
            List<WebElement> elems = webElement.findElements(By.xpath("td"));
            success = success && elems.get(1).getText().contains("Imagine");
        }

        assertTrue(success);
    }

    // La anotacin @AfterClass indica lo que se debe ejecutar DESPUS de ejecutar
    // el archivo de pruebas. Este mtodo cierra la ventana de firefox
    // abierta por @BeforeClass que se utiliz para la prueba.
    @AfterClass
    public static void tearDown() throws Exception {

        driver.get(baseUrl + "/RigitalApp.web/sQLDev.html");
        // Se selecciona la tabla para eliminar todos sus elementos
        List<WebElement> table = driver
                .findElements(By.xpath("//table[contains(@class,'table-striped')]/tbody/tr"));

        /**
         * Se itera sobre los elementos de la tabla para eliminarlos
         */
        for (WebElement webElement : table) {
            List<WebElement> elems = webElement.findElements(By.xpath("td"));
            elems.get(5).findElement(By.linkText("Eliminar")).click();
            assertTrue(true);
        }

        // Se cierra el navegador.
        driver.quit();
        // Se verifica que se haya cerrado efectivamente el navegador.
        String verificationErrorString = verificationErrors.toString();
        if (!"".equals(verificationErrorString)) {
            fail(verificationErrorString);
        }
    }
}