public void AddNewlyCreatedObjectHashTypes() { // for new sd_sid / hash type combinations string sql_string = @"INSERT INTO ad.object_hashes(sd_oid, hash_type_id, composite_hash) SELECT ia.sd_oid, ia.hash_type_id, ia.composite_hash FROM sd.to_ad_object_atts ia WHERE ia.status = 1"; dbu.ExecuteSQL(sql_string); _logger.Information("Inserting new object hashtype combinations in object hash records"); }
public void TransferStudyHashes() { for (int n = 11; n < 21; n++) { string sql_string = @"INSERT INTO ad.study_hashes(sd_sid, hash_type_id, composite_hash) SELECT s.sd_sid, hash_type_id, composite_hash FROM sd.study_hashes s INNER JOIN sd.to_ad_study_recs ts ON s.sd_sid = ts.sd_sid where ts.status = 1 and s.hash_type_id = " + n.ToString(); int res = dbu.ExecuteSQL(sql_string); if (res > 0) { _logger.Information("Inserting " + res.ToString() + " new study hashes - type " + n.ToString()); } } }
public void TransferObjectHashes() { for (int n = 50; n < 64; n++) { string sql_string = @"INSERT INTO ad.object_hashes(sd_oid, hash_type_id, composite_hash) SELECT d.sd_oid, hash_type_id, composite_hash FROM sd.object_hashes d INNER JOIN sd.to_ad_object_recs nd ON d.sd_oid = nd.sd_oid WHERE nd.status = 1 and d.hash_type_id = " + n.ToString(); int res = dbu.ExecuteSQL(sql_string); if (res > 0) { _logger.Information("Inserting " + res.ToString() + " new object hashes - type " + n.ToString()); } } }