How to store a result of SQL query as String in python

Question

I am using Robot framework in python and I am running below query:

${queryResults1}=  query  select count(*) from table

It gives me below result:

${queryResults2} = [(91,)]

How to convert above result as String?

Todor Minakov · Accepted Answer · 2020-04-26 18:16:48Z

2

The response format is a list of tuples - as can also be seen by the sample you've pasted. Thus get the 1st column of the first row (in python/Robot Framework the lists are 0-based), and pass that to Convert To String:

${the value as string}=    Convert To String    ${queryResults1[0][0]}

answered Apr 26, 2020 at 18:16

Todor Minakov

20.2k3 gold badges61 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

How to store a result of SQL query as String in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related