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); }