Package org.dbunit.dataset

Examples of org.dbunit.dataset.ITable


       
        // delete
        storyMapper.delete(storyToUpdate);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY_TO_UPDATE);
       
    assertEquals("number of row", 0, databaseData.getRowCount());
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK1_TO_UPDATE);
       
    assertEquals("number of row", 0, databaseData.getRowCount());
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK2_TO_UPDATE);
       
    assertEquals("number of row", 0, databaseData.getRowCount());
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE1_TO_UPDATE);
       
    assertEquals("number of row", 0, databaseData.getRowCount());
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE2_TO_UPDATE);
       
    assertEquals("number of row", 0, databaseData.getRowCount());
   
   
       
    }
View Full Code Here


    public void testDeleteDoesNotDeleteProject() throws Exception {
       
        storyMapper.delete(storyToUpdate);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BASICPROJECT);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
       
    }
View Full Code Here

    public void testDeleteDoesNotDeleteBusinessValue() throws Exception {
       
        storyMapper.delete(storyToUpdate);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BUSINESSVALUE);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
    }
View Full Code Here

    public void testDeleteDoesNotDeleteRiskLevel() throws Exception {
       
        storyMapper.delete(storyToUpdate);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_RISKLEVEL);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
    }
View Full Code Here

       
        // update
        iterationMapper.addOrUpdate(iterationToUpdate);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_ITERATION_FOR_UPDATE);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("id", new Integer(iterationToUpdate.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    assertEquals("rel_id", new Integer(3) , (Integer) databaseData.getValue(0, "rel_id"));
    assertEquals("pro_id", new Integer(iterationToUpdate.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    // TODO comment tester les dates ??
//      assertEquals("start", iterationToUpdate.getStart(), (Date) databaseData.getValue(0, "start") );
//      assertEquals("end", iterationToUpdate.getStart(), (Date) databaseData.getValue(0, "end") );
      assertEquals("version", new Long(persistanceVersion), (Long) databaseData.getValue(0, "version"));
       
    }
View Full Code Here

       
        // update
        iterationMapper.addOrUpdate(iterationToUpdate);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_ITERATION_FOR_UPDATE);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("id", new Integer(iterationToUpdate.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    assertEquals("rel_id", new Integer(3) , (Integer) databaseData.getValue(0, "rel_id"));
    assertEquals("pro_id", new Integer(iterationToUpdate.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    // TODO comment tester les dates ??
//      assertEquals("start", iterationToUpdate.getStart(), (Date) databaseData.getValue(0, "start") );
//      assertEquals("end", iterationToUpdate.getStart(), (Date) databaseData.getValue(0, "end") );
      assertEquals("version", new Long(persistanceVersion), (Long) databaseData.getValue(0, "version"));
     
    // check the stories
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY1);
    assertEquals("id", new Integer(1), (Integer) databaseData.getValue(0, "id"));
    assertEquals("ite_id", new Integer(iterationToUpdate.getPersistanceId()), (Integer) databaseData.getValue(0, "ite_id"));
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY2);
    assertEquals("id", new Integer(2), (Integer) databaseData.getValue(0, "id"));
    assertEquals("ite_id", new Integer(iterationToUpdate.getPersistanceId()), (Integer) databaseData.getValue(0, "ite_id"));
       
    }
View Full Code Here

       
        // update
        iterationMapper.addOrUpdate(iterationToUpdate);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BASICPROJECT);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("name", "Super A", databaseData.getValue(0, "name"));

    }
View Full Code Here

               
        // add
        iterationMapper.addOrUpdate(iterationToUpdate);
       
    // check the stories
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY1);
    assertEquals("id", new Integer(1), (Integer) databaseData.getValue(0, "id"));
    assertEquals("description", "faire un report d'avancement des tâches à modifier", (String) databaseData.getValue(0, "description"));
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY2);
    assertEquals("id", new Integer(2), (Integer) databaseData.getValue(0, "id"));
    assertEquals("description", "faire une revue de code de l'iteration courant", (String) databaseData.getValue(0, "description"));

    }
View Full Code Here

       
        // update
        iterationMapper.addOrUpdate(iterationToAdd);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_ITERATION_FOR_ADD);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertTrue("id", new Integer(iterationToAdd.getPersistanceId()) != (Integer) databaseData.getValue(0, "id"));
    assertEquals("rel_id", null , (Integer) databaseData.getValue(0, "rel_id"));
    assertEquals("pro_id", new Integer(iterationToAdd.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    // TODO comment tester les dates ??
//      assertEquals("start", iterationToAdd.getStart(), (Date) databaseData.getValue(0, "start") );
//      assertEquals("end", iterationToAdd.getStart(), (Date) databaseData.getValue(0, "end") );
      assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
       
    }
View Full Code Here

     
      // update
        iterationMapper.addOrUpdate(iterationToAdd);
       
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_ITERATION_FOR_ADD);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertTrue("id", new Integer(iterationToAdd.getPersistanceId()) != (Integer) databaseData.getValue(0, "id"));
    assertEquals("rel_id", null , (Integer) databaseData.getValue(0, "rel_id"));
    assertEquals("pro_id", new Integer(iterationToAdd.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    // TODO comment tester les dates ??
//      assertEquals("start", iterationToAdd.getStart(), (Date) databaseData.getValue(0, "start") );
//      assertEquals("end", iterationToAdd.getStart(), (Date) databaseData.getValue(0, "end") );
      assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
     
    // check the stories
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY1);
    assertEquals("id", new Integer(1), (Integer) databaseData.getValue(0, "id"));
    assertEquals("ite_id", new Integer(iterationToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "ite_id"));
   
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY2);
    assertEquals("id", new Integer(2), (Integer) databaseData.getValue(0, "id"));
    assertEquals("ite_id", new Integer(iterationToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "ite_id"));

       
    }
View Full Code Here

TOP

Related Classes of org.dbunit.dataset.ITable

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.