def grant_permission(self, id): """Grant a permission to a user.""" permission = Permission.query.filter_by(id=id).first() if permission and permission in permissions: return with transaction.manager: if not permission: permission = Permission() permission.id = id DBSession.add(permission) permissions.append(permission)
def main(argv=sys.argv): if len(argv) != 2: usage(argv) config_uri = argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: admin = User(name=u'admin', password=u'admin') DBSession.add(admin)
def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from pyramidapp.models import ( Base, User, ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: admin = User(name=u'admin', password=u'admin') DBSession.add(admin)