db_tests.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3 as lite
import sys

con = lite.connect('db.sqlite3')
cur = con.cursor()    
cur.execute("SELECT * FROM users;")
rows = cur.fetchall()
for row in rows:
    print row




con.close()