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); } }