def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from projetoredesmultimidia.domain.models import ( Base, MyModel, ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: model = MyModel(name='one', value=55) DBSession.add(model)
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 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()