def listTask(self):
taskList = []
db = DB()
tasks = db.selectTask()
for i in range(0, len(tasks)):
cd = datetime.strptime(tasks[i][1], '%Y-%m-%d %H:%M:%S.%f') # To datetime
dl = datetime.strptime(tasks[i][4], '%Y-%m-%d %H:%M:%S.%f')
t = Task(tasks[i][2], tasks[i][3], dl, tasks[i][5])
t.set_idTask(int(tasks[i][0]))
t.set_creationDate(cd)
t.set_done(int(tasks[i][6]))
t.set_weight()
taskList.append(t)
return taskList
def createTask(self, description, workload, deadline, priority):
db = DB()
# Instancia objeto passando os parametros
task = Task(description, workload, deadline, priority)
# Procura max idTask do Banco
task_counter = db.selectIdTask()
if(task_counter is None):
idTask = 0
else:
idTask = task_counter+1
# Salva idTask na Task instanciada
task.set_idTask(idTask)
# Adiciona numa lista de Tasks
self.taskList.append(task)
# Salvar task no Banco de Dados...
db.insertTask(task.get_idTask(), task.get_creationDate(), description, workload, deadline, priority, task.get_done(), task.get_weight())
