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())