Hi,
I am new to TC and have serious problem with getting data from the database. We use SQL Server and develop our tests in Python, so I would be looking for a Python solution if possible. What I exactly need is simple getting simple select result like in:
sqlQuery = "select * from company where name= '" + companyName + "'"
The goal i to create a simple data access class, that will have a few methods, that take such query as argument and return result (handling opening and closing the connection in the process)
So far I have come up with something like that, but this works only for select count(*) from... query:
class DbHelper:
def __init__(self):
self.serv = Project.Variables.dbServer
def selectCountResult(self, sqlQuery):
query = ADO.CreateADOQuery()
query.ConnectionString = "DRIVER={SQL SERVER};SERVER=%s;DATABASE=4TransMDF;" % (self.serv)
query.SQL = sqlQuery
query.Open()
result = query.RecordCount
query.Close()
return result
#end class
