IntegerDataType.java

  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.datatype;

  22. import java.math.BigDecimal;
  23. import java.sql.PreparedStatement;
  24. import java.sql.ResultSet;
  25. import java.sql.SQLException;

  26. import org.dbunit.dataset.ITable;
  27. import org.slf4j.Logger;
  28. import org.slf4j.LoggerFactory;

  29. /**
  30.  * @author Manuel Laflamme
  31.  * @version $Revision$
  32.  */
  33. public class IntegerDataType extends AbstractDataType
  34. {
  35.     private static final Logger logger =
  36.             LoggerFactory.getLogger(IntegerDataType.class);

  37.     IntegerDataType(final String name, final int sqlType)
  38.     {
  39.         super(name, sqlType, Integer.class, true);
  40.     }

  41.     ////////////////////////////////////////////////////////////////////////////
  42.     // DataType class

  43.     @Override
  44.     public Object typeCast(final Object value) throws TypeCastException
  45.     {
  46.         logger.debug("typeCast(value={}) - start", value);

  47.         if (value == null || value == ITable.NO_VALUE)
  48.         {
  49.             return null;
  50.         }

  51.         if (value instanceof Number)
  52.         {
  53.             return ((Number) value).intValue();
  54.         }

  55.         // Treat "false" as 0, "true" as 1
  56.         if (value instanceof String)
  57.         {
  58.             final String string = (String) value;

  59.             if ("false".equalsIgnoreCase(string))
  60.             {
  61.                 return 0;
  62.             }

  63.             if ("true".equalsIgnoreCase(string))
  64.             {
  65.                 return 1;
  66.             }
  67.         }

  68.         // Bugfix in release 2.4.6
  69.         final String stringValue = value.toString().trim();
  70.         if (stringValue.length() <= 0)
  71.         {
  72.             return null;
  73.         }

  74.         try
  75.         {
  76.             return typeCast(new BigDecimal(stringValue));
  77.         } catch (final java.lang.NumberFormatException e)
  78.         {
  79.             throw new TypeCastException(value, this, e);
  80.         }
  81.     }

  82.     @Override
  83.     public Object getSqlValue(final int column, final ResultSet resultSet)
  84.             throws SQLException, TypeCastException
  85.     {
  86.         logger.debug("getSqlValue(column={}, resultSet={}) - start", column,
  87.                 resultSet);
  88.         final int rawValue = resultSet.getInt(column);
  89.         final Integer value = resultSet.wasNull() ? null : rawValue;
  90.         logger.debug("getSqlValue: column={}, value={}", column, value);
  91.         return value;
  92.     }

  93.     @Override
  94.     public void setSqlValue(final Object value, final int column,
  95.             final PreparedStatement statement)
  96.             throws SQLException, TypeCastException
  97.     {
  98.         logger.debug("setSqlValue(value={}, column={}, statement={}) - start",
  99.                 value, column, statement);

  100.         statement.setInt(column, (Integer) typeCast(value));
  101.     }
  102. }