How to call queryAll method

Question

I was going through the instructions specified under SQL statements, and I got stuck at this line:

rows = connection.queryAll(query)

From where are we getting this connection object? Because I am sure this is not the object obtained from this statement

connection = connectionForURI(connection_string)

I also tried using dbconnection like this:

select = Select(['name', 'AVG(salary)'], staticTables=['employees'], groupBy='name')
query = dbconnection.sqlrepr(select)

But dbconnection doesn't have queryAll method.

The example uses a wildcard import "from sqlobject.sqlbuilder import *". You can check if connection object is among the imports with "print locals()". — postoronnim, Mar 16 '17 at 16:26
Well no luck, it isn't listed on running print(locals()) with this import — Kaushik Shrestha, Mar 16 '17 at 22:35

score 0 · Answer 1 · answered May 07 '17 at 16:09

0

connection = connectionForURI(connection_string) is exactly the connection object you're looking for. It has method queryAll.

answered May 07 '17 at 16:09

phd

1 Answers1