how to use Queryresult variable as input in other query in robot framework

Question

I am doing 1 simple db connection test in Robot framework.I am doing as following-

${queryResults1}  Query  <sql query>

now I want to use the value of ${queryResults1} as input to another query. I am doing

Execute Sql String   select * from customer where customer_id=${queryResults1}

here I am getting error .Execute Sql String doesnot get value of queryresult

how can I do this ?

thanks in Advance!!!

please show the actual error. You also need to show what the first query is.Are you fetching a whole row? Multiple rows? A single column from a single row? — Bryan Oakley
– Bryan Oakley, Commented Oct 27, 2015 at 14:12
I am fetching 1 single value/column in first query as below:- Select customer_id from device where macadress='<macaddress>' it returns 1 single value. and the error is - 20151027 21:32:20.153 : FAIL : DatabaseError: ORA-00936: missing expression — smiles
– smiles, Commented Oct 27, 2015 at 16:04
have you verified that ${queryResults}` is what you expect it to be? — Bryan Oakley
– Bryan Oakley, Commented Oct 27, 2015 at 16:08
log ${QueryResults} is returning me [(629351,)] but when I logged ${queryResults[0][0]} ,I got the correct value 629351. — smiles
– smiles, Commented Oct 27, 2015 at 16:31
Have you tried using ${queryResults[0][0]} in your second query? — Bryan Oakley
– Bryan Oakley, Commented Oct 27, 2015 at 16:59

Bryan Oakley · Accepted Answer · 2015-10-27 17:01:07Z

1

The problem is that your first query is returning a list of tuples -- a list of rows, each of which is a tuple of columns. Even though you're apparently expecting a single value from a single column in a single row, the data is still in this format. You need to pull the value out of that list of tuples before passing it to your second query.

For example:

Execute Sql String   select * from customer where customer_id=${queryResults1[0][0]}

answered Oct 27, 2015 at 17:01

Bryan Oakley

389k53 gold badges582 silver badges739 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

smiles Over a year ago

Thanks Bryan.I am new to Robotframework so I am getting stuck almost everytime I use a key :)

Collectives™ on Stack Overflow

how to use Queryresult variable as input in other query in robot framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related