D-Net

package eu.dnetlib.goldoa.service;

import eu.dnetlib.goldoa.domain.Funder;

import eu.dnetlib.goldoa.domain.Vocabulary;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.dao.EmptyResultDataAccessException;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import javax.sql.DataSource;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Types;

import java.util.List;

/**

 * Created by antleb on 5/6/15.

 */

public class FunderManagerImpl implements FunderManager {

    @Autowired

    private DataSource dataSource;

    private final static String SEARCH_FUNDERS = "select id, name from funder where lower(name) like ?";

    private final static String GET_FUNDER = "select id, name, url, source from funder where id=?";

    @Override

    public List<Vocabulary> search(String term) {

        return new JdbcTemplate(dataSource).query(SEARCH_FUNDERS,  new String[]{"%" + term + "%"}, new int[]{Types.VARCHAR}, new RowMapper<Vocabulary>() {

            @Override

            public Vocabulary mapRow(ResultSet rs, int rowNum) throws SQLException {

                return new Vocabulary(rs.getString("id"), rs.getString("name"));

            }

        });

    }

    @Override

    public Funder getById(String id) {

        try {

            return new JdbcTemplate(dataSource).queryForObject(GET_FUNDER, new String[]{id}, new int[]{Types.VARCHAR}, new RowMapper<Funder>() {

                @Override

                public Funder mapRow(ResultSet rs, int rowNum) throws SQLException {

                    return new Funder(rs.getString("id"), rs.getString("name"), rs.getString("url"), rs.getString("source"));

                }

            });

        } catch (EmptyResultDataAccessException e) {

            return null;

        }

    }

}