// we initialize every repository and load data from database
public void Initialize()
{
using (var entities = new ExplorerEntities())
{
foreach (var repository in repositories.Values)
{
repository.Initialize(entities);
}
}
}
public static void WipeDatabase()
{
using (var context = new ExplorerEntities())
{
var objectContext = ((IObjectContextAdapter)context).ObjectContext;
foreach (var tableName in objectContext.MetadataWorkspace.GetEntityContainer(objectContext.DefaultContainerName, DataSpace.CSpace).BaseEntitySets)
{
context.Database.ExecuteSqlCommand($"TRUNCATE {tableName.Name}");
}
context.SaveChanges();
}
}
protected override void Populate(RepositoryManager repositories, ExplorerEntities entities)
{
// get transformed data
foreach (var entity in Data)
{
repository.CreateOrUpdate(entities, entity);
}
var heights = repositories.GetRepository <TableLedgerHeightRepository>();
var heightTable = new TableLedgerHeight(repository.TableName, height);
heights.CreateOrUpdate(entities, heightTable);
logger.Log($"{repository.TableName}: {Data.Count()}, Height: {height}");
}
public void Save(RepositoryManager repositories)
{
using (var entities = new ExplorerEntities())
{
using (new PerformanceLogger(logger, "PopulateEntitiesLogger"))
{
// TODO this is slow
Populate(repositories, entities);
}
using (new PerformanceLogger(logger, "SaveDatabaseLogger"))
{
entities.SaveChanges();
}
}
OnSaveFinished();
}
protected override DbSet <block> GetDbSet(ExplorerEntities entities)
{
return(entities.blocks);
}
protected override DbSet <multisignaturesigner> GetDbSet(ExplorerEntities entities)
{
return(entities.multisignaturesigners);
}
protected override DbSet <declaration> GetDbSet(ExplorerEntities entities)
{
return(entities.declarations);
}
protected override DbSet <transactioninputoutput> GetDbSet(ExplorerEntities entities)
{
return(entities.transactioninputoutputs);
}
public abstract void Initialize(ExplorerEntities entities);
protected override DbSet <account> GetDbSet(ExplorerEntities entities)
{
return(entities.accounts);
}
protected override DbSet <transactionmessage> GetDbSet(ExplorerEntities entities)
{
return(entities.transactionmessages);
}
protected abstract void Populate(RepositoryManager repositories, ExplorerEntities entities);
protected override DbSet <balance> GetDbSet(ExplorerEntities entities)
{
return(entities.balances);
}
protected override DbSet <secretrevelation> GetDbSet(ExplorerEntities entities)
{
return(entities.secretrevelations);
}
protected override DbSet <tableledgerheight> GetDbSet(ExplorerEntities entities)
{
return(entities.tableledgerheights);
}
protected override DbSet <vendingmachine> GetDbSet(ExplorerEntities entities)
{
return(entities.vendingmachines);
}
protected override DbSet <multisignatureaccount> GetDbSet(ExplorerEntities entities)
{
return(entities.multisignatureaccounts);
}
protected override DbSet <transactionsignature> GetDbSet(ExplorerEntities entities)
{
return(entities.transactionsignatures);
}
public override void Initialize(ExplorerEntities entities)
{
base.Initialize(entities);
last = GetEnumerable().Select(declaration => declaration.DeclarationId).DefaultIfEmpty(-1).Max();
}
