View Javadoc
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$
35   * @version $Revision$ $Date$
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  }