//PR04: Probar que la base de datos contiene los datos insertados con conexión correcta a la base de datos.
	@Test
    public void prueba04() throws SQLException {
    	Connection con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost:9001/notaneitordb", "SA", "");
    	PreparedStatement prep = con.prepareStatement("select * from tusers where isadmin = false");
    	ResultSet result = prep.executeQuery();
    	int i = 0;
    	while (result.next()){
    		i++;
    		assertEquals(result.getString("login"), "user" + i);
    		assertEquals(result.getString("password"), "user" + i);
    		assertEquals(result.getString("email"), "usuario" + i + "@user.es"); //TODO Cambiar a mail
    	}
    	assertEquals(i, 3);
    	prep = con.prepareStatement("select COUNT(*) from ttasks");
    	result = prep.executeQuery();
    	result.next();
    	assertEquals(90, result.getInt(1)); //TODO Cambiar tamaño a 120

    	prep = con.prepareStatement("SELECT * FROM TTASKS WHERE TITLE LIKE 'Tarea hoy %'");
    	result = prep.executeQuery();
    	i = 0;
    	int j = 1;
    	while(result.next()){
    		i++;
    		assertEquals(result.getString("title"), "Tarea hoy " + i);
    		assertEquals(result.getLong("user_id"), j);
    		if(i % 10 == 0){
    			j++;
    		}

    	}
    	assertEquals(i, 30); //30 tareas para hoy
    }
	//PR05: Visualizar correctamente la lista de usuarios normales.
	@Test
    public void prueba05() throws InterruptedException {
    	driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
		login.rellenaFormulario(driver, "administrador1","administrador1");
		SeleniumUtils.ClickSubopcionMenuHover(driver,
				"form-cabecera:menuOpciones",
				"form-cabecera:subMenuListarUsers");
		elementos = SeleniumUtils.EsperaCargaPagina(driver,
				"class", "ui-sortable-column-icon", 5);


		//comprobar login
		elementos = SeleniumUtils.EsperaCargaPagina(driver, "text", "user", 5);
		assertEquals("user1",
					elementos.get(0).getText());
		assertEquals("user2",
				elementos.get(1).getText());
		assertEquals("user3",
				elementos.get(2).getText());

		//comprobar email
		elementos = SeleniumUtils.EsperaCargaPagina(driver, "text", "@mail.es", 5);
		assertEquals("usuario1@mail.es",
					elementos.get(0).getText());
		assertEquals("usuario2@mail.es",
				elementos.get(1).getText());
		assertEquals("usuario3@mail.es",
				elementos.get(2).getText());


    }