package eu.dnetlib.enabling.database.utils;

import java.sql.Array;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.springframework.jdbc.support.SqlValue;

public class SqlTextArrayValue implements SqlValue {

	private final String[] items;

	public SqlTextArrayValue(final String... items) {
		this.items = items;
	}

	@Override
	public void setValue(final PreparedStatement ps, final int paramIndex) throws SQLException {
		final Array arrayValue = ps.getConnection().createArrayOf("TEXT", items);
		ps.setArray(paramIndex, arrayValue);
	}

	@Override
	public void cleanup() {}

}