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;
  }
}
NisHera's avatar
NisHera
Valued Contributor
7 years ago

1) I'm not sure why you get this .......I think if works in first should work for second

Are you sure the connection is Open? or no other problems in your SQL statement ? 

I can see first statement has 'E  and second has 'E' ...............  note single quote open in first and close in second

 

2) Haven tried dealing with record set in python but in j Script go like this 

RecSet.MoveFirst();
    while (! RecSet.EOF )
    {
      Log.Message(RecSet.Fields("Emp ID").Value, RecSet.Fields("Name").Value);
      RecSet.MoveNext();
    }

Emp ID and Name are SQL fields.......

MoveFIRST (),  MoveNext () and EOF are recset operations so you only have to convert while loop to python. 

remember.............!  keep open connection and close after you finish.

  • dwong_smartbear's avatar
    dwong_smartbear
    Occasional Contributor
    7 years ago

    Thanks NisHera I saw this example as well.  However what I was looking for was an iterative way of getting the values.  In this example, "Emp ID" and "Name" are hardcoded, but what if I have a record that has about 100 columns and I want to print all the values of each column?

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      7 years ago
      dwong_smartbear wrote:

      Thanks NisHera I saw this example as well.  However what I was looking for was an iterative way of getting the values.  In this example, "Emp ID" and "Name" are hardcoded, but what if I have a record that has about 100 columns and I want to print all the values of each column?

      Reference cunderw's example... note the for loop... that's how you do it.