static private void cleanDatabase()
{
using (tag_qualityContext db = new tag_qualityContext())
{
db.Database.ExecuteSqlRaw("DROP TABLE IF EXISTS tag_combinations");
db.Database.ExecuteSqlRaw("DROP TABLE IF EXISTS tag_combination_details");
db.Database.ExecuteSqlRaw(@"CREATE TABLE public.tag_combinations
(
id bigint NOT NULL,
tag_id bigint NOT NULL,
country_id bigint NOT NULL,
tag_count bigint,
average_corros_tags double precision,
top_tags text[] COLLATE pg_catalog.""default"",
CONSTRAINT tag_combinations_pkey PRIMARY KEY (id)
)");
db.Database.ExecuteSqlRaw(@"CREATE TABLE public.tag_combination_details
(
id bigint NOT NULL,
tc_id bigint,
tag_key text COLLATE pg_catalog.""default"",
count bigint,
percent double precision,
CONSTRAINT tag_combination_details_pkey PRIMARY KEY(id)
)
");
}
}
//Get All tags from DB, like amenity=cafe, amenity=fast_food, etc.
static public List <TagsKeyValue> getAllTagsFromDB()
{
String get_all_tags = @"select * from tags_key_value";
List <TagsKeyValue> tagsList = new List <TagsKeyValue>();
using (tag_qualityContext db = new tag_qualityContext())
{
tagsList = db.TagsKeyValues
.FromSqlRaw(get_all_tags)
.ToList();
}
return(tagsList);
}
//Get All countries from DB, like Sri Lankya, paraguay, etc.
static public List <Country> getAllCountriesFromDB()
{
String get_all_countries = @"select * from country where status=1";
List <Country> CountryList = new List <Country>();
using (tag_qualityContext db = new tag_qualityContext())
{
CountryList = db.Countries
.FromSqlRaw(get_all_countries)
.ToList();
}
return(CountryList);
}
static private void insertTagCombinationDetailData(TagCombinationDetail tagCombinationDetail)
{
using (tag_qualityContext db = new tag_qualityContext())
{
db.Set <TagCombinationDetail>().Add(tagCombinationDetail);
try
{
int records = db.SaveChanges();
//Console.WriteLine("Saved {0} Tag Combination Detials to DB", records);
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.StackTrace);
Console.WriteLine(e.InnerException);
}
}
}