Accessing LoadRunner Analysis Repository with Python ADO

From PeformIQ Upgrade
Revision as of 17:03, 24 May 2008 by PeterHarding (talk | contribs) (New page: <pre> 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")...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


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))