/*
    *  Copyright 2014 Christopher Pheby
    *
    *  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 org.jadira.usertype.json.jackson;
  
  import java.io.IOException;
  import java.lang.reflect.InvocationTargetException;
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Types;
  
  import org.hibernate.HibernateException;
  import org.hibernate.engine.spi.SharedSessionContractImplementor;
  import org.postgresql.util.PGobject;
  
  import com.fasterxml.jackson.core.JsonParseException;
  import com.fasterxml.jackson.core.JsonProcessingException;
  import com.fasterxml.jackson.databind.JsonMappingException;
  
  public class PersistentJsonObjectAsPostgreSQLJson<T> extends PersistentJsonObjectAsString<T> {
  
  	private static final long serialVersionUID = 228945479215593795L;
  
  	private static boolean HAS_POSTGRES_DRIVER;
  	
  	static {
  		
  		try {
  		Class.forName("org.postgresql.util.PGobject");
  		HAS_POSTGRES_DRIVER = true;
  		} catch (ClassNotFoundException e) {
  			HAS_POSTGRES_DRIVER = false;
  		}
  	}
  	
      @Override
      public Object doNullSafeGet(ResultSet rs, String[] names, SharedSessionContractImplementor session, Object owner) throws HibernateException, SQLException, IllegalArgumentException, IllegalAccessException, InvocationTargetException {
  
          Object identifier = rs.getObject(names[0]);
          
          if (rs.wasNull()) {
              return null;
          }
  
  		final String jsonText;
  		if (HAS_POSTGRES_DRIVER && identifier instanceof PGobject) {
              PGobject pg = (PGobject) identifier;
              jsonText = pg.getValue();
          } else if (identifier instanceof String) { // some PostgreSQL Dialects / Versions return String not PGObject
              jsonText = (String)identifier;
          } else {
              throw new IllegalArgumentException("PersistentJsonObjectAsPostgreSQLJson type expected PGobject, received " + identifier.getClass().getName() + " with value of '" + identifier + "'");
          }
  		
  		try {
  			Object obj = getObjectReader().readValue(jsonText);
  			return obj;			
  		} catch (JsonParseException e) {
  			throw new HibernateException("Problem parsing retrieved JSON String: " + jsonText, e);
  		} catch (JsonMappingException e) {
  			throw new HibernateException("Problem mapping retrieved JSON String: " + jsonText, e);
  		} catch (IOException e) {
  			throw new HibernateException("Problem reading JSON String: " + jsonText, e);
  		}
      }
  
      @Override
      public void doNullSafeSet(PreparedStatement preparedStatement, Object value, int index, SharedSessionContractImplementor session) throws SQLException, IllegalArgumentException, IllegalAccessException, InvocationTargetException {
  
      	if (value == null) {
  			preparedStatement.setNull(index, Types.NULL);
  		} else {				
  			
  			try {
  				String identifier = getObjectWriter().writeValueAsString(value);
  				
  				Object jsonObject;
  				if (HAS_POSTGRES_DRIVER) {
  				
  		        	PGobject pgObject = new PGobject();
  		        	pgObject.setType("json");
  		        	pgObject.setValue(identifier);
  		        	jsonObject = pgObject;
  				} else {
  					jsonObject = identifier;
  				}
 				
 	            preparedStatement.setObject(index, jsonObject);
 			} catch (JsonProcessingException e) {
 				throw new HibernateException("Problem writing JSON String: " + e.getMessage(), e);
 			}
 		}
     }
 }