Formated by GeSHi
#!/usr/bin/python
# -*- coding: UTF-8 -*-
 
 
###################################
###	TODO srac.. 	v0.0.4				###
###	Abych vedel na co se mam vysrat...		###
###		By C-X         					###
###################################
 
#Tested in python2.5
#This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License (http://creativecommons.org/licenses/by-nc-sa/3.0/).
 
import os, sys, string, sqlite3
from optparse import OptionParser
 
###file
homePATH = os.path.expanduser("~")+'/' # /home/user
DB_FILE = homePATH+'TODO.db'  # DB file
 
 
###Parsing
parser = OptionParser()
 
 
###Options:
parser.add_option("-a", "--add", action="store_true", dest="add", default=False)
parser.add_option("-l", "--list", action="store_true", dest="list", default=False)
parser.add_option("-m", "--alarm", action="store_true", dest="alarm", default=False)
###End of options
 
 
c = sqlite3.connect(DB_FILE)
conn = c.cursor()
 
 
 
def createDBsystem():
	conn.execute("""
	CREATE TABLE task (id INTEGER PRIMARY KEY, task TEXT, deadline TEXT)
	""")#deadline bude typu TIME, ale pozdeji, aby se mohlo checkovat jestli to uz mame delat..
 
try:
	createDBsystem()
except sqlite3.OperationalError:
	pass
 
###Parsing arguments
(options, args) = parser.parse_args()
 
if options.add==True:
	task = raw_input("task: ")
	deadLine = raw_input("Deadline: ") 
 
 
	conn.execute("INSERT INTO task VALUES (NULL, ?, ?)",  (task, deadLine))
	c.commit()
	print("Task was added")
 
 
 
if options.list==True:
	conn.execute("SELECT * FROM task")
	tasky = conn.fetchall()
	if len(tasky)>0:
		for task in tasky:
			print "[", task[0], "] Task:", task[1], "| DeadLine:", task[2]
 
		volby = raw_input("Delete item # (e for exit): ")
 
		if volby.lower() == "e": 
			sys.exit()
		else:
			conn.execute("DELETE FROM task WHERE ID = ?", volby)
			c.commit()
	else:
		print("No tasks were found :'(")
 
 
if options.alarm==True:
	"This is for checking tasks deadline..."
	pass
 
 
 
 
 
 
 
 
 
 
Parsed in 0.057971 seconds