Accessing query results
After querying the 1010data Insights Platform, your application receives a set of
results, which is accessible through the Query
object.
After the query is run, the Query
object is the results of the query. Your
results are a set of Column
objects. Column
objects
contain the values in the column as a list that can be iterated over and indexed.
This example uses the row iterator exampleQuery.rows
to print each row in the
results. You can access an individual row by specifying an index (e.g.,
exampleQuery.rows[100]
).
import py1010 import sys gateway = "https://www2.1010data.com/cgi-bin/gw" tablename = "pub.demo.weather.stations" username = "[USER_NAME]" password = "[PASSWORD]" testSession = py1010.Session(gateway, username, password, py1010.POSSESS) exampleQuery = testSession.query(tablename, '<sel value="(elev>10)"/>') exampleQuery.run() for r in exampleQuery.rows: print("\t".join([str(x) for x in r]))
Note:
[USER_NAME]
and [PASSWORD]
are
placeholders for valid Insights Platform user name and password.