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: jbhurst $
35 * @version $Revision: 1162 $ $Date: 2010-02-12 00:29:37 +0100 (ven, 12 feb 2010) $
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 }