nl.topicus.jdbc.util.CloudSpannerConversionUtil Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of spanner-jdbc Show documentation
JDBC Driver for Google Cloud Spanner
There is a newer version: 1.1.6
package nl.topicus.jdbc.util;

import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import java.util.concurrent.TimeUnit;

import nl.topicus.jdbc.shaded.com.google.cloud.ByteArray;

public class CloudSpannerConversionUtil
{
	private CloudSpannerConversionUtil()
	{
	}

	public static Date toSqlDate(nl.topicus.jdbc.shaded.com.google.cloud.Date date)
	{
		return toSqlDate(date, Calendar.getInstance());
	}

	public static Date toSqlDate(nl.topicus.jdbc.shaded.com.google.cloud.Date date, Calendar cal)
	{
		cal.set(date.getYear(), date.getMonth() - 1, date.getDayOfMonth(), 0, 0, 0);
		cal.clear(Calendar.MILLISECOND);
		return new Date(cal.getTimeInMillis());
	}

	public static nl.topicus.jdbc.shaded.com.google.cloud.Date toCloudSpannerDate(Date date)
	{
		@SuppressWarnings("deprecation")
		nl.topicus.jdbc.shaded.com.google.cloud.Date res = nl.topicus.jdbc.shaded.com.google.cloud.Date.fromYearMonthDay(date.getYear() + 1900, date.getMonth() + 1,
				date.getDate());
		return res;
	}

	public static List toCloudSpannerDates(Date[] dates)
	{
		List res = new ArrayList<>(dates.length);
		for (int index = 0; index < dates.length; index++)
			res.add(toCloudSpannerDate(dates[index]));
		return res;
	}

	public static List toJavaDates(List dates)
	{
		List res = new ArrayList<>(dates.size());
		for (nl.topicus.jdbc.shaded.com.google.cloud.Date date : dates)
			res.add(CloudSpannerConversionUtil.toSqlDate(date));
		return res;
	}

	public static nl.topicus.jdbc.shaded.com.google.cloud.Timestamp toCloudSpannerTimestamp(Timestamp ts)
	{
		long milliseconds = ts.getTime();
		long seconds = milliseconds / 1000l;
		int nanos = ts.getNanos();
		nl.topicus.jdbc.shaded.com.google.cloud.Timestamp res = nl.topicus.jdbc.shaded.com.google.cloud.Timestamp.ofTimeSecondsAndNanos(seconds, nanos);
		return res;
	}

	public static List toCloudSpannerTimestamps(Timestamp[] timestamps)
	{
		List res = new ArrayList<>(timestamps.length);
		for (int index = 0; index < timestamps.length; index++)
			res.add(toCloudSpannerTimestamp(timestamps[index]));
		return res;
	}

	public static Time toSqlTime(nl.topicus.jdbc.shaded.com.google.cloud.Timestamp ts)
	{
		return toSqlTime(ts, Calendar.getInstance());
	}

	public static Time toSqlTime(nl.topicus.jdbc.shaded.com.google.cloud.Timestamp ts, Calendar cal)
	{
		cal.set(1970, 0, 1, 0, 0, 0);
		cal.clear(Calendar.MILLISECOND);
		cal.setTimeInMillis(
				ts.getSeconds() * 1000 + TimeUnit.MILLISECONDS.convert(ts.getNanos(), TimeUnit.NANOSECONDS));
		return new Time(cal.getTimeInMillis());
	}

	public static List toJavaTimestamps(List timestamps)
	{
		List res = new ArrayList<>(timestamps.size());
		for (nl.topicus.jdbc.shaded.com.google.cloud.Timestamp timestamp : timestamps)
			res.add(timestamp.toSqlTimestamp());
		return res;
	}

	public static List toCloudSpannerBytes(byte[][] bytes)
	{
		List res = new ArrayList<>(bytes.length);
		for (int index = 0; index < bytes.length; index++)
			res.add(ByteArray.copyFrom(bytes[index]));
		return res;
	}

	public static List toJavaByteArrays(List bytes)
	{
		List res = new ArrayList<>(bytes.size());
		for (ByteArray ba : bytes)
			res.add(ba.toByteArray());
		return res;
	}

}