GetInstant.java

/***************************************************************************
   Copyright 2012 Emily Estes

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
***************************************************************************/
package net.metanotion.sqlc.setters;


import java.sql.ResultSet;
import java.sql.SQLException;

import org.joda.time.format.DateTimeFormatter;
import org.joda.time.format.ISODateTimeFormat;

/** A Result Set "getter" for interpreting a field as a Joda time ReadableInstant. Since JDBC doesn't support this data type
"natively", this class assumes the date/time can be retrieved as a string in ISO 8601 format. */
public final class GetInstant extends RSGetter {
	private static final DateTimeFormatter parser = ISODateTimeFormat.dateOptionalTimeParser().withOffsetParsed();

	/** Create an instance of the getter for a field with the given name.
		@param name The name of the field.
	*/
	public GetInstant(final String name) { super(name, "org.joda.time.ReadableInstant"); }
	@Override public Object get(final ResultSet rs) throws SQLException { return parser.parseDateTime(rs.getString(name)); }
	@Override public Object get(final ResultSet rs, final int col) throws SQLException {
		final String v = rs.getString(col);
		return (v == null ? null : parser.parseDateTime(v));
	}
	@Override public String getStatic(final String rsVar) {
		return "((" + rsVar + ".getString(\"" + name + "\") == null) ? null : " +
			"net.metanotion.util.types.ReadableInstantP.PARSER.parseDateTime(" + rsVar + ".getString(\"" + name + "\")))";
	}
	@Override public String getStatic(final String rsVar, final int col) {
		return "((" + rsVar + ".getString(\"" + col + "\") == null) ? null : " +
			"net.metanotion.util.types.ReadableInstantP.PARSER.parseDateTime(" + rsVar + ".getString(\"" + col + "\")))";
	}
}