How to OUTPUT all rows from a sqlite database in python?

Question

Python

Hello.
The task is to display all rows from the sqlite database.

conn = sqlite3.connect('D:/squadybot.sqlite')
cur = conn.cursor()
cur.execute("SELECT * FROM tasks")
row = cur.fetchone()

But the object

row

contains only the first line. How to get everything out?

Answer 1

It is obvious to use the correct method - fetchall()
https://habrahabr.ru/post/321510/