public static Task SeedTestDataAsync(this MandarinDbContext mandarinDbContext)
{
using var connection = mandarinDbContext.GetConnection();
connection.Open();
mandarinDbContext.RunMigrations();
return(Task.CompletedTask);
}
public static async Task CleanupTestDataAsync(this MandarinDbContext mandarinDbContext)
{
using var connection = mandarinDbContext.GetConnection();
connection.Open();
await connection.ExecuteAsync("DROP TABLE billing.commission");
await connection.ExecuteAsync("DROP TABLE inventory.stockist_detail");
await connection.ExecuteAsync("DROP TABLE inventory.stockist");
await connection.ExecuteAsync("DROP TABLE inventory.fixed_commission_amount");
await connection.ExecuteAsync("TRUNCATE TABLE public.schemaversions");
}