piasek
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Return general SQL Query results
Hi, I am trying to create a few methods handling my DB connection. What I need is a simple: SELECT * FROM TABLE result. The only help I could find is some CreateADOquery method, which seems to be very awkward to use, as all the examples include addressing specific columns. And I don't want to do that. w.SQL = "SELECT VendorName FROM Vendors WHERE State = :Param_State" w.Open() w.First() while not w.EOF: Log.Message(w.FieldByName("VendorName").AsString) w.Next() The above example would be just right, except it requires FieldByName() method. What I am trying to get is query result as list of strings or array of strings. The code is being developed in Python.892Views0likes2CommentsMS SQL database querying. How?
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 class599Views0likes0Comments