public AccountsCache(AccountMetadataService metadata, IConfiguration config, ILogger <AccountsCache> logger) : base(config)
{
Metadata = metadata;
Config = config.GetCacheConfig();
Logger = logger;
Logger.LogDebug("Initializing accounts cache...");
using var db = GetConnection();
var totalAccounts = db.QueryFirst <int>(@"SELECT COUNT(*) FROM ""Accounts""");
var count = Math.Min(totalAccounts, Config.MaxAccounts);
var capacity = count < Config.MaxAccounts
? Math.Min((int)(count * 1.1), Config.MaxAccounts)
: Config.MaxAccounts;
var sql = @"
SELECT *
FROM ""Accounts""
ORDER BY ""LastLevel"" DESC
LIMIT @limit";
using var reader = db.ExecuteReader(sql, new { limit = (int)(count * Config.LoadRate) });
var userParser = reader.GetRowParser <RawUser>();
var delegateParser = reader.GetRowParser <RawDelegate>();
var contractParser = reader.GetRowParser <RawContract>();
AccountsById = new Dictionary <int, RawAccount>(capacity);
AccountsByAddress = new Dictionary <string, RawAccount>(capacity);
while (reader.Read())
{
RawAccount account = reader.GetInt32(2) switch
{
0 => userParser(reader),
1 => delegateParser(reader),
2 => contractParser(reader),
_ => throw new Exception($"Invalid raw account type")
};
AccountsById.Add(account.Id, account);
AccountsByAddress.Add(account.Address, account);
}
Logger.LogDebug($"Loaded {AccountsByAddress.Count} of {totalAccounts} accounts");
}
public SuggestController(AccountMetadataService accounts, ProposalMetadataService proposals, ProtocolMetadataService protocols)
{
AccountMetadata = accounts;
ProposalMetadata = proposals;
ProtocolMetadata = protocols;
}
