I have the following method that contains the logic for saving Nunit tests to a mysql database:
public void AddModelToDatabase(FileReportModel Model, UnitOfWork UnitOfWork)
{
var project= UnitOfWork.Projects.AddProject();
var namespace_id = UnitOfWork.Namespaces.AddNamespace(Model);
var story_list = Model.Stories.ToList();
UnitOfWork.DailyReportInfo.AddDailyReportInfo();
var session_id = UnitOfWork.Sessions.AddStorySession(story_list, project, namespace_id);
foreach (var item in story_list)
{
var fixture_data = UnitOfWork.Fixtures.AddFixture(item, namespace_id);
UnitOfWork.SaveChanges();
var scenarios_group_by_id = item.Scenarios.GroupBy(S => S.Id);
bool first = true;
foreach (var scenario in scenarios_group_by_id)
{
var test_data = UnitOfWork.Tests.AddTest(scenario.FirstOrDefault(), fixture_data);
var tests_and_subtests = scenario.ToArray();
foreach (var test in tests_and_subtests)
{
var result_data = UnitOfWork.Results.AddResult(scenario);
var bug_data = UnitOfWork.Bugs.GetAll();
if (test.Example != null)
{
var total_tests = tests_and_subtests.ToList().Count;
var sub_test_data = UnitOfWork.SubTests.AddSubTest(test_data,total_tests);
UnitOfWork.ExampleTableHeaders.AddExampleTableHeaders(test, UnitOfWork);
var example_header_data = UnitOfWork.ExampleTableHeaders.GetAll().Where(x => test.Example.Headers.Contains(x.Name));
UnitOfWork.TestHeaders.AddTestHeader(test_data, example_header_data,test, UnitOfWork);
UnitOfWork.TestBugs.AddTestBug(test.Tags, test_data,sub_test_data, bug_data);
UnitOfWork.ExampleTableValues.AddExampleTableValues(test, UnitOfWork);
foreach (var header in test.Example.Values)
{
var test_header_count = Array.FindIndex(test.Example.Headers, Row => Row.Contains(header.Header));
var example_table_values = UnitOfWork.ExampleTableValues.GetAll().Where(t => test.Example.Values.ToList()(test_header_count).GetValueAsString().Contains(t.Name));
UnitOfWork.SubTestValues.AddSubTestValuesByIndex(sub_test_data, test_header_count, example_table_values, test, UnitOfWork);
}
UnitOfWork.SessionSubTests.AddSessionSubTest(session_id, test_data, sub_test_data, result_data);
UnitOfWork.StepCategories.AddStepCategory(UnitOfWork);
UnitOfWork.Steps.AddStep(test.Steps, UnitOfWork);
if (first)
{
foreach (var step in tests_and_subtests.First().Steps)
{
var step_modifiers = UnitOfWork.StepCategories.GetAll().Where(M => step.Title.Contains(M.Name));
var step_data = UnitOfWork.Steps.GetAll().Where(S => step.Title.Contains(S.Name));
var step_index = tests_and_subtests.First().Steps.FindIndex(i => i.Title == step_data.First().Name);
UnitOfWork.TestSteps.AddTestSteps(test_data, step_data, step_modifiers, step_index);
}
first = false;
}
}
else
{
UnitOfWork.SessionSubTests.AddSessionSubTest(session_id, test_data, null, result_data);
UnitOfWork.TestBugs.AddTestBug(test.Tags, test_data, null, bug_data);
UnitOfWork.StepCategories.AddStepCategory(UnitOfWork);
UnitOfWork.Steps.AddStep(test.Steps, UnitOfWork);
foreach (var step in test.Steps)
{
var step_modifiers = UnitOfWork.StepCategories.GetAll().Where(M => step.Title.Contains(M.Name));
var step_data = UnitOfWork.Steps.GetAll().Where(S => step.Title.Contains(S.Name));
var step_index = tests_and_subtests.First().Steps.FindIndex(i => i.Title == step_data.First().Name);
UnitOfWork.TestSteps.AddTestSteps(test_data, step_data, step_modifiers, step_index);
}
}
UnitOfWork.Tags.AddTags(test.Tags, UnitOfWork);
var tags_data = UnitOfWork.Tags.GetAll().Where(c => test.Tags.Contains(c.Name));
UnitOfWork.TestTags.AddTestTags(test_data,test.Tags, tags_data, UnitOfWork);
}
}
}
}
And I’m calling it like so :
using (var context = new DbContext())
{
context.Database.Log = Console.Write;
if (!context.Database.Connection.State.HasFlag(ConnectionState.Open))
{
context.Database.Connection.Open();
}
using (var transaction = context.Database.BeginTransaction())
{
try
{
var unit_of_work = new UnitOfWork(context);
unit_of_work.Sessions.AddModelToDatabase(Model, unit_of_work);
context.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
Even that the AddModelToDatabase() is working I have the feeling that can be improved: like maybe using to many nested foreach(possible performance issues)? or maybe breaking it to separated and smaller methods? Maybe even to many nested SaveChanges? I will appreciate any feedback