Navigating cursor rows in SQLite (can we rewind / reset the cursor, for example, return to the first row?)

Question

I am trying to understand how the following built-in functions work in sequential processing of cursor lines. Description taken from Python 3.1 manual (using SQLite3)

Cursor.fetchone()

Selects the next row of the query result set, returning one sequence.

Cursor.fetchmany()

Selects the next set of rows of the query result, returning a list.

Cursor.fetchall()

Selects all (the rest) rows of the query result, returning a list.

So, if I have a loop in which I process one line at a time using cursor.fetchone (), and for some later code, I need to go back to the first line or retrieve all the lines using fetchall (), like this do i do it?

, , Foxpro, , 1- (/) n- (go n)

.

Answer 1

SQLite Python 3.1 PEP 249, , . . , , , . ( fetchall). , .

API , , . :

for a,b,c in cursor.fetchone():
    # process it

, . , , , , , , - . , , .