Accessing LoadRunner Analysis Repository with Python ADO
Revision as of 17:35, 24 September 2014 by PeterHarding (talk | contribs)
import time import win32com.client engine = engine = win32com.client.Dispatch("DAO.DBEngine.36") db = engine.OpenDatabase(r"c:\lr\py\analysis.mdb") rs = db.OpenRecordset("Result") while not rs.EOF: scenario = rs.Fields("Scenario Name").Value name = rs.Fields("Result Name").Value tz = rs.Fields("Time Zone").Value / 3600 startTime = rs.Fields("Start Time").Value endTime = rs.Fields("Result End Time").Value rs.MoveNext() print print " Scenario: %s " % scenario print " Run ID: %s " % name print " TZ: %s " % tz print "Start Time: %s " % time.asctime(time.localtime(startTime)) print " End Time: %s " % time.asctime(time.localtime(endTime))