Skip to content

Instantly share code, notes, and snippets.

@stefanjenkner
Created May 1, 2014 19:04
Show Gist options
  • Save stefanjenkner/19391359f6c0e4baf8ed to your computer and use it in GitHub Desktop.
Save stefanjenkner/19391359f6c0e4baf8ed to your computer and use it in GitHub Desktop.
#!/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()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment