How to Write TestComplete Test Results to SQL Server

Essentially what I've done is set up event handlers for OnStopTest and OnStartTest.  I'll post examples of what those are below.  We have a database for software testing that contains a TestStatus table that has information about the project and test item,
the time it started and stopped, a status (error, warning, running, ok,
etc), the last error that occurred, and a pointer to a log file of the
run.  OnStartTest I insert a placeholder row into the TestStatus table (via a stored procedure) and then I update the same row in the OnStopTest event. 



We wrote a view that brings up the latest results for all our tests.  You can dump the results of that view into anything, a web page, an email, etc. and see a snapshot of the latest test results.



Here are the OnStartTest and OnStopTest events.  stDB is an instance of a database helper object I wrote that allows you to execute sql or stored procedures against a SQL Server database.



function GeneralEvents_OnStartTest(Sender)

{

  //leave if we're not running in a test item

  if (NotRunningInTestItem()) return;

 

  errors = []; //clear the errors array

  warnings = []; //clear the warnings array

  currentErrorCount = Log.ErrCount;

 

  if (Project.TestItems.Current.Name == GetFirstEnabledTestItemName())

  {

    //first test item in the run--do things that need to be done to prepare the test

    OnBeginTesting();  

  }

  //Log the start to the database

  var aParamArray = new Array();

  aParamArray.push(["TestSectionName", GetProjectName() + "_" + Project.TestItems.Current.Name]);

  aParamArray.push(["TestStatusDesc", "Running"]);

  stDB.ExecuteStoredProc("InsertTestSectionStatus",aParamArray);

 

  //Set the indicator and create a folder

  Indicator.Clear();

  Indicator.PushText(Project.TestItems.Current.Name);

//  Log.PushLogFolder(Log.CreateFolder(Project.TestItems.Current.Name));

}



function GeneralEvents_OnStopTest(Sender)

{

  //This is here to avoid logging/deleting backup files etc, if we're running something

  //outside a test item (ie. rightclick|Run Current Routine)

  if (NotRunningInTestItem()) return;



  //Save the log file for the current test item

  var linkToLog = SaveLog();



  //Save the results to the SoftwareTesting database

  var aParamArray = new Array();

  aParamArray.push(["TestSectionName", GetProjectName() + "_" + Project.TestItems.Current.Name]);

  aParamArray.push(["TestStatusDesc",  GetTestStatus()]);

  aParamArray.push(["TestStatusComments", GetTestStatusComment()]);   

  aParamArray.push(["TestLogPath", linkToLog]);    

  stDB.ExecuteStoredProc("CompleteTestSectionStatus",aParamArray);

 

  //If this was the last test, perform end of test tasks

  if (Project.TestItems.Current.Name == GetLastEnabledTestItemName())

  {

    OnEndTesting();

  }



  Indicator.PopText();

}