public IEnumerable <ChartStatsViewModel> GetBlockSizeStats(ChartFilterViewModel filter)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
long latestBlockDate = this.GetLatestTimestamp();
filter.StartDate = latestBlockDate.ToUnixDate();
List <ChartStatsViewModel> result = new List <ChartStatsViewModel>();
foreach (var endStamp in filter.GetPeriodStamps())
{
var avgSize = this.db.Blocks
.AsNoTracking()
.Where(x => x.Timestamp <= latestBlockDate && x.Timestamp >= endStamp)
.Average(x => x.Size);
result.Add(new ChartStatsViewModel
{
Value = (decimal)avgSize,
StartDate = DateOrderFilter.GetDateTime(endStamp, filter.UnitOfTime),
UnitOfTime = filter.UnitOfTime
});
latestBlockDate = endStamp;
}
stopwatch.Stop();
Log.Information("GetBlockSizeStats time - " + stopwatch.ElapsedMilliseconds);
return(result);
}
public IEnumerable <ChartStatsViewModel> GetStats(ChartFilterViewModel filter)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
var latestDate = this.db.Transactions
.OrderByDescending(x => x.Timestamp)
.Select(x => x.Timestamp)
.First();
filter.StartDate = latestDate.ToUnixDate();
List <ChartStatsViewModel> result = new List <ChartStatsViewModel>();
var periods = filter.GetPeriodStamps();
foreach (var endStamp in periods)
{
var count = this.db.Transactions
.Where(x => x.Timestamp <= latestDate && x.Timestamp >= endStamp)
.Count();
result.Add(new ChartStatsViewModel
{
Value = (decimal)count,
StartDate = DateOrderFilter.GetDateTime(endStamp, filter.UnitOfTime),
UnitOfTime = filter.UnitOfTime
});
latestDate = endStamp;
}
stopwatch.Stop();
Log.Information($"{this.GetType().FullName} - GetStats time - " + stopwatch.ElapsedMilliseconds);
return(result);
}
private ICollection <ChartStatsViewModel> GetBlockTimesStats(ChartFilterViewModel filter)
{
var latestBlockDate = this.GetLatestTimestamp();
filter.StartDate = latestBlockDate.ToUnixDate();
filter.StartStamp = latestBlockDate;
var result = this.GetChartEntries(filter.UnitOfTime, ChartEntryType.BlockTimes);
var periods = filter.GetPeriodStamps().Where(x => !result.Any(y => y.Timestamp == x));
foreach (var endStamp in periods)
{
var blocksQuery = this.db.Blocks
.Where(x => x.Timestamp <= latestBlockDate && x.Timestamp >= endStamp);
var count = blocksQuery.Count();
var sum = count > 0 ? blocksQuery.Sum(x => x.TimeInSeconds) : 0;
result.Add(new ChartStatsViewModel
{
Label = endStamp.ToUnixDate().ToString(),
AccumulatedValue = (decimal)sum,
Value = (decimal)count,
StartDate = DateOrderFilter.GetDateTime(endStamp, filter.UnitOfTime),
UnitOfTime = filter.UnitOfTime
});
var exists = this.db.ChartEntries.Any(
x =>
x.Timestamp == endStamp &&
x.Type == ChartEntryType.BlockTimes &&
x.UnitOfTime == filter.UnitOfTime);
latestBlockDate = endStamp;
if (exists || !endStamp.IsPeriodOver(filter.UnitOfTime))
{
continue;
}
this.db.ChartEntries.Add(new Data.Models.ChartEntry
{
UnitOfTime = filter.UnitOfTime,
Timestamp = endStamp,
Type = ChartEntryType.BlockTimes,
AccumulatedValue = (decimal)sum,
Value = count
});
this.db.SaveChanges();
}
return(result);
}
private ICollection <ChartStatsViewModel> GetConsensusRewardsStats(ChartFilterViewModel filter)
{
var latestBlockDate = this.GetLatestTimestamp();
filter.StartStamp = latestBlockDate;
filter.StartDate = latestBlockDate.ToUnixDate();
var result = this.GetChartEntries(filter.UnitOfTime, ChartEntryType.ConsensusRewards);
var periods = filter.GetPeriodStamps().Where(x => !result.Any(y => y.Timestamp == x)).ToArray();
for (int i = 1; i < periods.Length; i++)
{
var sum = this.db.Transactions
.Where(x => x.Type == TransactionType.MinerTransaction)
.Where(x => x.GlobalOutgoingAssets.Any())
.Where(x => x.Timestamp < periods[i - 1] && x.Timestamp >= periods[i])
.SelectMany(x => x.GlobalOutgoingAssets)
.Sum(x => x.Amount);
result.Add(new ChartStatsViewModel
{
Value = (decimal)sum,
StartDate = DateOrderFilter.GetDateTime(periods[i], filter.UnitOfTime),
UnitOfTime = filter.UnitOfTime
});
var exists = this.db.ChartEntries.Any(
x =>
x.Timestamp == periods[i] &&
x.Type == ChartEntryType.ConsensusRewards &&
x.UnitOfTime == filter.UnitOfTime);
if (exists || !periods[i].IsPeriodOver(filter.UnitOfTime))
{
continue;
}
this.db.ChartEntries.Add(new Data.Models.ChartEntry
{
UnitOfTime = filter.UnitOfTime,
Timestamp = periods[i],
Type = ChartEntryType.ConsensusRewards,
Value = sum
});
this.db.SaveChanges();
}
return(result);
}
private ICollection <ChartStatsViewModel> GetActiveAddressesStats(ChartFilterViewModel filter)
{
var latestBlockDate = this.GetLatestTimestamp();
filter.StartDate = latestBlockDate.ToUnixDate();
filter.StartStamp = latestBlockDate;
var result = this.GetChartEntries(filter.UnitOfTime, ChartEntryType.ActiveAddresses);
var periods = filter.GetPeriodStamps().Where(x => !result.Any(y => y.Timestamp == x)).ToArray();
for (int i = 1; i < periods.Length; i++)
{
var count = this.db.Addresses
.Count(x => x.AddressesInTransaction.Any(at => at.Timestamp < periods[i - 1] && at.Timestamp >= periods[i]));
result.Add(new ChartStatsViewModel
{
Value = (decimal)count,
StartDate = DateOrderFilter.GetDateTime(periods[i], filter.UnitOfTime),
UnitOfTime = filter.UnitOfTime
});
var exists = this.db.ChartEntries.Any(
x =>
x.Timestamp == periods[i] &&
x.Type == ChartEntryType.ActiveAddresses &&
x.UnitOfTime == filter.UnitOfTime);
if (exists || !periods[i].IsPeriodOver(filter.UnitOfTime))
{
continue;
}
this.db.ChartEntries.Add(new Data.Models.ChartEntry
{
UnitOfTime = filter.UnitOfTime,
Timestamp = periods[i],
Type = ChartEntryType.ActiveAddresses,
Value = count
});
this.db.SaveChanges();
}
return(result);
}