public void Init()
{
pathToDb = Path.Combine(OutputPath, "chunks.sqlite");
pathToDbUpdate = Path.Combine(OutputPath, "chunks-update.sqlite");
pathToDbBackup = Path.Combine(OutputPath, "chunks-backup.sqlite");
pathToMapUpdate = Path.Combine(OutputPath, "update", "dim" + Dimension + (string.IsNullOrEmpty(Profile) ? "" : $"_{Profile}"));
pathToMap = Path.Combine(OutputPath, "map", "dim" + Dimension + (string.IsNullOrEmpty(Profile) ? "" : $"_{Profile}"));
isUpdate = File.Exists(pathToDb);
NewInitialZoomLevel = 20;
NewLastZoomLevel = NewInitialZoomLevel - InitialZoomLevel;
if (isUpdate)
{
Console.WriteLine("Found chunks.sqlite, this must be an update of the map");
if (File.Exists(pathToDbUpdate))
{
Console.WriteLine($"Deleting {pathToDbUpdate} old update database file");
File.Delete(pathToDbUpdate);
File.Delete(pathToDbUpdate + "-wal");
File.Delete(pathToDbUpdate + "-shm");
}
File.Copy(pathToDb, pathToDbUpdate);
if (Directory.Exists(pathToMapUpdate) && DeleteExistingUpdateFolder)
{
Console.WriteLine("Deleting old update in {0}", pathToMapUpdate);
DirectoryInfo di = new DirectoryInfo(pathToMapUpdate);
var files = di.EnumerateFiles("*.*", SearchOption.AllDirectories);
var fileInfos = files.ToList();
if (fileInfos.Any(x => x.Extension != "." + FileFormat))
{
Console.WriteLine("Can not delete the update folder, because there are files in it not generated by PapyrusCs");
foreach (var f in fileInfos.Where(x => x.Extension != "." + FileFormat))
{
Console.WriteLine("Unknown file {0}", f.FullName);
}
throw new InvalidOperationException("Can not delete the update folder, because there are files in it not generated by PapyrusCs");
}
foreach (var f in fileInfos)
{
Console.WriteLine("Deleting update file {0}", f.FullName);
f.Delete();
}
}
}
var c = new DbCreator();
db = c.CreateDbContext(pathToDbUpdate, true);
db.Database.Migrate();
var settings = db.Settings.FirstOrDefault(x => x.Dimension == Dimension && x.Profile == Profile);
if (settings != null)
{
this.FileFormat = settings.Format;
this.FileQuality = settings.Quality;
this.ChunksPerDimension = settings.ChunksPerDimension;
Console.WriteLine("Overriding settings with: Format {0}, Quality {1} ChunksPerDimension {2}", FileFormat, FileQuality, ChunksPerDimension);
settings.MaxZoom = NewInitialZoomLevel;
settings.MinZoom = NewLastZoomLevel;
Console.WriteLine("Setting Zoom levels to {0} down to {1}", NewInitialZoomLevel, NewLastZoomLevel);
db.SaveChanges();
}
else
{
settings = new Settings()
{
Dimension = Dimension,
Profile = Profile,
Quality = FileQuality,
Format = FileFormat,
MaxZoom = this.NewInitialZoomLevel,
MinZoom = this.NewLastZoomLevel,
ChunksPerDimension = db.Settings.FirstOrDefault()?.ChunksPerDimension ?? this.ChunksPerDimension
};
db.Add(settings);
db.SaveChanges();
}
renderedSubchunks = db.Checksums.Where(x => x.Profile == Profile).ToImmutableDictionary(
x => new LevelDbWorldKey2(x.LevelDbKey), x => new KeyAndCrc(x.Id, x.Crc32));
Console.WriteLine($"Found {renderedSubchunks.Count} subchunks which are already rendered");
}
public static void SeedData(PapyrusContext context)
{
Category bookCategory = new Category();
Category stationeryEquipmentCategory = new Category();
if (!context.Categories.Any())
{
bookCategory.Name = "Book";
bookCategory.Description = "Nunc in venenatis augue. Maecenas nec mauris rhoncus, sagittis orci in, posuere nisi. Cras ut mauris neque. Morbi rhoncus ipsum purus, quis gravida justo euismod eget. Ut viverra congue ante a consequat. Quisque ac nibh neque. Cras id orci placerat, vehicula turpis eget, malesuada orci. Suspendisse pretium mauris vel elit mollis bibendum. Mauris rutrum tellus eget imperdiet dignissim. Donec quis lacus venenatis, egestas lorem id, feugiat nisi. Nulla fringilla mi egestas arcu pretium bibendum.";
stationeryEquipmentCategory.Name = "Stationery Equipment";
stationeryEquipmentCategory.Description = "Suspendisse tincidunt nunc id dictum convallis. Sed eget nunc sem. Morbi rutrum interdum bibendum. Donec quis risus est. Integer euismod nibh neque, ut tempus nisl viverra ac. Phasellus sollicitudin et ex quis convallis. Suspendisse vel dolor vitae ligula dapibus sollicitudin ut eget nunc. Integer hendrerit accumsan massa nec porta. Mauris tempus eget nisl in malesuada.";
context.Add(bookCategory);
context.Add(stationeryEquipmentCategory);
context.SaveChanges();
}
if (!context.Properties.Any())
{
Property authorProperty = new Property
{
Name = "Author",
CategoryId = bookCategory.Id,
PropertyType = PropertyType.String,
};
context.Add(authorProperty);
Property translatorProperty = new Property
{
Name = "Translator",
CategoryId = bookCategory.Id,
PropertyType = PropertyType.Numeric,
};
context.Add(translatorProperty);
Property isbnProperty = new Property
{
Name = "ISBN",
CategoryId = bookCategory.Id,
PropertyType = PropertyType.DateTime,
};
context.Add(isbnProperty);
Property totalPageProperty = new Property
{
Name = "Total Page",
CategoryId = bookCategory.Id,
PropertyType = PropertyType.Numeric,
};
context.Add(totalPageProperty);
Property colorProperty = new Property
{
Name = "Color",
CategoryId = stationeryEquipmentCategory.Id,
PropertyType = PropertyType.String,
};
context.Add(colorProperty);
Property brand = new Property
{
Name = "Brand",
CategoryId = stationeryEquipmentCategory.Id,
PropertyType = PropertyType.String,
};
context.Add(brand);
context.SaveChanges();
}
Ad badBlood = new Ad();
Ad blueOceanShift = new Ad();
Ad outliers = new Ad();
Ad purpleCow = new Ad();
Ad sapiens = new Ad();
if (!context.Ads.Any())
{
badBlood.MemberId = new Guid("cd74470c-4ce7-4817-bce6-ff9c31d36cf4");
badBlood.CategoryId = bookCategory.Id;
badBlood.Title = "Bad Blood Book";
badBlood.Description = "Cras lorem ligula, iaculis nec fermentum eu, vulputate eget sem. Nullam nunc dolor, facilisis eu vulputate nec, elementum dictum sem. Cras at augue turpis. Pellentesque malesuada accumsan arcu vitae convallis. Nunc sapien nunc, facilisis vel enim at, pharetra tincidunt orci. Aliquam et nisl mauris. Cras et elit erat. ";
context.Ads.Add(badBlood);
blueOceanShift.MemberId = new Guid("cd74470c-4ce7-4817-bce6-ff9c31d36cf4");
blueOceanShift.CategoryId = bookCategory.Id;
blueOceanShift.Title = "New Blue Ocean Shift Book";
blueOceanShift.Description = "Vestibulum vestibulum mi orci, at dignissim ligula consequat et. Aliquam ut ipsum aliquet, luctus urna sed, ultrices justo. Curabitur vel orci et turpis rhoncus blandit a sit amet tellus. Curabitur eleifend vulputate accumsan. Nullam nec justo risus. Pellentesque quis molestie lacus. Nunc vitae convallis leo, eu aliquam sapien. Nunc consequat ligula leo, ac interdum enim rutrum at. Pellentesque nec sem scelerisque velit cursus blandit ac vitae ipsum.";
context.Ads.Add(blueOceanShift);
outliers.MemberId = new Guid("cd74470c-4ce7-4817-bce6-ff9c31d36cf4");
outliers.CategoryId = bookCategory.Id;
outliers.Title = "Free Outliers";
outliers.Description = "Aenean at neque ultrices, lacinia ligula in, laoreet purus. Nulla lacinia sagittis arcu a sollicitudin. Fusce rutrum sem libero. Vestibulum in diam in libero dapibus consequat. Pellentesque iaculis iaculis sem vitae eleifend. Mauris vel suscipit justo. In a dapibus ex, in tincidunt sem.";
context.Ads.Add(outliers);
purpleCow.MemberId = new Guid("cd74470c-4ce7-4817-bce6-ff9c31d36cf4");
purpleCow.CategoryId = bookCategory.Id;
purpleCow.Title = "Purple Cow";
purpleCow.Description = "Vestibulum vestibulum mi orci, at dignissim ligula consequat et. Aliquam ut ipsum aliquet, luctus urna sed, ultrices justo. Curabitur vel orci et turpis rhoncus blandit a sit amet tellus. Curabitur eleifend vulputate accumsan. Nullam nec justo risus.";
context.Ads.Add(purpleCow);
sapiens.MemberId = new Guid("cd74470c-4ce7-4817-bce6-ff9c31d36cf4");
sapiens.CategoryId = bookCategory.Id;
sapiens.Title = "Sapiens";
sapiens.Description = "Cras lorem ligula, iaculis nec fermentum eu, vulputate eget sem. Nullam nunc dolor, facilisis eu vulputate nec, elementum dictum sem. Cras at augue turpis. Pellentesque malesuada accumsan arcu vitae convallis. Nunc sapien nunc, facilisis vel enim at, pharetra tincidunt orci.";
context.Ads.Add(sapiens);
context.SaveChanges();
}
Product badBloodBook = new Product();
Product purpleCowBook = new Product();
Product blueOceanShiftBook = new Product();
Product outliersBook = new Product();
Product sapiensBook = new Product();
if (!context.Products.Any())
{
purpleCowBook.AdId = purpleCow.Id;
purpleCowBook.Name = "Purple Cow Book";
context.Products.Add(purpleCowBook);
badBloodBook.AdId = badBlood.Id;
badBloodBook.Name = "Bad Blood Book";
context.Products.Add(badBloodBook);
blueOceanShiftBook.AdId = blueOceanShift.Id;
blueOceanShiftBook.Name = "Blue Ocean Shift Book";
context.Products.Add(blueOceanShiftBook);
outliersBook.AdId = outliers.Id;
outliersBook.Name = "Outliers Book";
context.Products.Add(outliersBook);
sapiensBook.AdId = sapiens.Id;
sapiensBook.Name = "Sapiens Book";
context.Products.Add(sapiensBook);
context.SaveChanges();
}
}
