content: /**
   * Copyright (C) 2012 the original author or authors.
   *
   * 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 co.jirm.spring;
  
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.List;
  
  import org.springframework.dao.EmptyResultDataAccessException;
  import org.springframework.jdbc.core.JdbcOperations;
  import org.springframework.jdbc.core.RowMapper;
  
  import co.jirm.core.execute.SqlExecutor;
  import co.jirm.core.execute.SqlSingleValueRowMapper;
  import co.jirm.mapper.SqlObjectConfig;
  import co.jirm.mapper.jdbc.JdbcResultSetRowMapper;
  import co.jirm.mapper.jdbc.JdbcSqlObjectQueryExecutor;
  
  import com.google.common.base.Function;
  import com.google.common.base.Optional;
  import com.google.common.collect.Lists;
  
  
  public class SpringJdbcSqlExecutor extends JdbcSqlObjectQueryExecutor implements SqlExecutor {
  	
  	private final JdbcOperations jdbcTemplate;
  
  	private SpringJdbcSqlExecutor(SqlObjectConfig config, JdbcOperations jdbcTemplate) {
  		super(config);
  		this.jdbcTemplate = jdbcTemplate;
  	}
  	
  	public static SpringJdbcSqlExecutor newInstance(SqlObjectConfig config, JdbcOperations jdbcTemplate) {
  		return new SpringJdbcSqlExecutor(config, jdbcTemplate);
  	}
  
  	@Override
  	protected long doQueryForLong(String sql, Object[] objects) {
  		return jdbcTemplate.queryForLong(sql, objects);
  	}
  
  	@Override
  	protected int doQueryForInt(String sql, Object[] objects) {
  		return jdbcTemplate.queryForInt(sql, objects);
  	}
  
  	@Override
  	protected <T> T doQueryForObject(String sql, final JdbcResultSetRowMapper<T> rowMapper, Object[] objects) {
  		return jdbcTemplate.queryForObject(sql, new RowMapper<T> () {
  			@Override
  			public T mapRow(ResultSet rs, int rowNum) throws SQLException {
  				return rowMapper.mapRow(rs, rowNum);
  			}		
  		}, objects);
  	}
  
  	@Override
  	protected <T> Optional<T> doQueryForOptional(String sql, final JdbcResultSetRowMapper<T> rowMapper, Object[] objects) {
  		try {
  			T object = jdbcTemplate.queryForObject(sql, new RowMapper<T> () {
  				@Override
  				public T mapRow(ResultSet rs, int rowNum) throws SQLException {
  					return rowMapper.mapRow(rs, rowNum);
  				}		
  			}, objects);
  			return Optional.of(object);
  		} catch (EmptyResultDataAccessException e) {
  			return Optional.absent();
  		}
  	}
  
  	@Override
  	protected <T> List<T> doQueryForList(String sql, final JdbcResultSetRowMapper<T> rowMapper, Object[] objects) {
  		return jdbcTemplate.query(sql, objects, new RowMapper<T> () {
  			@Override
  			public T mapRow(ResultSet rs, int rowNum) throws SQLException {
  				return rowMapper.mapRow(rs, rowNum);
  			}		
  		});
  	}
  	
  	
  	@Override
  	protected <T> T doQueryForObject(String sql, SqlSingleValueRowMapper rowMapper, Class<T> type, Object[] objects) {
  		T o = jdbcTemplate.queryForObject(sql, objects, type);
  		return rowMapper.mapRow(type, o, 0);
  	}
  
  	@Override
  	protected <T> Optional<T> doQueryForOptional(String sql, SqlSingleValueRowMapper rowMapper, Class<T> type,
  			Object[] objects) {
  		try {
  			T o = jdbcTemplate.queryForObject(sql, objects, type);
  			return Optional.fromNullable(rowMapper.mapRow(type, o, 0));
  		} catch (EmptyResultDataAccessException e) {
  			return Optional.absent();
  		}
  	}
  
  	@Override
  	protected <T> List<T> doQueryForList(final String sql, final SqlSingleValueRowMapper rowMapper, final Class<T> type, Object[] objects) {
  		List<T> list = jdbcTemplate.queryForList(sql, objects, type);
  		return Lists.transform(list, new Function<T, T>() {
  			int i = 0;
  			public T apply(T input) {
  				return rowMapper.mapRow(type, input, i++); 
  			};
  		});
  	}
  
  	@Override
  	public int[] batchUpdate(String sql, List<Object[]> objects) {
  		for (Object[] os : objects) {
  			nullify(os);
  		}
  		return jdbcTemplate.batchUpdate(sql, objects);
  	}
  
  	@Override
  	public int update(String sql, Object[] objects) {
  		logSql(sql, objects);
  		nullify(objects);
  		return jdbcTemplate.update(sql, objects);
  	}
  
  }
  