gistfile1.txt

    def take_action(self, parsed_args):
        tasks = (models.Task.query
                        .join(models.Play)
                        .join(models.Playbook)
                        .filter(models.Task.playbook_id == models.Playbook.id)
                        .filter(models.Task.play_id == models.Play.id))

        return (('ID', 'Name', 'Path', 'Playbook', 'Play', 'Action', 'Line', 'Handler', 'Time Start', 'Time End'),
                [(task.id,
                  task.name,
                  task.path,
                  task.playbook.path,
                  task.play.name,
                  task.action,
                  task.lineno,
                  task.is_handler,
                  task.time_start,
                  task.time_end
                )
                for task in tasks])