package eu.dnetlib.data.espas.dataprovider;

import org.apache.log4j.Logger;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created by antleb on 6/25/14.
 */
@Transactional(propagation = Propagation.REQUIRED)
public class DataProviderDao extends AbstractDao {
	private static Logger logger = Logger.getLogger(DataProviderDao.class);

	private static final String GET_CSW = "select url from dataprovider where namespace=?";

	public String getProviderCSWURL(String dataProviderId) throws SQLException {

		logger.debug("looking for csw url of provider with namespace " + dataProviderId);

		Connection con = getConnection();
		PreparedStatement stmt = con.prepareStatement(GET_CSW);
		String cswUrl = null;

		stmt.setString(1, dataProviderId);

		ResultSet rs = stmt.executeQuery();

		if (rs.next()) {
			cswUrl = rs.getString(1);
		}

		stmt.close();

		return cswUrl;
	}
}