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