public IEnumerable <ObjectId> FetchObjectIds(int source_id)
{
string conn_string = repo.GetConnString(source_id);
using (var conn = new NpgsqlConnection(conn_string))
{
string sql_string = @"select " + source_id.ToString() + @" as source_id, "
+ source_id.ToString() + @" as parent_study_source_id,
sd_oid, sd_sid as parent_study_sd_sid, datetime_of_data_fetch
from ad.data_objects";
return(conn.Query <ObjectId>(sql_string));
}
}
public IEnumerable <StudyLink> FetchLinks(int source_id, string database_name)
{
string conn_string = repo.GetConnString(database_name);
using (var conn = new NpgsqlConnection(conn_string))
{
string sql_string = @"select " + source_id.ToString() + @" as source_1,
sd_sid as sd_sid_1,
identifier_value as sd_sid_2, identifier_org_id as source_2
from ad.study_identifiers
where identifier_type_id = 11
and identifier_org_id > 100115
and (identifier_org_id < 100133 or identifier_org_id = 101989)
and identifier_org_id <> " + source_id.ToString();
return(conn.Query <StudyLink>(sql_string));
}
}
