def groupfinder(userid, request):
    print("Request do group finder %r: userid: %r" % (request.params, userid))
    user = DBSession.query(Usuario).filter(Usuario.login == userid).first()
    print("USER: %r" % user)
    if user:
        print("Principals %r" % user.principals[0].nome)
        return [principal.nome for principal in user.principals]
    def login(self):
        print("Login")
        print(self.request.params)

        if "login" in self.request.params:
            print("AQUI")
            username = self.request.params["username"]
            senha = self.request.params["senha"]

            usuario = DBSession.query(Usuario).filter(Usuario.login == username).first()
            print(usuario)
            print(username)
            if(usuario):
                ok = usuario.validate_senha(senha)
                if ok:
                    print("Login ok")
                    headers = remember(self.request, username)
                    print("HEADERS %r" % headers)
                    return HTTPFound(location=self.request.route_url("home"), headers=headers)
            msg = "Login Falhou! Usuário e/ou senha inválidos"

            if msg:
                Response(msg, content_type='text/plain', status_int=500)

        return {"msg": "okokokokoko"}
    def create_users_and_principals(self):
        user = DBSession.query(Usuario).filter(Usuario.login == "anderson").first()
        teacher = DBSession.query(Usuario).filter(Usuario.login == "turing").first()
        print(user)
        if not user:
            user = Usuario()
            user.login = "******"
            user.add_senha("123456")
            p = Principal()
            p.nome = "role_user"
            # p.usuarios.append(user)
            user.principals.append(p)

            DBSession.add(p)
            DBSession.add(user)
            transaction.commit()

        if not teacher:
            teacher = Usuario()
            teacher.login = "******"
            teacher.add_senha("science")
            p = Principal()
            p.nome = "role_teacher"
            # p.usuarios.append(user)
            teacher.principals.append(p)

            DBSession.add(p)
            DBSession.add(teacher)
            transaction.commit()

            p = Principal()
            p.nome = "role_user"
            # p.usuarios.append(user)
            teacher.principals.append(p)

            DBSession.add(p)
            DBSession.add(teacher)
            transaction.commit()
    def createObjects(self):
        print("createObjects")
        curso = DBSession.query(Curso).all()
        print(curso)
        if not curso:
            print("aqui")
            curso = Curso()
            curso.nome, curso.dateCreated = "Curso sobre Pyramid Framework", datetime.datetime.now()
            topico1 = Topico()
            topico1.nome = "Introdução"
            subtopico1 = SubTopico()
            subtopico1.nome = "conhecendo o pyramid e o hello world"
            video = Video()
            video.nome, video.path = "hello world", "testeSimpleScreeRecoder-2015-08-31_22.08.41.mp4"
            video.dateCreated = datetime.datetime.now()
            subtopico1.video = video
            topico1.subtopicos.append(subtopico1)
            curso.topicos.append(topico1)
            # DBSession.add(curso)

            topico2 = Topico()
            topico2.nome = "Usando o framework"

            subtopico20 = SubTopico()
            subtopico20.nome = "estrutura de diretótios"
            video = Video()
            video.nome, video.path = "diretorios", "aula2Pyramid-2015-08-16_08.24.29.mp4"
            video.dateCreated = datetime.datetime.now()
            subtopico20.video = video
            topico2.subtopicos.append(subtopico20)

            subtopico21 = SubTopico()
            subtopico21.nome = "estrutura de diretótios(sem audio)"
            video = Video()
            video.nome, video.path = "diretorios(sem audio)", "Aula2Pyramid-2015-08-14_08.13.40.mp4"
            video.dateCreated = datetime.datetime.now()
            subtopico21.video = video
            topico2.subtopicos.append(subtopico21)
            curso.topicos.append(topico2)
            DBSession.add(curso)
            transaction.commit()
 def videoAula(request):
     curso = DBSession.query(Curso).first()
     return {'curso': curso}