static private TagCombination createTctDataToInsert(long id, long tagId, long countryId, long tagCount, double average, String[] topNtags)
{
TagCombination tagCombination = new TagCombination();
tagCombination.Id = id;
tagCombination.TagId = tagId;
tagCombination.CountryId = countryId;
tagCombination.TagCount = tagCount;
tagCombination.AverageCorrosTags = average;
tagCombination.TopTags = topNtags;
return(tagCombination);
}
static public void checkDbRawQuery()
{
cleanDatabase();
String tag_counts = "";
long TC_ID = 1;
long TCD_ID = 1;
List <Country> countries = getAllCountriesFromDB();
foreach (Country country in countries)
{
Console.WriteLine("COUNTRY : " + country.Name);
List <TagsKeyValue> tagsList = getAllTagsFromDB();
Console.WriteLine("Length of tags " + tagsList.Count);
foreach (TagsKeyValue tag in tagsList)
{
String tag_key = tag.Key;
String tag_value = tag.Value;
Console.WriteLine("Key : " + tag_key + " and Value: " + tag_value);
long tagTotalCount = getTagCount(country.Db, tag_key, tag_value);
if (tagTotalCount == -1)
{
Console.WriteLine("ERROR. ABORT");
//Break, there is something wrong.
}
tag_counts = tagTotalCount.ToString();
List <TagAggregation> listOfTags = getAllTagsRespectively(country.Db, tag_key, tag_value, tag_counts);
Console.WriteLine("List Size " + listOfTags.Count);
Double average = getAverageNumberOfTags(country.Db, tag_key, tag_value);
List <String> topNtags = new List <string>();
int temp = 0;
foreach (TagAggregation tagAggregation in listOfTags)
{
topNtags.Add(tagAggregation.tag);
}
TagCombination tagCombination = createTctDataToInsert(TC_ID, tag.Id, country.Id, tagTotalCount, average, topNtags.ToArray());
insertTagCombinationData(tagCombination);
foreach (TagAggregation tags in listOfTags)
{
TagCombinationDetail tagCombinationDetail = createTcdtDataToInsert(TCD_ID, TC_ID, tags.tag, tags.count, Math.Round(tags.percent, 2));
insertTagCombinationDetailData(tagCombinationDetail);
TCD_ID++;
}
TC_ID++;
}
}
}
static private void insertTagCombinationData(TagCombination tagCombination)
{
using (tag_qualityContext db = new tag_qualityContext())
{
db.Set <TagCombination>().Add(tagCombination);
try
{
int records = db.SaveChanges();
Console.WriteLine("Saved {0} Tag Combination to DB", records);
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.StackTrace);
Console.WriteLine(e.InnerException);
}
}
}
