public virtual long GetTestInstanceCount(string filterString)
{
string cmd = SqlCommandFactory.CreateCalcCountCmd(filterString, DataBaseItemNames.InstanceTableName);
using (DbDataReader dataReader = ExecuteReadCommand(cmd))
{
long count = 0;
if (dataReader.Read() && !dataReader.IsDBNull(0))
{
count = dataReader.GetInt64(0);
}
return(count);
}
}
public long GetRuntimeStatusCount(string runtimeHash, int session, int sequenceIndex)
{
string filter =
$"{DataBaseItemNames.RuntimeIdColumn}='{runtimeHash}' AND {DataBaseItemNames.SessionIdColumn}={session} AND {DataBaseItemNames.SequenceIndexColumn}={sequenceIndex}";
string cmd = SqlCommandFactory.CreateCalcCountCmd(filter, DataBaseItemNames.StatusTableName);
using (DbDataReader dataReader = ExecuteReadCommand(cmd))
{
long count = 0;
if (dataReader.Read() && !dataReader.IsDBNull(0))
{
count = dataReader.GetInt64(0);
}
return(count);
}
}
public bool ExistFailedStep(string runtimeHash, int session, int sequence)
{
const string failedResultFilter = "StepResult IN ('Error', 'Timeout', 'Failed', 'Abort')";
string filter =
$"{DataBaseItemNames.RuntimeIdColumn}='{runtimeHash}' AND {DataBaseItemNames.SessionIdColumn}={session} AND {DataBaseItemNames.SequenceIndexColumn} = {sequence} AND {failedResultFilter}";
string cmd = SqlCommandFactory.CreateCalcCountCmd(filter, DataBaseItemNames.StatusTableName);
using (DbDataReader dataReader = ExecuteReadCommand(cmd))
{
int count = 0;
if (dataReader.Read() && !dataReader.IsDBNull(0))
{
count = dataReader.GetInt32(0);
}
return(count > 0);
}
}