/*
* //try
* //{
* // ////get list of column name
* // //List fieldList = TDConnHandle.get_Fields("TEST");
* // //int a = fieldList.Count;
* // //foreach (TDField aField in fieldList)
* // //{
* // // Console.WriteLine("Field name:{0}", aField.Name);
* // //}
*
* // //TestSetTreeManager TestSetTreeMana = TDConnHandle.TestSetTreeManager as TestSetTreeManager;
* // //TestSetFolder TestSetFolderPath = TestSetTreeMana.get_NodeByPath(rootPath) as TestSetFolder;
* // ////Add a new folder under the rootPath
* // //SysTreeNode CurTestSetFolder = TestSetFolderPath.AddNode(TestSetFolderName) as SysTreeNode;
* // //CurTestSetFolder.Post();
*
* // ////The new test set will be added under the newly test folder
* // //TestSetFolder TSFolder = TestSetTreeMana.get_NodeById(CurTestSetFolder.NodeID) as TestSetFolder;
* // //TestSetFactory TSFact = TSFolder.TestSetFactory as TestSetFactory;
*
* // //TestFactory TestFact = TDConnHandle.TestFactory as TestFactory;
* // //TDFilter TFilter = TestFact.Filter as TDFilter;
* // ////All match item will be filtered by the provided field and value
* // //foreach (TestConfigFile.AutorunFilerConfig filter in TConfig.CaseFilter.AutorunFilter)
* // //{
* // // TFilter[filter.FieldName] = filter.FieldValue;
* // //}
*
* // ////All matched test cases will be storaged in TList temporarily
* // //List TList = TFilter.NewList();
*
* // ////Add test set name
* // //TestSet TestSetName;
* // //TSTestFactory TSTestFact;
*
* // //TestSetName = TSFact.AddItem("test set 1") as TestSet;
* // //TestSetName.Post();
* // //TSTestFact = TestSetName.TSTestFactory as TSTestFactory;
*
* // //foreach (Test t in TList)
* // //{
*
* // // TSTestFact.AddItem(t.ID);
* // //}
* // //All test cases will be saved into the specified folder's testSet
* // return true;
* //}
* //catch (Exception e)
* //{
* // Console.WriteLine("Create Test Cases Error!");
* // Console.WriteLine("{0}", e.Message);
* // return false;
* //}
* */
//According to the search conditions defined in XML, generate a list of TestSet names
private List <string> GetAllTestSetNames(string TestSetNameField)
{
// Using SQL and ICommand to get the specified filed values, and store them to a List
try
{
ICommand com = tdConn.Command as ICommand;
com.CommandText = "select distinct " + TestSetNameField + " from test";
IRecordset recList = com.Execute() as IRecordset;
// Console.WriteLine("Get record count: {0}", recList.RecordCount);
recList.First();
object specColumnValue;
List <string> TestSetNameList = new List <string>();
while (!recList.EOR)
{
specColumnValue = recList[TestSetNameField];
if (specColumnValue != null)
{
TestSetNameList.Insert(0, specColumnValue.ToString());
}
recList.Next();
}
return(TestSetNameList);
}
catch (Exception e)
{
AutoLog.Info("AutoIntSys: Exception with " + e.Message);
AutoLog.Info("AutoIntSys: Fail to get Specified Field Value from TEST Table!");
//Debug.Print("AutoIntSys:" + e);
//Debug.Print("AutoIntSys:Fail to get Specified Field Value from TEST Table!");
return(null);
}
}
private TestSetFolder CreateTestSetNames(List <string> TestSetNames, TestSetFolder TSFolder)
{
List <ItemValue> tcList = new List <ItemValue>();
#region Generate TestSet Name
//Get all match test cases and store it to a List
try
{
ICommand com = tdConn.Command as ICommand;
string[] columnName = { "TS_TEST_ID", configFile.CaseFilter.TestSetName };
string sqlCommand = GenerateSQLText(columnName);
com.CommandText = sqlCommand;
IRecordset recList = com.Execute() as IRecordset;
recList.First();
for (int num = 0; num < recList.RecordCount; num++)
{
ItemValue tc = new ItemValue();
tc.Test_ID = recList["TS_TEST_ID"].ToString();
if (recList[configFile.CaseFilter.TestSetName] != null)
{
tc.Test_Custom = recList[configFile.CaseFilter.TestSetName].ToString();
}
tcList.Insert(0, tc);
recList.Next();
}
}
catch (Exception e)
{
AutoLog.Info("AutoIntSys: Exception with " + e.Message);
AutoLog.Info("AutoIntSys: Fail to get Specified Field Value from TEST Table!");
//Debug.Print("AutoIntSys:Fail to get Specified Field Value from TEST Table!");
//Debug.Print("AutoIntSys:" + e);
return(null);
}
#endregion
#region Generate TestSet
try
{
TestSetFactory TSFact = TSFolder.TestSetFactory as TestSetFactory;
TestFactory TestFact = tdConn.TestFactory as TestFactory;
foreach (string TSName in TestSetNames)
{
TestSet TestSetName;
TSTestFactory TSTestFact;
TestSetName = TSFact.AddItem(TSName) as TestSet;
TestSetName.Post();
TSTestFact = TestSetName.TSTestFactory as TSTestFactory;
foreach (ItemValue t in tcList)
{
if (t.Test_Custom == TSName)
{
TSTestFact.AddItem(t.Test_ID);
}
}
}
createTSSucess = true;
return(TSFolder);
}
catch (Exception e)
{
AutoLog.Info("AutoIntSys: Exception with " + e.Message);
AutoLog.Info("AutoIntSys: Create Test Sets Error!");
//Debug.Print("AutoIntSys:Create Test Sets Error!");
//Debug.Print("AutoIntSys:" + e.Message);
return(null);
}
#endregion
}