Accessing LoadRunner Analysis Repository with Python ADO - Revision history

PeterHarding at 06:35, 24 September 2014

2014-09-24T06:35:38Z

← Older revision		Revision as of 16:35, 24 September 2014
Line 1:		Line 1:
	<pre>		<pre>


	import time		import time
	import win32com.client		import win32com.client

PeterHarding at 06:35, 24 September 2014

2014-09-24T06:35:30Z

← Older revision		Revision as of 16:35, 24 September 2014
Line 6:		Line 6:

	engine = engine = win32com.client.Dispatch("DAO.DBEngine.36")		engine = engine = win32com.client.Dispatch("DAO.DBEngine.36")

	db = engine.OpenDatabase(r"c:\lr\py\analysis.mdb")		db = engine.OpenDatabase(r"c:\lr\py\analysis.mdb")

	rs = db.OpenRecordset("Result")		rs = db.OpenRecordset("Result")

Line 23:		Line 25:
	print "Start Time: %s " % time.asctime(time.localtime(startTime))		print "Start Time: %s " % time.asctime(time.localtime(startTime))
	print " End Time: %s " % time.asctime(time.localtime(endTime))		print " End Time: %s " % time.asctime(time.localtime(endTime))





	</pre>		</pre>

PeterHarding at 06:04, 19 July 2009

2009-07-19T06:04:53Z

← Older revision		Revision as of 16:04, 19 July 2009
Line 31:		Line 31:

	[[Category:Python]]		[[Category:Python]]
			[[Category:Examples]]
	[[Category:LoadRunner]]		[[Category:LoadRunner]]

PeterHarding: New page:

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

2008-05-24T07:03:07Z

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

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

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

</pre>

[[Category:Python]]
[[Category:LoadRunner]]