How to print the query result into the console | Robot framework

Question

I have the following code:

*** Test Cases ***
Testing Connect to SQL Server
       ${queryTest}   Execute Sql String     SELECT * FROM users where Id='1'
       #log to console   ${queryTest}   //This print NONE
       #${query_results}   SeleniumLibrary.Get Text  ${queryTest}
       #log to console   ${query_results} 
       #${value}=    Set Variable    ${queryTest[0][0]}
       log to console   ${value} 
       log to console   should display result 
       ${rowCount}=     Row Count   SELECT * FROM users where Id='1'
       log to console   ${rowCount}  
       #rowCount print 1

What I'm trying to do is printing the query's result in the console

What's the outcome of your script? What does it print into console? What errors do you get if any? — pavelsaman
– pavelsaman, Commented Jan 4, 2021 at 11:08
log to console ${queryTest} //This print NONE,, ${output} = Set Variable ${queryTest[1]} log to console ${output} >> This print the following error: Resolving variable '${queryTest[1]}' failed: IndexError: list index out of range,,, and in the report file it shows "@{queryTest} = [ ]" — A.Han
– A.Han, Commented Jan 4, 2021 at 11:12
Is your DB connection created successfully? I don't see any Connect To Database keyword in the script, it might be elsewhere, but it might be wrong, unsuccessful etc. — pavelsaman
– pavelsaman, Commented Jan 4, 2021 at 11:16
the connection is created successfully as I've printed row count as you see in the code ${rowCount}= Row Count SELECT * FROM users log to console ${rowCount} — A.Han
– A.Han, Commented Jan 4, 2021 at 11:18

pavelsaman · Accepted Answer · 2021-01-04 11:41:15Z

3

I think Execute Sql String doesn't return anything. There's no return statement in the method, and documentation doesn't mention such an example either (even though they mention a select statement with this keyword, which might be what leads people to believe they eventually get some rows back).

Try using Query keyword:

@{queryTest}    Query    SELECT * FROM users where Id='1'

edited Jan 4, 2021 at 11:41

answered Jan 4, 2021 at 11:30

pavelsaman

8,4321 gold badge19 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

How to print the query result into the console | Robot framework

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