public ReportCreatorTests()
{
using (var con = new SqlConnection(sqlSettings.GetConnectionString()))
{
con.Open();
var category = sqlSettings.GetCurrentCategory();
con.Execute($"DELETE dbo.Items WHERE Category = '{category}'");
void InsertItem(int id, string type, decimal amount, bool reported)
{
con.Execute($"INSERT INTO dbo.Items VALUES ({id}, 'Name{id}', '{type}', {amount}, {(reported ? 1 : 0)}, '{category}')");
}
InsertItem(99901, "Red", 100, true);
InsertItem(99902, "Blue", 100, true);
InsertItem(99903, "Red", 100, true);
InsertItem(99904, "Red", 100, false);
InsertItem(99905, "Blue", 200, false);
InsertItem(99906, "Red", 300, false);
InsertItem(99907, "Green", 400, false);
InsertItem(99908, "Violet", 500, false);
InsertItem(99909, "Red", 600, false);
}
Environment.SetEnvironmentVariable("Username", "IntegrationTest");
}
public async Task <DbConnection> OpenConnection(ISqlSettings settings)
{
return(await this.OpenConnection(await settings.GetConnectionString(), settings.GetAccessToken));
}
