public int LoadStudies(string schema_name)
{
// Insert the study data unless it is already in under another
// id (i.e. t.is_preferred = false).
string sql_string = @"INSERT INTO st.studies(id,
display_title, title_lang_code, brief_description, bd_contains_html,
data_sharing_statement, dss_contains_html,
study_start_year, study_start_month, study_type_id, study_status_id,
study_enrolment, study_gender_elig_id, min_age, min_age_units_id,
max_age, max_age_units_id)
SELECT t.study_id,
s.display_title, s.title_lang_code, s.brief_description, s.bd_contains_html,
s.data_sharing_statement, s.dss_contains_html,
s.study_start_year, s.study_start_month, s.study_type_id, s.study_status_id,
s.study_enrolment, s.study_gender_elig_id, s.min_age, s.min_age_units_id,
s.max_age, s.max_age_units_id
FROM nk.temp_study_ids t
INNER JOIN " + schema_name + @".studies s
on t.sd_sid = s.sd_sid
WHERE t.is_preferred = true ";
int res = db.ExecuteTransferSQL(sql_string, schema_name, "studies", "new studies");
logging_repo.LogLine("Loaded records - " + res.ToString() + " studies, new studies");
// Note that the statement below also updates studies that are not added as new
// (because they equate to existing studies) but which were new in the
// source data.
db.Update_SourceTable_ExportDate(schema_name, "studies");
return(res);
}
public int LoadDataObjects(string schema_name)
{
string sql_string = @"INSERT INTO ob.data_objects(id,
display_title, version, doi, doi_status_id, publication_year,
object_class_id, object_type_id, managing_org_id, managing_org,
lang_code, access_type_id, access_details, access_details_url,
url_last_checked, eosc_category, add_study_contribs,
add_study_topics)
SELECT t.object_id,
s.display_title, s.version, s.doi, s.doi_status_id, s.publication_year,
s.object_class_id, s.object_type_id, s.managing_org_id, s.managing_org,
s.lang_code, s.access_type_id, s.access_details, s.access_details_url,
s.url_last_checked, s.eosc_category, s.add_study_contribs,
s.add_study_topics
FROM " + schema_name + @".data_objects s
INNER JOIN nk.temp_objects_to_add t
on s.sd_oid = t.sd_oid ";
int res = db.ExecuteTransferSQL(sql_string, schema_name, "data_objects", "");
logging_repo.LogLine("Loaded records - " + res.ToString() + " data_objects");
db.Update_SourceTable_ExportDate(schema_name, "data_objects");
return(res);
}
