com.sap.cds.jdbc.sqlite.SqliteBinder Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of cds4j-runtime Show documentation
CDS QL Execution Engine
There is a newer version: 3.4.0
/************************************************************************
 * © 2021-2022 SAP SE or an SAP affiliate company. All rights reserved. *
 ************************************************************************/
package com.sap.cds.jdbc.sqlite;

import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.Reader;
import java.io.StringReader;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.Instant;
import java.time.LocalDate;
import java.time.LocalTime;
import java.util.Objects;
import java.util.TimeZone;
import java.util.function.Function;

import com.google.common.io.ByteStreams;
import com.google.common.io.CharStreams;
import com.sap.cds.CdsException;
import com.sap.cds.jdbc.generic.AbstractValueBinder;
import com.sap.cds.util.CdsTypeUtils;

// package private
class SqliteBinder extends AbstractValueBinder {

// package private
	SqliteBinder(TimeZone timeZone) {
		super(7, timeZone);
	}

	@Override
	protected Instant getInstant(ResultSet result, int i) throws SQLException {
		String txt = result.getString(i);
		if (txt == null) {
			return null;
		}
		return CdsTypeUtils.parseInstant(txt);
	}

	@Override
	protected void setInstant(PreparedStatement pstmt, int i, Instant instant) throws SQLException {
		/*
		 * We can't use the pstmt.setTimestamp() method as this would store a timestamp
		 * as an SQL timestamp (ISO/IEC 9075: 'YYYY-MM-DD hh:mm:ss'). Unfortunately, CAP
		 * Node.js decided to store timestamp in ISO 8601 ('YYYY-MM-DDThh:mm:ssZ'). For
		 * interoperability with CAP Node.js, we decided to store timestamps also in ISO
		 * 8601.
		 */
		pstmt.setString(i, Objects.toString(instant, null));
	}

	@Override
	protected LocalDate getLocalDate(ResultSet result, int i) throws SQLException {
		return getAndParse(result, i, LocalDate::parse);
	}

	@Override
	protected void setLocalDate(PreparedStatement pstmt, int i, LocalDate localDate) throws SQLException {
		pstmt.setString(i, Objects.toString(localDate, null));
	}

	@Override
	protected LocalTime getLocalTime(ResultSet result, int i) throws SQLException {
		return getAndParse(result, i, LocalTime::parse);
	}

	private  T getAndParse(ResultSet result, int i, Function parser) throws SQLException {
		String txt = result.getString(i);
		return txt == null ? null : parser.apply(txt);
	}

	@Override
	protected void setLocalTime(PreparedStatement pstmt, int i, LocalTime localTime) throws SQLException {
		pstmt.setString(i, Objects.toString(localTime, null));
	}

	@Override
	protected Reader getLargeString(ResultSet result, int i) throws SQLException {
		String string = result.getString(i);
		return null == string ? null : new StringReader(string);
	}

	@Override
	protected void setLargeString(PreparedStatement pstmt, int i, Reader reader) throws SQLException {
		try {
			pstmt.setString(i, CharStreams.toString(reader));
		} catch (IOException e) {
			throw new CdsException("Unable to convert Readable to a String", e);
		}
	}

	@Override
	protected InputStream getLargeBinary(ResultSet result, int i) throws SQLException {
		byte[] bytes = result.getBytes(i);
		return null == bytes ? null : new ByteArrayInputStream(bytes);
	}

	@Override
	protected void setLargeBinary(PreparedStatement pstmt, int i, InputStream stream) throws SQLException {
		try {
			pstmt.setBytes(i, ByteStreams.toByteArray(stream));
		} catch (IOException e) {
			throw new CdsException("Unable to convert InputStream to a byte array", e);
		}
	}
}