Simple query fails if no rows found

[borislopezaraoz]

Most simple example from docs:

for row in session.query('SELECT * FROM foo'):
    print row

Fails when there are no rows in the table:

Traceback (most recent call last):
  File "venv/lib/python3.9/site-packages/queries/results.py", line 45, in __iter__
    raise StopIteration
StopIteration

Expected result: for loop should just pass without errors

[ljluestc]

To avoid the StopIteration exception and have the loop pass without errors, you can use the fetchall() method to retrieve all rows from the query result and then iterate over the returned list. This way, the loop will simply pass through when there are no rows.

Here's an example of how you can modify your code:

result = session.query('SELECT * FROM foo').fetchall()

for row in result:
    print(row)

By using fetchall(), you retrieve the entire result set as a list of rows. Now, even if the list is empty, the loop will not raise any exceptions and will simply pass without printing anything.