private DataTable GetTestSteps(int testPlan) { string query = "select Description, Command, Text, XPath from dps.dpsdynamic.QA_TEST_STEP A1 " + "join dps.dpsdynamic.QA_TEST_STEP_IN_PLAN A2 on A1.IdStep = A2.IdStep where A2.IdPlan = '" + testPlan.ToString() + "' order by A2.OrderInTest"; string result = new ReaderWriterDataBase().TryQueryToDataTable(Settings.connectionString, query, false, out DataTable dataTable); return(dataTable); }
private int FindFirstTest(out int batch) { //znajdź pierwszy test plan z aktywnego batcha, dla którego nie wykonano dzisiaj testu //chyba wyjąć do settingsów całe query string query = @"select A1.IdPlan, A2.IdBatch, A2.OrderInBatch from dps.dpsdynamic.qa_test_plan A1 join dps.dpsdynamic.qa_test_plan_in_batch A2 on A1.IdPlan = A2.IdPlan join dps.dpsdynamic.QA_TEST_BATCH A3 on A3.IdBatch = A2.IdBatch where (select count (*) from dps.dpsdynamic.qa_test_step_in_plan A5 where A5.idplan = A1.IdPlan) > 0 and A3.IsActive = 'YES' except select A1.IdPlan, A2.IdBatch, A2.OrderInBatch from dps.dpsdynamic.qa_test_plan A1 join dps.dpsdynamic.qa_test_plan_in_batch A2 on A1.IdPlan = A2.IdPlan join dps.dpsdynamic.QA_TEST_BATCH A3 on A3.IdBatch = A2.IdBatch right join dps.dpsdynamic.QA_TEST_RESULT A4 on A4.IdBatch = A2.IdBatch and A4.IdPlan = A2.IdPlan where CAST(A4.DateTime as date) = CAST(GETDATE() AS date) order by A2.IdBatch, A2.OrderInBatch"; string result = new ReaderWriterDataBase().TryQueryToDataTable(Settings.connectionString, query, false, out DataTable dataTable); //msg flase if (result != "ok") { techLogger.Log("TestManager.FindFirstTest() DB connection error: " + result); } if ((dataTable.Rows.Count > 0) && (dataTable.Rows[0][0].ToString() != "NO_RESULT_TABLE")) { batch = (int)dataTable.Rows[0][1]; return((int)dataTable.Rows[0][0]); } else { batch = -1; return(-1); } }