public void NoDatabaseFile_CreateDatabase_DatabaseShouldBeCreated()
{
if (File.Exists(TEST_SQLITE_FILE_NAME))
{
File.Delete(TEST_SQLITE_FILE_NAME);
}
using (var context = new IsraelHikingDbContext())
{
var list = context.SiteUrls.ToList();
Assert.AreEqual(0, list.Count);
Assert.IsTrue(File.Exists(TEST_SQLITE_FILE_NAME));
}
var id = "42";
using (var context = new IsraelHikingDbContext())
{
context.SiteUrls.Add(new SiteUrl {Id = id});
context.SaveChanges();
}
using (var context = new IsraelHikingDbContext())
{
Assert.AreEqual(1, context.SiteUrls.Count());
}
using (var context = new IsraelHikingDbContext())
{
var siteUrlToUpdate = new SiteUrl {Id = id, Title = "title"};
context.MarkAsModified(siteUrlToUpdate);
context.SaveChanges();
}
using (var context = new IsraelHikingDbContext())
{
Assert.IsNotNull(context.SiteUrls.FirstOrDefault(x => x.Title == "title"));
}
}
public void UpdateDatabase()
{
using (var context = new IsraelHikingDbContext())
{
var list = context.SiteUrls.ToList();
foreach (var siteUrl in list)
{
var dataContainer = JsonConvert.DeserializeObject<DataContainer>(siteUrl.JsonData);
if (dataContainer.routes.Count == 0 && dataContainer.markers.Count == 0)
{
continue;
}
foreach (var routeData in dataContainer.routes)
{
for (int routeSegmentIndex = 0; routeSegmentIndex < routeData.segments.Count; routeSegmentIndex++)
{
var routeSegmentData = routeData.segments[routeSegmentIndex];
if (routeSegmentIndex <= 0)
{
continue;
}
var previousReouteSegment = routeData.segments[routeSegmentIndex - 1];
if (previousReouteSegment.routingType == "None" &&
!previousReouteSegment.latlngzs.Last().Equals(routeSegmentData.latlngzs.First()))
{
routeSegmentData.latlngzs.Insert(0, previousReouteSegment.latlngzs.Last());
}
if (routeSegmentData.routingType == "None" &&
!routeSegmentData.latlngzs.First().Equals(previousReouteSegment.latlngzs.Last()))
{
routeSegmentData.latlngzs[0] = previousReouteSegment.latlngzs.Last();
}
}
}
var jsonData = JsonConvert.SerializeObject(dataContainer, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore });
siteUrl.JsonData = jsonData;
context.MarkAsModified(siteUrl);
}
context.SaveChanges();
}
}