#!/usr/bin/env python # encoding: utf-8 # # Copyright (c) 2010 Doug Hellmann. All rights reserved. # """Query tasks in the database. """ #end_pymotw_header import sqlite3 db_filename = 'todo.db' with sqlite3.connect(db_filename) as conn: cursor = conn.cursor() cursor.execute(""" select id, priority, details, status, deadline from task where project = 'pymotw' """) for row in cursor.fetchall(): task_id, priority, details, status, deadline = row print '%2d {%d} %-20s [%-8s] (%s)' % (task_id, priority, details, status, deadline)