KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > dbunit > dataset > SortedTableTest


1 /*
2  *
3  * The DbUnit Database Testing Framework
4  * Copyright (C)2002-2004, DbUnit.org
5  *
6  * This library is free software; you can redistribute it and/or
7  * modify it under the terms of the GNU Lesser General Public
8  * License as published by the Free Software Foundation; either
9  * version 2.1 of the License, or (at your option) any later version.
10  *
11  * This library is distributed in the hope that it will be useful,
12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14  * Lesser General Public License for more details.
15  *
16  * You should have received a copy of the GNU Lesser General Public
17  * License along with this library; if not, write to the Free Software
18  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19  *
20  */

21
22 package org.dbunit.dataset;
23
24 import org.dbunit.dataset.xml.FlatXmlDataSet;
25
26 import java.io.File JavaDoc;
27
28 /**
29  * @author Manuel Laflamme
30  * @version $Revision: 1.3 $
31  */

32 public class SortedTableTest extends AbstractTableTest
33 {
34     public SortedTableTest(String JavaDoc s)
35     {
36         super(s);
37     }
38
39     protected ITable createTable() throws Exception JavaDoc
40     {
41         return createDataSet().getTable("TEST_TABLE");
42     }
43
44     protected IDataSet createDataSet() throws Exception JavaDoc
45     {
46         return new SortedDataSet(new FlatXmlDataSet(
47                 new File JavaDoc("src/xml/sortedTableTest.xml")));
48     }
49
50     public void testGetMissingValue() throws Exception JavaDoc
51     {
52         String JavaDoc columnName = "COLUMN2";
53         Object JavaDoc[] expected = {null, null, null, "0", "1"};
54
55         ITable table = createDataSet().getTable("MISSING_VALUES");
56
57         Column[] columns = table.getTableMetaData().getColumns();
58         assertEquals("column count", 3, columns.length);
59         assertEquals("row count", 5, table.getRowCount());
60         for (int i = 0; i < table.getRowCount(); i++)
61         {
62             assertEquals("value row " + i, expected[i],
63                     table.getValue(i, columnName));
64         }
65     }
66
67
68 }
69
70
71
72
73
74
75
76
77
78
Popular Tags