1   package org.dbunit.ext.mssql;
2   
3   import org.dbunit.dataset.datatype.DataType;
4   import org.dbunit.dataset.datatype.IDataTypeFactory;
5   import junit.framework.TestCase;
6   
7   /**
8    * Created By:   fede
9    * Date:         8-set-2004 
10   * Time:         15.08.55
11   *
12   * Last Checkin: $Author: gommma $
13   * Date:         $Date: 2009-10-31 12:38:36 +0100 (sab, 31 ott 2009) $
14   * Revision:     $Revision: 1087 $
15   */
16  public class MsSqlDataTypeFactoryTest extends TestCase {
17      public MsSqlDataTypeFactoryTest(String s)
18      {
19          super(s);
20      }
21  
22      public IDataTypeFactory createFactory() throws Exception
23      {
24          return new MsSqlDataTypeFactory();
25      }
26  
27      public void testCreateCharDataType() throws Exception
28      {
29      	int sqlType = MsSqlDataTypeFactory.NCHAR;
30      	String sqlTypeName = "nchar";
31  
32      	DataType expected = DataType.CHAR;
33      	DataType actual = createFactory().createDataType(sqlType, sqlTypeName);
34      	assertEquals("type", expected, actual);
35      }
36  
37      public void testCreateVarcharDataType() throws Exception
38      {
39      	int sqlType = MsSqlDataTypeFactory.NVARCHAR;
40      	String sqlTypeName = "nvarchar";
41  
42      	DataType expected = DataType.VARCHAR;
43      	DataType actual = createFactory().createDataType(sqlType, sqlTypeName);
44      	assertEquals("type", expected, actual);
45      }
46  
47      public void testCreateLongVarcharDataTypeFromNtext() throws Exception
48      {
49      	int sqlType = MsSqlDataTypeFactory.NTEXT;
50      	String sqlTypeName = "ntext";
51  
52      	DataType expected = DataType.LONGVARCHAR;
53      	DataType actual = createFactory().createDataType(sqlType, sqlTypeName);
54      	assertEquals("type", expected, actual);
55      }
56      
57      public void testCreateLongVarcharDataTypeFromNtextMsSql2005() throws Exception
58      {
59      	int sqlType = MsSqlDataTypeFactory.NTEXT_MSSQL_2005;
60      	String sqlTypeName = "ntext";
61  
62      	DataType expected = DataType.LONGVARCHAR;
63      	DataType actual = createFactory().createDataType(sqlType, sqlTypeName);
64      	assertEquals("type", expected, actual);
65      }}