All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.relique.jdbc.csv.StringConverter Maven / Gradle / Ivy

The newest version!
/*
 *  CsvJdbc - a JDBC driver for CSV files
 *  Copyright (C) 2001  Jonathan Ackerman
 *
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Lesser General Public
 *  License as published by the Free Software Foundation; either
 *  version 2.1 of the License, or (at your option) any later version.
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Lesser General Public License for more details.
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this library; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 */
package org.relique.jdbc.csv;

import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.math.BigDecimal;
import java.sql.Array;
import java.sql.DatabaseMetaData;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.sql.Types;
import java.text.DateFormatSymbols;
import java.text.DecimalFormat;
import java.text.DecimalFormatSymbols;
import java.text.ParseException;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.ZoneId;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import java.time.format.DateTimeFormatterBuilder;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.TimeZone;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class StringConverter
{
	/*
	 * Key used when passing around a converter as part of a HashMap for a database row.
	 * Use upper-case, as class ColumnName converts all keys to upper-case too.
	 */
	public static final String COLUMN_NAME = "@STRINGCONVERTER";

	private String dateFormat;
	private SimpleDateFormat simpleTimeFormat;
	private String timeFormat;
	private GregorianCalendar calendar;
	private Pattern timestampPattern;
	private SimpleDateFormat timestampFormat;
	private SimpleDateFormat simpleDateFormat;
	private int currentYear;
	private DecimalFormatSymbols decimalFormatSymbols;

	// Alternative Java 8 classes for parsing and formatting dates, times, timestamps.
	DateTimeFormatter dateFormatter;
	DateTimeFormatter timeFormatter;
	DateTimeFormatter timestampFormatter;

	public StringConverter(String dateformat, String timeformat, String timestampformat,
		String timeZoneName, boolean useDateTimeFormatter)
	{
		init(dateformat, timeformat, timestampformat, timeZoneName, null, useDateTimeFormatter);
	}

	public StringConverter(String dateformat, String timeformat, String timestampformat,
		String timeZoneName, Locale locale, boolean useDateTimeFormatter)
	{
		init(dateformat, timeformat, timestampformat, timeZoneName, locale, useDateTimeFormatter);
	}

	private void init(String dateformat, String timeformat, String timestampformat,
		String timeZoneName, Locale locale, boolean useDateTimeFormatter)
	{
		dateFormat = dateformat;
		if (dateformat != null)
		{
			if (useDateTimeFormatter)
			{
				dateFormatter = createFormatter(dateFormat, locale, timeZoneName);
			}
			else
			{
				/*
				 * Can date be parsed with a simple regular expression, or is the full
				 * SimpleDateFormat parsing required?
				 */
				// TODO prefer to use SimpleDateFormat for everything but existing regex not 100% compatible
				String upper = dateformat.toUpperCase(Locale.US);
				boolean useSimpleDateFormat = false;
				if (upper.contains("MMM"))
				{
					/*
					 * Dates contain named months -- we need to use a SimpleDateFormat to parse them.
					 */
					useSimpleDateFormat = true;
				}
				else
				{
					for (int i = 0; i < upper.length(); i++)
					{
						char c = upper.charAt(i);
						if (Character.isLetter(c) && c != 'D' && c != 'M' && c != 'Y')
						{
							/*
							 * Dates are not just a straightforward format with days, months,
							 * years -- we need to use a SimpleDateFormat to parse them.
							 */
							useSimpleDateFormat = true;
						}
					}
				}
				if (useSimpleDateFormat)
				{
					/*
					 * Use Java API for parsing dates.
					 */
					if (locale != null)
					{
						DateFormatSymbols symbols = DateFormatSymbols.getInstance(locale);
						simpleDateFormat = new SimpleDateFormat(dateformat, symbols);
					}
					else
					{
						simpleDateFormat = new SimpleDateFormat(dateformat);
					}
				}
			}
		}
		
		/*
		 * Use Java API for parsing times.
		 */
		timeFormat = timeformat;
		if (useDateTimeFormatter)
		{
			timeFormatter = createFormatter(timeFormat, locale, timeZoneName);
		}
		else
		{
			if (locale != null)
			{
				DateFormatSymbols symbols = DateFormatSymbols.getInstance(locale);
				simpleTimeFormat = new SimpleDateFormat(timeformat, symbols);
			}
			else
			{
				simpleTimeFormat = new SimpleDateFormat(timeformat);
			}
		}

		if (useDateTimeFormatter)
		{
			if (timestampformat == null)
				timestampformat = "yyyy-MM-dd HH:mm:ss";
			timestampFormatter = createFormatter(timestampformat, locale, timeZoneName);
		}
		else
		{
			TimeZone timeZone = TimeZone.getTimeZone(timeZoneName);
			calendar = new GregorianCalendar();
			calendar.setTimeInMillis(System.currentTimeMillis());
			currentYear = calendar.get(Calendar.YEAR);
			calendar.clear();
			calendar.setTimeZone(timeZone);
			if (timestampformat != null && timestampformat.length() > 0)
			{
				/*
				 * Use Java API for parsing dates and times.
				 */
				if (locale != null)
				{
					DateFormatSymbols symbols = DateFormatSymbols.getInstance(locale);
					timestampFormat = new SimpleDateFormat(timestampformat, symbols);
				}
				else
				{
					timestampFormat = new SimpleDateFormat(timestampformat);
				}
				timestampFormat.setTimeZone(timeZone);
			}
			else
			{
				/*
				 * Parse timestamps using a fixed regular expression.
				 */
				timestampPattern = Pattern
					.compile("([0-9][0-9][0-9][0-9])-([0-9]?[0-9])-([0-9]?[0-9])[ T]([0-9]?[0-9]):([0-9]?[0-9]):([0-9]?[0-9]).*");
			}
		}

		if (locale != null)
		{
			decimalFormatSymbols = new DecimalFormatSymbols(locale);
		}
	}

	private DateTimeFormatter createFormatter(String pattern, Locale locale, String timeZoneName)
	{
		DateTimeFormatter formatter;
		DateTimeFormatterBuilder builder = new DateTimeFormatterBuilder();
		builder.parseCaseInsensitive();
		builder.appendPattern(pattern);
		if (locale != null)
			formatter = builder.toFormatter(locale);
		else
			formatter = builder.toFormatter();
		return formatter.withZone(ZoneId.of(timeZoneName));
	}
	
	public String parseString(String str)
	{
		return str;
	}

	public Boolean parseBoolean(String str)
	{
		Boolean retval;
		if (str != null && str.equals("1"))
			retval = Boolean.TRUE;
		else if (str != null && str.equals("0"))
			retval = Boolean.FALSE;
		else
			retval = Boolean.valueOf(str);
		return retval;
	}

	public Byte parseByte(String str)
	{
		try
		{
			Byte b;
			if (str == null || str.length() == 0)
				b = null;
			else
				b = Byte.valueOf(Byte.parseByte(str));
			return b;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public Short parseShort(String str)
	{
		try
		{
			Short s;
			if (str == null || str.length() == 0)
				s = null;
			else
				s = Short.valueOf(Short.parseShort(str));
			return s;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public Integer parseInt(String str)
	{
		try
		{
			Integer i;
			if (str == null || str.length() == 0)
				i = null;
			else
				i = Integer.valueOf(Integer.parseInt(str));
			return i;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public Long parseLong(String str)
	{
		try
		{
			Long l;
			if (str == null || str.length() == 0)
				l = null;
			else
				l = Long.valueOf(Long.parseLong(str));
			return l;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public Float parseFloat(String str)
	{
		try
		{
			Float f;
			if (str == null || str.length() == 0)
			{
				f = null;
			}
			else
			{
				str = str.replace(",", ".");
				f = Float.valueOf(Float.parseFloat(str));
			}
			return f;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public Double parseDouble(String str)
	{
		try
		{
			Double d;
			if (str == null || str.length() == 0)
			{
				d = null;
			}
			else
			{
				str = str.replace(",", ".");
				d = Double.valueOf(Double.parseDouble(str));
			}
			return d;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	public byte[] parseBytes(String str)
	{
		try
		{
			byte[] b;
			if (str == null)
				b = null;
			else
				b = str.getBytes();
			return b;
		}
		catch (RuntimeException e)
		{
			return null;
		}
	}

	public BigDecimal parseBigDecimal(String str)
	{
		try
		{
			BigDecimal bd;
			if (str == null || str.length() == 0)
				bd = null;
			else
				bd = new BigDecimal(str);
			return bd;
		}
		catch (NumberFormatException e)
		{
			return null;
		}
	}

	/**
	 * transforms the date string into its equivalent ISO8601.
	 * 
	 * @param date date to convert.
	 * @param format format of date.
	 * @return date in ISO8601 format.
	 */
	private String makeISODate(String date, String format)
	{
		// first memorize the original order of the groups.
		format = format.toLowerCase(Locale.US);
		int dpos = format.indexOf('d');
		int mpos = format.indexOf('m');
		int ypos = format.indexOf('y');
		int ylen = 4;

		int day = 1, month = 1, year = 1;
		if (dpos > mpos)
			day += 1;
		else
			month += 1;
		if (dpos > ypos)
			day += 1;
		else
			year += 1;
		if (mpos > ypos)
			month += 1;
		else
			year += 1;

		// then build the regular expression
		Pattern part;
		Matcher m;

		part = Pattern.compile("d+");
		m = part.matcher(format);
		if (m.find())
			format = format.replace(m.group(), "([0-9]{" + (m.end() - m.start()) + ",2})");

		part = Pattern.compile("m+");
		m = part.matcher(format);
		if (m.find())
			format = format.replace(m.group(), "([0-9]{" + (m.end() - m.start()) + ",2})");

		part = Pattern.compile("y+");
		m = part.matcher(format);
		if (m.find())
		{
			ylen = m.end() - m.start();
			format = format.replace(m.group(), "([0-9]{" + (m.end() - m.start()) + ",4})");
		}

		format = format + ".*";

		Pattern pattern = Pattern.compile(format);
		m = pattern.matcher(date);
		if (m.matches())
		{
			// and return the groups in ISO8601 format.
			String yearGroup = m.group(year);
			if (yearGroup.length() == 2 && ylen == 2)
			{
				// Parsed year only contains two digits. Determine full year including
				// century using same logic as java.text.SimpleDateFormat:
				// select century that is less than 20 years in the future and
				// less than 80 years in the past.
				int century = currentYear / 100;
				int proposedYear = (century * 100) + Integer.parseInt(yearGroup);
				if (proposedYear - currentYear > 20)
					proposedYear -= 100;
				if (currentYear - proposedYear > 80)
					proposedYear += 100;
				yearGroup = String.format("%04d", Integer.valueOf(proposedYear));
			}
			String monthGroup = m.group(month);
			if (monthGroup.length() < 2)
				monthGroup = "0" + monthGroup;
			String dayGroup = m.group(day);
			if (dayGroup.length() < 2)
				dayGroup = "0" + dayGroup;
			return yearGroup + "-" + monthGroup + "-" + dayGroup;
		}
		else
		{
			return null;
		}
	}

	public Date parseDate(String str)
	{
		try
		{
			Date sqlResult = null;
			if (str != null && str.length() > 0)
			{
				if (dateFormatter != null)
				{
					LocalDate localDate = LocalDate.parse(str, dateFormatter);
					return Date.valueOf(localDate);
				}
				if (simpleDateFormat != null)
				{
					java.util.Date parsedDate = simpleDateFormat.parse(str);
					long millis = parsedDate.getTime();
					sqlResult = new Date(millis);
					return sqlResult;
				}
				String isoDate = makeISODate(str, dateFormat);
				if (isoDate != null)
					sqlResult = Date.valueOf(isoDate);
			}
			return sqlResult;
		}
		catch (ParseException | RuntimeException e)
		{
			return null;
		}
	}

	/**
	 * Create date string in format accepted by method {@link #parseDate(String) parseDate}.
	 * @param d date to format.
	 * @return formatted date.
	 */
	public String formatDate(Date d)
	{
		String formatted = null;

		if (d != null)
		{
			if (dateFormatter != null)
			{
				formatted = d.toLocalDate().format(dateFormatter);
			}
			else if (simpleDateFormat != null)
			{
				formatted = simpleDateFormat.format(d);
			}
			else
			{
				formatted = dateFormat.toLowerCase(Locale.US);
				Calendar gregorianCalendar = new GregorianCalendar();
				gregorianCalendar.setTime(d);

				// use regular expressions to replace in day, month, year in format string
				Pattern part;
				Matcher m;

				part = Pattern.compile("d+");
				m = part.matcher(formatted);
				if (m.find())
				{
					int patternLength = m.end() - m.start();
					String dayOfMonth = Integer.toString(gregorianCalendar.get(Calendar.DAY_OF_MONTH));
					while (dayOfMonth.length() < patternLength)
						dayOfMonth = "0" + dayOfMonth;
					formatted = formatted.replace(m.group(), dayOfMonth);
				}
				part = Pattern.compile("m+");
				m = part.matcher(formatted);
				if (m.find())
				{
					int patternLength = m.end() - m.start();
					String month = Integer.toString(gregorianCalendar.get(Calendar.MONTH) + 1);
					while (month.length() < patternLength)
						month = "0" + month;
					formatted = formatted.replace(m.group(), month);
				}
				part = Pattern.compile("y+");
				m = part.matcher(formatted);
				if (m.find())
				{
					int patternLength = m.end() - m.start();
					int fullYear = gregorianCalendar.get(Calendar.YEAR);
					if (patternLength == 2)
						fullYear = fullYear % 100;
					String year = Integer.toString(fullYear);
					while (year.length() < patternLength)
						year = "0" + year;
					formatted = formatted.replace(m.group(), year);
				}
			}
		}
		return formatted;
	}

	public Time parseTime(String str)
	{
		try
		{
			Time sqlResult = null;
			if (timeFormatter != null)
			{
				LocalTime localTime = LocalTime.parse(str, timeFormatter);
				sqlResult = Time.valueOf(localTime);
			}
			else
			{
				if (str != null && str.length() > 0)
				{
					str = str.trim();
					while (str.length() < timeFormat.length())
					{
						str = "0" + str;
					} 
					java.util.Date parsedDate = simpleTimeFormat.parse(str);
					long millis = parsedDate.getTime();
					sqlResult = new Time(millis);
				}
			}
			return sqlResult;
		}
		catch (ParseException | RuntimeException e)
		{
			return null;
		}
	}

	/**
	 * Create time string in format accepted by method {@link #parseTime(String) parseTime}.
	 * @param t time to format.
	 * @return formatted time.
	 */
	public String formatTime(Time t)
	{
		String formatted = null;

		if (t != null)
		{
			if (timeFormatter != null)
			{
				formatted = t.toLocalTime().format(timeFormatter);
			}
			else
			{
				formatted = simpleTimeFormat.format(t);
			}
		}
		return formatted;
	}

	public Timestamp parseTimestamp(String str)
	{
		Timestamp result = null;
		try
		{
			if (str != null && str.length() > 0)
			{
				if (timestampFormatter != null)
				{
					ZonedDateTime zonedDateTime = ZonedDateTime.parse(str, timestampFormatter);
					result = Timestamp.from(zonedDateTime.toInstant());
				}
				else if (timestampFormat != null)
				{
					java.util.Date date = timestampFormat.parse(str);
					result = new Timestamp(date.getTime());
				}
				else
				{
					Matcher matcher = timestampPattern.matcher(str);
					if (matcher.matches())
					{
						int year = Integer.parseInt(matcher.group(1));
						int month = Integer.parseInt(matcher.group(2)) - 1;
						int date = Integer.parseInt(matcher.group(3));
						int hours = Integer.parseInt(matcher.group(4));
						int minutes = Integer.parseInt(matcher.group(5));
						int seconds = Integer.parseInt(matcher.group(6));
						calendar.set(year, month, date, hours, minutes, seconds);
						result = new Timestamp(calendar.getTimeInMillis());
					}
				}
			}
		}
		catch (RuntimeException | ParseException e)
		{
		}
		return result;
	}

	/**
	 * Create timestamp string in format accepted by method {@link #parseTimestamp(String) parseTimestamp}.
	 * @param timestamp timestamp to format.
	 * @return formatted timestamp.
	 */
	public String formatTimestamp(Timestamp timestamp)
	{
		String formatted = null;

		if (timestamp != null)
		{
			if (timestampFormatter != null)
			{
				LocalDateTime localDateTime = LocalDateTime.ofInstant(timestamp.toInstant(), timestampFormatter.getZone());
				formatted = localDateTime.format(timestampFormatter);
			}
			else if (timestampFormat != null)
			{
				formatted = timestampFormat.format(timestamp);
			}
			else
			{
				calendar.setTime(timestamp);
				int year = calendar.get(Calendar.YEAR);
				int month = calendar.get(Calendar.MONTH) + 1;
				int dayOfMonth = calendar.get(Calendar.DAY_OF_MONTH);
				int hourOfDay = calendar.get(Calendar.HOUR_OF_DAY);
				int minutes = calendar.get(Calendar.MINUTE);
				int seconds = calendar.get(Calendar.SECOND);
				formatted = String.format("%04d-%02d-%02d %02d:%02d:%02d",
					Integer.valueOf(year),
					Integer.valueOf(month),
					Integer.valueOf(dayOfMonth),
					Integer.valueOf(hourOfDay),
					Integer.valueOf(minutes),
					Integer.valueOf(seconds));
			}
		}
		return formatted;
	}

	public InputStream parseAsciiStream(String str)
	{
		return (str == null) ? null : new ByteArrayInputStream(str.getBytes());
	}

	static private Map> forSQLNameMap = new HashMap>()
	{
		private static final long serialVersionUID = -3037117163532338893L;
		{
			/*
			 * Lookup from SQL type names to java class.
			 */
			put("string", java.lang.String.class);
			put("boolean", java.lang.Boolean.class);
			put("byte", java.lang.Byte.class);
			put("short", java.lang.Short.class);
			put("int", java.lang.Integer.class);
			put("integer", java.lang.Integer.class);
			put("long", java.lang.Long.class);
			put("float", java.lang.Float.class);
			put("double", java.lang.Double.class);
			put("bigdecimal", java.math.BigDecimal.class);
			put("date", java.sql.Date.class);
			put("time", java.sql.Time.class);
			put("timestamp", java.sql.Timestamp.class);
			put("asciistream", java.io.InputStream.class);
		}
	};

	public Object convert(String sqlTypeName, String stringRepresentation)
	{
		/*
		 * No need to do a conversion if desired type is also a string.
		 */
		if (sqlTypeName == null)
			return stringRepresentation;
		else if (sqlTypeName.equalsIgnoreCase("string"))
			return stringRepresentation;
		else if (sqlTypeName.equalsIgnoreCase("boolean"))
			return parseBoolean(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("byte"))
			return parseByte(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("short"))
			return parseShort(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("int") || sqlTypeName.equalsIgnoreCase("integer"))
			return parseInt(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("long"))
			return parseLong(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("float"))
			return parseFloat(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("double"))
			return parseDouble(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("bigdecimal"))
			return parseBigDecimal(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("date"))
			return parseDate(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("time"))
			return parseTime(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("timestamp"))
			return parseTimestamp(stringRepresentation);
		else if (sqlTypeName.equalsIgnoreCase("asciistream"))
			return parseAsciiStream(stringRepresentation);
		else
			return stringRepresentation;
	}

	public Class forSQLName(String sqlTypeName)
	{
		sqlTypeName = sqlTypeName.toLowerCase(Locale.US);
		return forSQLNameMap.get(sqlTypeName);
	}

	/**
	 * Get a value that has the type of an SQL data type.
	 * 
	 * @param sqlTypeName
	 *            name of SQL data type.
	 * @return a constant value with this data type.
	 */
	public static Object getLiteralForTypeName(String sqlTypeName)
	{
		Object retval = null;
		sqlTypeName = sqlTypeName.toLowerCase(Locale.US);
		if (sqlTypeName.equals("string"))
			retval = "";
		else if (sqlTypeName.equals("boolean"))
			retval = Boolean.FALSE;
		else if (sqlTypeName.equals("byte"))
			retval = Byte.valueOf((byte) 1);
		else if (sqlTypeName.equals("short"))
			retval = Short.valueOf((short) 1);
		else if (sqlTypeName.equals("int") || sqlTypeName.equals("integer"))
			retval = Integer.valueOf(1);
		else if (sqlTypeName.equals("long"))
			retval = Long.valueOf(1);
		else if (sqlTypeName.equals("float"))
			retval = Float.valueOf(1);
		else if (sqlTypeName.equals("double"))
			retval = Double.valueOf(1);
		else if (sqlTypeName.equals("bigdecimal"))
			retval = BigDecimal.valueOf(1);
		else if (sqlTypeName.equals("date"))
			retval = Date.valueOf("1970-01-01");
		else if (sqlTypeName.equals("time"))
			retval = Time.valueOf("00:00:00");
		else if (sqlTypeName.equals("timestamp"))
			retval = Timestamp.valueOf("1970-01-01 00:00:00");
		else if (sqlTypeName.equals("asciistream"))
			retval = new ByteArrayInputStream(new byte[]{});
		return retval;
	}

	/**
	 * Get SQL data type of an object.
	 * 
	 * @param literal
	 *            object to get SQL data type for.
	 * @return SQL data type name.
	 */
	public static String getTypeNameForLiteral(Object literal)
	{
		String retval = null;
		if (literal instanceof String)
			retval = "String";
		else if (literal instanceof Boolean)
			retval = "Boolean";
		else if (literal instanceof Byte)
			retval = "Byte";
		else if (literal instanceof Short)
			retval = "Short";
		else if (literal instanceof Integer)
			retval = "Int";
		else if (literal instanceof Long)
			retval = "Long";
		else if (literal instanceof Float)
			retval = "Float";
		else if (literal instanceof Double)
			retval = "Double";
		else if (literal instanceof BigDecimal)
			retval = "BigDecimal";
		else if (literal instanceof Date)
			retval = "Date";
		else if (literal instanceof Time)
			retval = "Time";
		else if (literal instanceof Timestamp)
			retval = "Timestamp";
		else if (literal instanceof InputStream)
			retval = "AsciiStream";
		else if (literal instanceof Array)
			retval = "Array";
		return retval;
	}

	public static List getTypeInfo()
	{
		Integer intZero = Integer.valueOf(0);
		Short shortZero = Short.valueOf((short) 0);
		Short shortMax = Short.valueOf(Short.MAX_VALUE);
		Short searchable = Short
				.valueOf((short) DatabaseMetaData.typeSearchable);
		Short nullable = Short.valueOf((short) DatabaseMetaData.typeNullable);

		ArrayList retval = new ArrayList<>();

		retval.add(new Object[]
		{ "String", Integer.valueOf(Types.VARCHAR), shortMax, "'", "'", null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Boolean", Integer.valueOf(Types.BOOLEAN), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Byte", Integer.valueOf(Types.TINYINT), shortMax, null, null, null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Short", Integer.valueOf(Types.SMALLINT), shortMax, null, null, null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Integer", Integer.valueOf(Types.INTEGER), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Long", Integer.valueOf(Types.BIGINT), shortMax, null, null, null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Float", Integer.valueOf(Types.FLOAT), shortMax, null, null, null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Double", Integer.valueOf(Types.DOUBLE), shortMax, null, null, null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "BigDecimal", Integer.valueOf(Types.DECIMAL), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Date", Integer.valueOf(Types.DATE), shortMax, "'", "'", null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Time", Integer.valueOf(Types.TIME), shortMax, "'", "'", null,
			nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Timestamp", Integer.valueOf(Types.TIMESTAMP), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Asciistream", Integer.valueOf(Types.CLOB), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		retval.add(new Object[]
		{ "Array", Integer.valueOf(Types.ARRAY), shortMax, null, null,
			null, nullable, Boolean.TRUE, searchable, Boolean.FALSE,
			Boolean.FALSE, Boolean.FALSE, null, shortZero, shortMax,
			intZero, intZero, intZero });

		return retval;
	}

	public static String removeQuotes(String string)
	{
		return string.replace("\"", "");
	}

	public String[] inferColumnTypes(Object[] fieldValues) {
		String[] columnTypes = new String[fieldValues.length];
		for (int i = 0; i < fieldValues.length; i++)
		{
			String typeName = "String";
			String value = fieldValues[i].toString();
			if (value.equalsIgnoreCase("true") || value.equalsIgnoreCase("false"))
			{
				typeName = "Boolean";
			}
			else if (value.equals(("" + parseInt(value))))
			{
				typeName = "Int";
			}
			else if (value.equals(("" + parseLong(value))))
			{
				typeName = "Long";
			}
			else if (value.equals(("" + parseDouble(value))))
			{
				typeName = "Double";
			}
			else if (value.equals(("" + parseBytes(value))))
			{
				typeName = "Bytes";
			}
			else if (value.equals(("" + parseBigDecimal(value))))
			{
				typeName = "BigDecimal";
			}
			else if (parseTimestamp(value) != null)
			{
				typeName = "Timestamp";
			}
			else if (parseDate(value) != null)
			{
				typeName = "Date";
			}
			else if (parseTime(value) != null)
			{
				typeName = "Time";
			}
			else if (value.equals(("" + parseAsciiStream(value))))
			{
				typeName = "AsciiStream";
			}
			columnTypes[i] = typeName;
		}
		return columnTypes;
	}

	/**
	 * Parse number from string using a java.text.DecimalFormat pattern.
	 * @param value string to parse.
	 * @param pattern a java.text.DecimalFormat pattern for parsing string.
	 * @return parsed number, or NULL if complete string cannot be parsed to a number.
	 */
	public Number parseNumberPattern(String value, String pattern)
	{
		Number result;
		ParsePosition pos = new ParsePosition(0);
		if (decimalFormatSymbols != null)
		{
			result = new DecimalFormat(pattern, decimalFormatSymbols).parse(value, pos);
		}
		else
		{
			result = new DecimalFormat(pattern).parse(value, pos);
		}

		// Also fail if we do not parse the whole string.
		if (pos.getIndex() != value.length())
		{
			result = null;
		}

		return result;
	}
}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy