Python query SQlite database example

In this example we use the database we created in the create database example and we will simply display all rows in the database

[codesyntax lang=”python”]

#!/usr/bin/python

import sqlite3 as lite
import sys


con = lite.connect('test.db')

with con: 

cur = con.cursor() 
cur.execute("SELECT * FROM Jobs")

rows = cur.fetchall()

for row in rows:
print (row)

[/codesyntax]