gistfile1.py

#!/usr/bin/env python

import xmlrpclib
import getpass
import argparse
import datetime
import sys
import sqlite3

TIMESHEET_DB='/Users/stefan/Documents/Timesheet.db'

def main():

    now = str(datetime.datetime.now().date())

    parser = argparse.ArgumentParser(prog="timesheet_add", description='Timesheet Filler')

    parser.add_argument('-t', '--task', dest='task', metavar='TASK',
            help='Task', required=True)
    parser.add_argument('-m', '--minutes', dest='minutes', metavar='MINUTES',
            help='Minutes', required=True)

    args = parser.parse_args()

    conn = sqlite3.connect(TIMESHEET_DB)
    c = conn.cursor()

    c.execute("""CREATE TABLE IF NOT EXISTS activities
            (day text, activity text, minutes text, added timestamp)""")

    task = str.replace(args.task, '\'', '\'\'')
    minutes = args.minutes

    c.execute("INSERT INTO activities VALUES ('%s','%s','%s', '%s')" % (
        now, task, minutes, datetime.datetime.now()))

    conn.commit()
    conn.close()


if __name__ == '__main__':
    main()