private async Task clearExistingState(CancellationToken token)
{
_logger.ClearingExistingState(this);
var types = _projection.ProjectedTypes();
using (var conn = _tenant.OpenConnection())
{
foreach (var type in types)
{
var tableName = _tenant.MappingFor(type).TableName;
var sql =
$"delete from {_store.Events.DatabaseSchemaName}.mt_event_progression where name = :name;truncate {tableName} cascade";
var cmd = new NpgsqlCommand(sql).With("name", _projection.GetEventProgressionName(type));
await conn.ExecuteAsync(cmd, token);
}
}
LastEncountered = 0;
}
private async Task clearExistingState(CancellationToken token)
{
_logger.ClearingExistingState(this);
var types = _projection.ProjectedTypes();
using (var conn = _tenant.OpenConnection())
{
foreach (var type in types)
{
var tableName = _tenant.MappingFor(type).Table;
var sql =
$"delete from {_store.Events.DatabaseSchemaName}.mt_event_progression where name = :name;truncate {tableName} cascade";
await conn.ExecuteAsync(async (cmd, tkn) =>
{
await cmd.Sql(sql)
.With("name", type.FullName)
.ExecuteNonQueryAsync(tkn)
.ConfigureAwait(false);
}, token);
}
}
LastEncountered = 0;
}
