D-Net

package eu.dnetlib.msro.openaireplus.workflows.nodes.claims;

import java.util.List;

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

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Component;

/**

 * Created by Alessia Bardi on 23/06/2017.

 *

 * @author Alessia Bardi

 */

@Component

public class ClaimDatabaseUtils {

	@Autowired

	JdbcTemplate claimsJdbcTemplate;

	public List<ClaimRel> query(String sqlQuery){

		return this.claimsJdbcTemplate.query(sqlQuery,

				(rs, rowNum) -> new ClaimRel().setSemantics(rs.getString("semantics"))

						.setSource(rs.getString("source_id")).setSourceType(rs.getString("source_type"))

						.setTarget(rs.getString("target_id")).setTargetType(rs.getString("target_type")));

	}

}