View Javadoc
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  package org.dbunit.dataset.sqlloader;
22  
23  import java.io.File;
24  
25  import junit.framework.TestCase;
26  
27  import org.dbunit.dataset.DataSetException;
28  import org.dbunit.dataset.IDataSet;
29  import org.dbunit.dataset.ITable;
30  import org.dbunit.testutil.TestUtils;
31  
32  /**
33   * @author Stephan Strittmatter (stritti AT users.sourceforge.net)
34   * @author Last changed by: $Author$
35   * @version $Revision$ $Date$
36   * @since 2.4.0
37   */
38  public class SqlLoaderCsvDataSetTest extends TestCase {
39  
40      /**
41       * Gets the data set.
42       * 
43       * @return the data set
44       * 
45       * @throws DataSetException the data set exception
46       */
47      protected IDataSet getDataSet() throws DataSetException {
48  
49          SqlLoaderControlDataSet loadedDataSet =
50              new SqlLoaderControlDataSet(TestUtils.getFile("sqlloader"), TestUtils.getFile("sqlloader/tables.lst"));
51  
52          return loadedDataSet;
53      }
54  
55      /**
56       * Test null columns.
57       * 
58       * @throws DataSetException the data set exception
59       */
60      public void testCountryTable() throws DataSetException {
61  
62          ITable table = getDataSet().getTable("COUNTRY");
63  
64          assertEquals(249, table.getRowCount());
65          
66          // One sample test value
67          Object val = table.getValue(3, "NAME");
68          assertEquals("AMERICAN_SAMOA", val);
69      }
70  
71  }