CODEWITHSUNDEEP
pythonmysqldatabase
user3867078
user3867078

Reputation:

Loop through Mysql Results

This is the code I have:

r = ''
while True:
    data = result.fetch_row()
    r+= record[0][0] + record[0][1] + record[0][0]
print r

What I want to do is, first fetch all the rows:

data = result.fetch_row(0)

and then run a loop for "data"

rather than do it within the while loop.

Upvotes: 1

Views: 5043

Answers (2)

Martijn Pieters
Martijn Pieters

Reputation: 1121834

You can loop over the cursor itself:

for row in result:
    # do something with row

Iteration over cursors is optional in the Python DB-API 2 specification, but in practice all current implementations support it.

This gives the database adapter the freedom to fetch rows from the database server in batches, as needed.

If you do stumble on a database adapter that doesn't support iteration over a cursor, then you can always fall back to cursor.fetch_all():

for row in cursor.fetch_all():
    # do something with row

However, take into account that this'll load the whole result set into a list.

Upvotes: 2

Sid
Sid

Reputation: 7631

What are you using? pyodbc? In most apis you can use fetchall().

See this: pyodbc api and search for fetchall()

Upvotes: -1

Related Questions