Package org.dbunit.dataset

Examples of org.dbunit.dataset.ITable

504
505
506
507
508
509
510
511
512
513
514
       
        // update
        storyMapper.addOrUpdate(storyToUpdate);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BUSINESSVALUE);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("description", "HIGH", databaseData.getValue(0, "description"));
    }
View Full Code Here
525
526
527
528
529
530
531
532
533
534
535
       
        // update
        storyMapper.addOrUpdate(storyToUpdate);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_RISKLEVEL);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("description", "MEDIUM", databaseData.getValue(0, "description"));
    }
View Full Code Here
546
547
548
549
550
551
552
553
554
555
556
       
        // update
        storyMapper.addOrUpdate(storyToUpdate);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_USER1);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("firstname", "Pon", databaseData.getValue(0, "firstname"));
    }
View Full Code Here
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
       
        // update
        storyMapper.addOrUpdate(storyToAdd);
       
        // check story
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY_TO_ADD);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("id", new Integer(storyToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    assertEquals("pro_id", new Integer(storyToAdd.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    assertEquals("description", storyToAdd.getDescription(), (String) databaseData.getValue(0, "description"));
    assertEquals("daysestimated", new Double(storyToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
        assertEquals("bus_id", new Integer(storyToAdd.getBusinessValue().getId()),  (Integer) databaseData.getValue(0, "bus_id"));
        assertEquals("ris_id", new Integer(storyToAdd.getRiskLevel().getId()),  (Integer) databaseData.getValue(0, "ris_id"));
    assertEquals("shortdescription", storyToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
      assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
     
      // chek tasks

      // task1
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK1_TO_ADD);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("pmu_id", task1ToAdd.getOwner(), databaseData.getValue(0, "pmu_id"));
    assertEquals("daysestimated", new Double(task1ToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
    assertEquals("shortdescription", task1ToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
   
      // task2
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK2_TO_ADD);
       
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("pmu_id", task2ToAdd.getOwner(), databaseData.getValue(0, "pmu_id"));
    assertEquals("daysestimated", new Double(task2ToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
    assertEquals("shortdescription", task2ToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));

    // check charge
   
    // charge 1
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE1_TO_ADD);
   
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("id", new Integer(charge1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    // TODO comment tester cela ?
    // assertEquals("tas_id", new Integer(task1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "tas_id"));
    assertEquals("pmu_id", new Integer(charge1ToAdd.getUser().getPersistanceId()), (Integer) databaseData.getValue(0, "pmu_id"));
    assertEquals("day", charge1ToAdd.getDay(), (Date) databaseData.getValue(0, "day"));
    assertEquals("timeused", new Double(charge1ToAdd.getTimeUsedToday()), new Double (databaseData.getValue(0, "timeused").toString()));
    assertEquals("daysneededtofinish", new Double(charge1ToAdd.getDaysNeededToFinish()), new Double (databaseData.getValue(0, "daysneededtofinish").toString()));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));

    // charge 2
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE2_TO_ADD);
   
    assertEquals("number of row", 1, databaseData.getRowCount());
   
    assertEquals("id", new Integer(charge2ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    // TODO comment tester cela ?
    //assertEquals("tas_id", new Integer(task1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "tas_id"));
    assertEquals("pmu_id", new Integer(charge2ToAdd.getUser().getPersistanceId()), (Integer) databaseData.getValue(0, "pmu_id"));
    assertEquals("day", charge2ToAdd.getDay(), (Date) databaseData.getValue(0, "day"));
    assertEquals("timeused", new Double(charge2ToAdd.getTimeUsedToday()), new Double (databaseData.getValue(0, "timeused").toString()));
    assertEquals("daysneededtofinish", new Double(charge2ToAdd.getDaysNeededToFinish()), new Double (databaseData.getValue(0, "daysneededtofinish").toString()));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));


    }
View Full Code Here
662
663
664
665
666
667
668
669
670
671
672
673
       
        // add
        storyMapper.addOrUpdate(storyToAdd);
       
        // 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
683
684
685
686
687
688
689
690
691
692
693
694
       
        // add
        storyMapper.addOrUpdate(storyToAdd);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BUSINESSVALUE);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("description", "HIGH", databaseData.getValue(0, "description"));

    }
View Full Code Here
704
705
706
707
708
709
710
711
712
713
714
715
       
        // add
        storyMapper.addOrUpdate(storyToAdd);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_RISKLEVEL);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("description", "MEDIUM", databaseData.getValue(0, "description"));

    }
View Full Code Here
725
726
727
728
729
730
731
732
733
734
735
       
        // update
        storyMapper.addOrUpdate(storyToAdd);
       
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_USER1);
       
        assertEquals("number of row", 1, databaseData.getRowCount());
       
        assertEquals("firstname", "Pon", databaseData.getValue(0, "firstname"));
    }
View Full Code Here
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
       
        // 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
849
850
851
852
853
854
855
856
857
858
    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
TOP

Related Classes of org.dbunit.dataset.ITable

  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSet
  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSetWriter
  • cn.baiweigang.qtaf.toolkit.dbunit.DbUnitUtil
  • com.aconex.scrutineer.jdbc.HSQLHelper
  • com.danhaywood.java.testsupport.dbunit.DbUnitRuleTest
  • com.github.springtestdbunit.assertion.NonStrictDatabaseAssertion
  • com.github.springtestdbunit.dataset.ReplacementDataSetLoaderTests
  • com.github.springtestdbunit.DbUnitRunner
  • com.vblinov.tester.DDLTest
  • com.vblinov.tester.QueriesTest
    • 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.