New parameter for sqlQuery()

[pranavrd]

trafficstars

A select query fetches only up to a 1000 records. Can this be modified to fetch r number of records? For e.g.: results = client.sqlQuery(queryStr,r=100000)

[Razikus]

Hi. Currently you have to ensure to chunk your response per 1000 entries.

You should provide some PRIMARY KEY, like ID INTEGER AUTO_INCREMENT then query it like this

SELECT id, something FROM XXX WHERE ID > @lastId LIMIT 1000

Then make assigment lastId = result[-1][0]