public bool UpdateTestUUTPairsWithProjectLists(TestCaseUUTPair pair)
{
//lock (updateLock)
//{
return(SqlHelper.ExecuteNonQuery(sqlConnection, "spTestUUTPairsUpdateProjectLists",
pair.TestUUTPairID,
pair.EcosystemProjects
, pair.EcosystemProjectCount
, pair.TestProjects
, pair.TestProjectCount
, pair.TestMissingProjects
, pair.TestMissingProjectCount
, pair.UutClassProjects
, pair.UutClassProjectCount
, pair.UutMethodProjects
, pair.UutMethodProjectCount
, pair.TargetClassProjects
, pair.TargetClassProjectCount
, pair.TargetMethodProjects
, pair.TargetMethodProjectCount
, pair.UutProjectsByClone
, pair.UutProjectsByCloneCount
, pair.TargetProjectsByClone
, pair.TargetProjectsByCloneCount) > 0);
// }
}
public bool TestUUTPairInsert(TestCaseUUTPair tcp)
{
lock (updateLock)
{
return(SqlHelper.ExecuteNonQuery(sqlConnection, "spTestUUTPairInsert",
tcp.Project,
tcp.Parent,
tcp.ProjectIsFork,
tcp.TestPackage,
tcp.TestClassName,
tcp.TestMethodName,
tcp.TestMethodParameters,
tcp.TestSourceFilePath,
tcp.TestStartingLine,
tcp.TestEndingLine,
tcp.TestStartingColumn,
tcp.TestEndingColumn,
tcp.UutPackage,
tcp.UutClassName,
tcp.UutMethodName,
tcp.UutMethodParameters,
tcp.UutSourceFilePath,
tcp.UutStartingLine,
tcp.UutEndingLine,
tcp.UutStartingColumn,
tcp.UutEndingColumn) > 0);
}
}
public List <TestCaseUUTPair> GetTestCaseUUTPairsWithProjectLists(string ecosystem)
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlConnection, "spTestUUTPairsLoadAllWithProjectLists", ecosystem);
List <TestCaseUUTPair> records = new List <TestCaseUUTPair>();
while (reader.Read())
{
TestCaseUUTPair pair = new TestCaseUUTPair();
pair.ParentID = Convert.ToInt32(reader["parentID"]);
pair.Project = Convert.ToString(reader["project"]);
pair.Parent = Convert.ToString(reader["parent"]);
int isFork = Convert.ToInt32(reader["projectIsFork"]);
pair.ProjectIsFork = isFork == 1 ? true : false;
pair.TestPackage = Convert.ToString(reader["testPackage"]);
pair.TestClassName = Convert.ToString(reader["testClassName"]);
pair.TestMethodName = Convert.ToString(reader["testMethodName"]);
pair.TestMethodParameters = Convert.ToString(reader["testMethodParameters"]);
pair.TestSourceFilePath = Convert.ToString(reader["testSourceFilePath"]);
pair.TestStartingLine = Convert.ToInt64(reader["testStartingLine"]);
pair.TestEndingLine = Convert.ToInt64(reader["testEndingLine"]);
pair.TestStartingColumn = Convert.ToInt64(reader["testStartingColumn"]);
pair.TestEndingColumn = Convert.ToInt64(reader["testEndingColumn"]);
pair.UutPackage = Convert.ToString(reader["uutPackage"]);
pair.UutClassName = Convert.ToString(reader["uutClassName"]);
pair.UutMethodName = Convert.ToString(reader["uutMethodName"]);
pair.UutMethodParameters = Convert.ToString(reader["uutMethodParameters"]);
pair.UutSourceFilePath = Convert.ToString(reader["uutSourceFilePath"]);
pair.UutStartingLine = Convert.ToInt64(reader["uutStartingLine"]);
pair.UutEndingLine = Convert.ToInt64(reader["uutEndingLine"]);
pair.UutStartingColumn = Convert.ToInt64(reader["uutStartingColumn"]);
pair.UutEndingColumn = Convert.ToInt64(reader["uutEndingColumn"]);
pair.EcosystemProjects = Convert.ToString(reader["ecosystemProjects"]);
pair.EcosystemProjectCount = Convert.ToInt32(reader["ecosystemProjectCount"]);
pair.TestProjects = Convert.ToString(reader["testProjects"]);
pair.TestProjectCount = Convert.ToInt32(reader["testProjectCount"]);
pair.TestMissingProjects = Convert.ToString(reader["testMissingProjects"]);
pair.TestMissingProjectCount = Convert.ToInt32(reader["testMissingProjectCount"]);
pair.UutClassProjects = Convert.ToString(reader["uutClassProjects"]);
pair.UutClassProjectCount = Convert.ToInt32(reader["uutClassProjectCount"]);
pair.UutMethodProjects = Convert.ToString(reader["uutMethodProjects"]);
pair.UutMethodProjectCount = Convert.ToInt32(reader["uutMethodProjectCount"]);
pair.TargetClassProjects = Convert.ToString(reader["targetClassProjects"]);
pair.TargetClassProjectCount = Convert.ToInt32(reader["targetClassProjectCount"]);
pair.TargetMethodProjects = Convert.ToString(reader["targetMethodProjects"]);
pair.TargetMethodProjectCount = Convert.ToInt32(reader["targetMethodProjectCount"]);
pair.UutProjectsByClone = Convert.ToString(reader["uutProjectsByClone"]);
pair.UutProjectsByCloneCount = Convert.ToInt32(reader["uutProjectsByCloneCount"]);
pair.TargetProjectsByClone = Convert.ToString(reader["targetProjectsByClone"]);
pair.TargetProjectsByCloneCount = Convert.ToInt32(reader["targetProjectsByCloneCount"]);
records.Add(pair);
}
reader.Close();
return(records);
}
public List <TestCaseUUTPair> GetTestUUTPairsForEcosystem(string ecosystem)
{
lock (updateLock)
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlConnection, "spTestUUTPairsLoadAllForEcosystem", ecosystem);
List <TestCaseUUTPair> records = new List <TestCaseUUTPair>();
while (reader.Read())
{
TestCaseUUTPair pair = new TestCaseUUTPair();
pair.TestUUTPairID = Convert.ToInt64(reader["testUUTPairID"]);
pair.Project = Convert.ToString(reader["project"]);
pair.Parent = Convert.ToString(reader["parent"]);
pair.ProjectIsFork = Convert.ToBoolean(reader["projectIsFork"]);
pair.TestPackage = Convert.ToString(reader["testPackage"]);
pair.TestClassName = Convert.ToString(reader["testClassName"]);
pair.TestMethodName = Convert.ToString(reader["testMethodName"]);
pair.TestMethodParameters = Convert.ToString(reader["testMethodParameters"]);
pair.TestSourceFilePath = Convert.ToString(reader["testSourceFilePath"]);
pair.TestStartingLine = Convert.ToInt64(reader["testStartingLine"]);
pair.TestEndingLine = Convert.ToInt64(reader["testEndingLine"]);
pair.TestStartingColumn = Convert.ToInt64(reader["testStartingColumn"]);
pair.TestEndingColumn = Convert.ToInt64(reader["testEndingColumn"]);
pair.UutPackage = Convert.ToString(reader["uutPackage"]);
pair.UutClassName = Convert.ToString(reader["uutClassName"]);
pair.UutMethodName = Convert.ToString(reader["uutMethodName"]);
pair.UutMethodParameters = Convert.ToString(reader["uutMethodParameters"]);
pair.UutSourceFilePath = Convert.ToString(reader["uutSourceFilePath"]);
pair.UutStartingLine = Convert.ToInt64(reader["uutStartingLine"]);
pair.UutEndingLine = Convert.ToInt64(reader["uutEndingLine"]);
pair.UutStartingColumn = Convert.ToInt64(reader["uutStartingColumn"]);
pair.UutEndingColumn = Convert.ToInt64(reader["uutEndingColumn"]);
records.Add(pair);
}
reader.Close();
return(records);
}
}
