you execute .fetchone() on the cursor. It will return either a row tuple, or None if there are no more rows.
>-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mark Halegua >Sent: Wednesday, 27 August, 2014 07:51 >To: sqlite-users@sqlite.org >Subject: [sqlite] how best to determine # of rows in a table > >this may seem like a small issue, but I'm not sure if the solutions I've >found >on the web will do what I want in a low memory situation.I'd like to >iterate >through a table one row at a time. I can do that in pysqlite, but I >don't see >a method for determining I'm at the end of the file > >Can anyone point me in the correct direction? Again, it's a low memory >solution the the table could become quite large, so I don't want to load >the >whole thing with a teychall() call, and I'm not sure if a cursor won't >take >up too much memory as well. > >Thanks, > >Mark > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
