#!/usr/bin/env python
     # encoding: utf-8
     #
     # Copyright (c) 2010 Doug Hellmann.  All rights reserved.
     #
     """Update the status of a task
     """
     #end_pymotw_header
     
     import sqlite3
     import sys
     
     db_filename = 'todo.db'
     id = int(sys.argv[1])
     status = sys.argv[2]
     
     with sqlite3.connect(db_filename) as conn:
         cursor = conn.cursor()
         query = "update task set status = :status where id = :id"
         cursor.execute(query, {'status':status, 'id':id})