#!/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
     import sys
     
     db_filename = 'todo.db'
     
     sql = "select id, details, deadline from task"
     
     def show_deadline(conn):
         conn.row_factory = sqlite3.Row
         cursor = conn.cursor()
         cursor.execute(sql)
         row = cursor.fetchone()
         for col in ['id', 'details', 'deadline']:
             print '  column:', col
             print '    value :', row[col]
             print '    type  :', type(row[col])
         return
     
     print 'Without type detection:'
     
     with sqlite3.connect(db_filename) as conn:
         show_deadline(conn)
     
     print '\nWith type detection:'
     
     with sqlite3.connect(db_filename, detect_types=sqlite3.PARSE_DECLTYPES) as conn:
         show_deadline(conn)