public PartIResult GetLatestResult(TestCaseEnums testCase, TestScenarioEnums scenario)
{
using (Entities ctx = new Entities())
{
return(ctx.PartIResult.OrderByDescending(tr => tr.TestNumber).FirstOrDefault(r => r.DataBaseType == (int)dataBaseType &&
r.TestCase == (int)testCase && r.TestScenario == (int)scenario));
}
}
public static RunConfiguration GetConfigurations(TestCaseEnums testCase)
{
switch (testCase)
{
case TestCaseEnums.Initialize:
return new RunConfiguration
{
NumberOfInsertRuns = 10,
NumberOfSelectRuns = 10,
NumberOfUpdateRuns = 10,
TotalNumberOfDepartments = 1,
TotalNumberOfUsers = 1,
TotalNumberOfProjects = 1,
TestCase = testCase,
};
case TestCaseEnums.TestCase1:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 4,
TotalNumberOfUsers = 128,
TotalNumberOfProjects = 16,
TestCase = testCase,
};
case TestCaseEnums.TestCase2:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 200,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 8,
TotalNumberOfUsers = 256,
TotalNumberOfProjects = 64,
TestCase = testCase,
};
case TestCaseEnums.TestCase3:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 16,
TotalNumberOfUsers = 1024,
TotalNumberOfProjects = 512,
TestCase = testCase,
};
case TestCaseEnums.TestCase4:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 200,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 128,
TotalNumberOfUsers = 4096,
TotalNumberOfProjects = 8192,
TestCase = testCase,
};
case TestCaseEnums.TestCase5:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 1128,
TotalNumberOfUsers = 5096,
TotalNumberOfProjects = 9192,
TestCase = testCase,
};
case TestCaseEnums.TestCase6:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 2128,
TotalNumberOfUsers = 6096,
TotalNumberOfProjects = 10192,
TestCase = testCase,
};
case TestCaseEnums.TestCase7:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 3128,
TotalNumberOfUsers = 7096,
TotalNumberOfProjects = 11192,
TestCase = testCase,
};
case TestCaseEnums.TestCase8:
return new RunConfiguration
{
NumberOfInsertRuns = 100,
NumberOfSelectRuns = 100,
NumberOfUpdateRuns = 100,
TotalNumberOfDepartments = 4128,
TotalNumberOfUsers = 8096,
TotalNumberOfProjects = 12192,
TestCase = testCase,
};
default:
return new RunConfiguration
{
NumberOfInsertRuns = 0,
TotalNumberOfDepartments = 0,
TotalNumberOfUsers = 0,
TotalNumberOfProjects = 0,
TestCase = testCase,
};
}
}
public static RunConfiguration GetConfigurations(TestCaseEnums testCase)
{
switch (testCase)
{
case TestCaseEnums.Initialize:
return new RunConfiguration
{
NumberOfSelects = 1,
NumberOfUpdates = 1,
TotalNumberOfDepartments = 1,
TotalNumberOfUsers = 1,
TotalNumberOfProjects = 1,
TestCase = testCase,
};
case TestCaseEnums.TestCase1:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 4,
TotalNumberOfUsers = 128,
TotalNumberOfProjects = 16,
TestCase = testCase,
};
case TestCaseEnums.TestCase2:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 8,
TotalNumberOfUsers = 256,
TotalNumberOfProjects = 64,
TestCase = testCase,
};
case TestCaseEnums.TestCase3:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 16,
TotalNumberOfUsers = 1024,
TotalNumberOfProjects = 512,
TestCase = testCase,
};
case TestCaseEnums.TestCase4:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 128,
TotalNumberOfUsers = 4096,
TotalNumberOfProjects = 8192,
TestCase = testCase,
};
case TestCaseEnums.TestCase5:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 256,
TotalNumberOfUsers = 8192,
TotalNumberOfProjects = 16384,
TestCase = testCase,
};
case TestCaseEnums.TestCase6:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 512,
TotalNumberOfUsers = 16384,
TotalNumberOfProjects = 32768,
TestCase = testCase,
};
case TestCaseEnums.TestCase7:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 1024,
TotalNumberOfUsers = 32768,
TotalNumberOfProjects = 65536,
TestCase = testCase,
};
case TestCaseEnums.TestCase8:
return new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 2048,
TotalNumberOfUsers = 65536,
TotalNumberOfProjects = 131072,
TestCase = testCase,
};
default:
return new RunConfiguration
{
NumberOfSelects = 0,
NumberOfUpdates = 0,
TotalNumberOfDepartments = 0,
TotalNumberOfUsers = 0,
TotalNumberOfProjects = 0,
TestCase = testCase,
};
}
}
public static RunConfiguration GetConfigurations(TestCaseEnums testCase)
{
switch (testCase)
{
case TestCaseEnums.Initialize:
return(new RunConfiguration
{
NumberOfSelects = 1,
NumberOfUpdates = 1,
TotalNumberOfDepartments = 1,
TotalNumberOfUsers = 1,
TotalNumberOfProjects = 1,
TestCase = testCase,
});
case TestCaseEnums.TestCase1:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 4,
TotalNumberOfUsers = 128,
TotalNumberOfProjects = 16,
TestCase = testCase,
});
case TestCaseEnums.TestCase2:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 8,
TotalNumberOfUsers = 256,
TotalNumberOfProjects = 64,
TestCase = testCase,
});
case TestCaseEnums.TestCase3:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 16,
TotalNumberOfUsers = 1024,
TotalNumberOfProjects = 512,
TestCase = testCase,
});
case TestCaseEnums.TestCase4:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 128,
TotalNumberOfUsers = 4096,
TotalNumberOfProjects = 8192,
TestCase = testCase,
});
case TestCaseEnums.TestCase5:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 256,
TotalNumberOfUsers = 8192,
TotalNumberOfProjects = 16384,
TestCase = testCase,
});
case TestCaseEnums.TestCase6:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 512,
TotalNumberOfUsers = 16384,
TotalNumberOfProjects = 32768,
TestCase = testCase,
});
case TestCaseEnums.TestCase7:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 1024,
TotalNumberOfUsers = 32768,
TotalNumberOfProjects = 65536,
TestCase = testCase,
});
case TestCaseEnums.TestCase8:
return(new RunConfiguration
{
NumberOfSelects = 100,
NumberOfUpdates = 100,
TotalNumberOfDepartments = 2048,
TotalNumberOfUsers = 65536,
TotalNumberOfProjects = 131072,
TestCase = testCase,
});
default:
return(new RunConfiguration
{
NumberOfSelects = 0,
NumberOfUpdates = 0,
TotalNumberOfDepartments = 0,
TotalNumberOfUsers = 0,
TotalNumberOfProjects = 0,
TestCase = testCase,
});
}
}
public void Run(TestCaseEnums testCase)
{
Console.WriteLine(string.Format("Test case '{0}' has started..", testCase.ToString()));
RunConfiguration config = RunConfiguration.GetConfigurations(testCase);
stopwatch.Reset();
results.Clear();
if (!RunInserts(config, stopwatch, results))
{
return;
}
if (!RunUpdateDepartmentName(config, stopwatch, results))
{
return;
}
if (!RunUpdateUserLastName(config, stopwatch, results))
{
return;
}
if (!RunUpdateProjectName(config, stopwatch, results))
{
return;
}
if (!RunSelectDepartmentByKey(config, stopwatch, results))
{
return;
}
if (!RunSelectDepartmentByRandomName(config, stopwatch, results))
{
return;
}
if (!RunSelectUserByKey(config, stopwatch, results))
{
return;
}
if (!RunSelectUserByRandomFirstName(config, stopwatch, results))
{
return;
}
if (!RunSelectDepartmentByRandomUser(config, stopwatch, results))
{
return;
}
if (!RunSelectUserByRandomProject(config, stopwatch, results))
{
return;
}
if (!RunSelectAvgUserAgeByProjects(config, stopwatch, results))
{
return;
}
Console.WriteLine("Saving result data in the database..");
recorder.Record(results);
Console.WriteLine("Saving result data succeeded.");
results.Clear();
stopwatch.Stop();
Console.WriteLine(string.Format("Test case '{0}' successfully completed.", testCase.ToString()));
Console.WriteLine("--------------------------------------------------------------------------");
Thread.Sleep(5000);
}
public PartIResult GetLatestResult(TestCaseEnums testCase, TestScenarioEnums scenario)
{
using (Entities ctx = new Entities())
{
return ctx.PartIResult.OrderByDescending(tr => tr.TestNumber).FirstOrDefault(r => r.DataBaseType == (int)dataBaseType
&& r.TestCase == (int)testCase && r.TestScenario == (int)scenario);
}
}
