Forum Discussion

dwong_smartbear's avatar
dwong_smartbear
Occasional Contributor
7 years ago

Python - Using ADO and RecordSet in testcomplete scripts

Two questions I have regarding the ADO interface with Python:   1. When I do: rec_set = conn.Execute_("SELECT A, B FROM C WHERE D='E") ... there's no problem, but if I do:   rec_set = conn.Exec...
  • cunderw's avatar
    cunderw
    7 years ago

    Here is an approach I used for something similar. It basically will take a record set and build an array of objects with their properties being the column names / values. It's javascript, but shouldn't be hard to do a similar approach in python. 

     

    function recordToObjectArray(rec) {
  let retVal = [];
  try {
   while(!rec.EOF) {
      let currObj = {};
      for(var i = 0; i < rec.Fields.Count; i++) {
        currObj[rec.Fields.Item(i).Name] = rec.Fields.Item(i).Value;        
      }
      retVal.push(currObj);
      rec.MoveNext();
    }
  } catch(err) {
    Log.Warning("There was an error building object. See additional information", err.message + "\n" + err.stack);
  } finally {
    return retVal;
  }
}
dwong_smartbear's avatar
dwong_smartbear
Occasional Contributor

Hi tristaanogre thanks for your reply.

Yes I noticed all the examples I see are of this flavor (using my example):

 

rec_set = conn.Execute_("SELECT * FROM C WHERE D='E'")
rec_set.MoveFirst()
while not rec_set.EOF:
  Log.Message(rec_set.Fields.Item["A"].Value, rec_set.Fields.Item["B"].Value)
  rec_set.MoveNext()

 

But what if I don't want just the values for columns "A" and "B", but for all the columns.  Also, I'm still having trouble with the "SELECT *...." statement, which is strange.

cunderw's avatar
cunderw
Community Hero
7 years ago

Here is an approach I used for something similar. It basically will take a record set and build an array of objects with their properties being the column names / values. It's javascript, but shouldn't be hard to do a similar approach in python. 

 

function recordToObjectArray(rec) {
  let retVal = [];
  try {
   while(!rec.EOF) {
      let currObj = {};
      for(var i = 0; i < rec.Fields.Count; i++) {
        currObj[rec.Fields.Item(i).Name] = rec.Fields.Item(i).Value;        
      }
      retVal.push(currObj);
      rec.MoveNext();
    }
  } catch(err) {
    Log.Warning("There was an error building object. See additional information", err.message + "\n" + err.stack);
  } finally {
    return retVal;
  }
}
  • dwong_smartbear's avatar
    dwong_smartbear
    Occasional Contributor
    7 years ago

    cunderw thanks! that was the solution.  Just for completeness this is translation in Python:

     

      l_recset = []
  rec_set.MoveFirst()
  while not rec_set.EOF:
    d_row = {}
    for i in range(rec_set.Fields.Count):
      d_row[rec_set.Fields.Item[i].Name] = rec_set.Fields.Item[i].Value
    l_recset.append(d_row)
    rec_set.MoveNext()