public void ServiceBillLogTest(string no, string in_InitializeSqlSet, string in_Message, string expected_TableData, string expected_FailureBlobFileSet, string expected_LogMessages, string expected_WithoutError, string remarks)
{
List <TestLog> actual_logs = new List <TestLog>();
// DI
DependencyInjection(DefaultAppSettingValues, actual_logs);
// テストデータ準備
{
if (Directory.Exists(in_InitializeSqlSet))
{
using (SqlConnection connection = new SqlConnection(settings.PrimaryDbConnectionString))
{
try
{
connection.Open();
foreach (string path in Directory.GetFiles(in_InitializeSqlSet, "*.sql", SearchOption.AllDirectories))
{
string cmdText = File.ReadAllText(path);
using (SqlCommand command = new SqlCommand(cmdText, connection))
{
command.ExecuteNonQuery();
}
}
}
finally
{
connection.Close();
}
}
}
in_Message = (in_Message != null && File.Exists(in_Message)) ? File.ReadAllText(in_Message) : in_Message;
}
// テスト実行後、テーブルを評価するかどうか
bool isCheckTable = !string.IsNullOrEmpty(expected_TableData) && File.Exists(expected_TableData);
// 評価対象テーブル名
string targetTableName = isCheckTable ? Path.GetFileNameWithoutExtension(expected_TableData) : null;
// 期待値
DataTable expected_table = isCheckTable ? DbTestHelper.SelectCsv(expected_TableData, "SELECT * FROM " + targetTableName) : null;
DirectoryInfo expectedFailureDir = new DirectoryInfo(expected_FailureBlobFileSet);
string[] expectedFailureFiles = expectedFailureDir.Exists ? expectedFailureDir.GetFiles("*", SearchOption.AllDirectories).Select(x => x.FullName).OrderBy(x => x).ToArray() : new string[] { };
string[] expected_failure_names = expectedFailureFiles.Select(x => x.Replace(expectedFailureDir.FullName, string.Empty)).ToArray();
string[] expected_failure_contents = expectedFailureFiles.Select(x => File.ReadAllText(x)).ToArray();
List <string> expected_log_messages = (!string.IsNullOrEmpty(expected_LogMessages) && File.Exists(expected_LogMessages)) ? File.ReadLines(expected_LogMessages).ToList() : new List <string>();
// テスト実行
target.DispatchPlusServiceBillLog(in_Message, new TestLogger <DispatchController>(actual_logs));
// テスト結果
DataTable actual_table = isCheckTable ? DbTestHelper.SelectTable("SELECT * FROM " + targetTableName) : null;
DirectoryInfo actualDir = new DirectoryInfo(Path.Combine(TestResultRootDir, no));
string[] actualFailureFiles = failureBlob.Client.GetFiles(settings.FailureBlobContainerNameDispatcher, actualDir).OrderBy(x => x).ToArray();
string[] actual_failure_names = actualFailureFiles.Select(x => x.Replace(actualDir.FullName, string.Empty)).ToArray();
string[] actual_failure_contents = actualFailureFiles.Select(x => File.ReadAllText(x)).ToArray();
List <string> actual_log_messages = actual_logs.Select(x => x.GetSimpleText()).ToList();
// 確認
if (isCheckTable)
{
// 評価対象外のカラムを除外
Array.ForEach(IgnoreColumns, x => expected_table.Columns.Remove(x));
Array.ForEach(IgnoreColumns, x => actual_table.Columns.Remove(x));
Microsoft.VisualStudio.TestTools.UnitTesting.Assert.AreEqual(expected_table.Rows.Count, actual_table.Rows.Count);
for (int i = 0; i < expected_table.Rows.Count; i++)
{
CollectionAssert.AreEqual(expected_table.Rows[i].ItemArray, actual_table.Rows[i].ItemArray);
}
}
CollectionAssert.AreEqual(expected_failure_names, actual_failure_names);
CollectionAssert.AreEqual(expected_failure_contents, actual_failure_contents);
bool.TryParse(expected_WithoutError, out bool isWithoutError);
if (isWithoutError)
{
var error_logs = actual_logs.Where(x => x.LogLevel == Microsoft.Extensions.Logging.LogLevel.Error);
Microsoft.VisualStudio.TestTools.UnitTesting.Assert.AreEqual(false, error_logs.Any());
}
foreach (var expected_log_message in expected_log_messages)
{
var matching_element = actual_log_messages.FirstOrDefault(actual => actual.Contains(expected_log_message));
Microsoft.VisualStudio.TestTools.UnitTesting.Assert.IsNotNull(matching_element, string.Format("「{0}」に一致する要素が見つかりません", expected_log_message));
if (matching_element != null)
{
actual_log_messages.Remove(matching_element);
}
}
}
