GetJsonObject.java

/***************************************************************************
   Copyright 2015 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.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;

import net.metanotion.json.JsonObject;

/** 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 GetJsonObject extends RSGetter {
	/** Create an instance of the getter for a field with the given name.
		@param name The name of the field.
	*/
	public GetJsonObject(final String name) { super(name, "net.metanotion.json.JsonObject"); }
	@Override public Object get(final ResultSet rs) throws SQLException {
		try {
			return JsonObject.read(rs.getString(name));
		} catch (final IOException ioe) { throw new RuntimeException(ioe); }
	}

	@Override public Object get(final ResultSet rs, final int col) throws SQLException {
		try {
			final String v = rs.getString(col);
			return JsonObject.read(v);
		} catch (final IOException ioe) { throw new RuntimeException(ioe); }
	}

	@Override public String getStatic(final String rsVar) {
		return "((" + rsVar + ".getString(\"" + name + "\") == null) ? null : " +
			"net.metanotion.json.JsonObject.read(" + rsVar + ".getString(\"" + name + "\")))";
	}

	@Override public String getStatic(final String rsVar, final int col) {
		return "((" + rsVar + ".getString(\"" + col + "\") == null) ? null : " +
			"net.metanotion.json.JsonObject.read(" + rsVar + ".getString(\"" + col + "\")))";
	}
}