1 /*
2 *
3 * The DbUnit Database Testing Framework
4 * Copyright (C)2002-2008, 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.util;
22
23 import java.math.BigDecimal;
24
25 import org.dbunit.dataset.Column;
26 import org.dbunit.dataset.DefaultTable;
27 import org.dbunit.dataset.datatype.DataType;
28
29 import junit.framework.TestCase;
30
31 /**
32 * Unit test for the {@link TableFormatter}
33 * @author gommma (gommma AT users.sourceforge.net)
34 * @author Last changed by: $Author: gommma $
35 * @version $Revision: 896 $ $Date: 2008-11-29 20:54:27 +0100 (sab, 29 nov 2008) $
36 * @since 2.4.1
37 */
38 public class TableFormatterTest extends TestCase
39 {
40
41 public void testFormatSimpleTable() throws Exception
42 {
43 Column[] cols = new Column[]{
44 new Column("COL1", DataType.VARCHAR),
45 new Column("COL2", DataType.NUMERIC)
46 };
47 DefaultTable table = new DefaultTable("MY_TABLE", cols);
48 table.addRow(new Object[]{
49 "my string value", new BigDecimal("39284.1")
50 });
51 table.addRow(new Object[]{
52 "my string value2", new BigDecimal("2")
53 });
54
55 TableFormatter formatter = new TableFormatter();
56 String actual = formatter.format(table);
57
58 String expected =
59 "****** table: MY_TABLE ** row count: 2 ******\n"+
60 "COL1 |COL2 |\n"+
61 "====================|====================|\n"+
62 "my string value |39284.1 |\n"+
63 "my string value2 |2 |\n";
64 assertEquals(expected, actual);
65 // System.out.println(actual);
66 }
67 }