def main(global_config, **settings): """ This function returns a Pyramid WSGI application. """ set_cache_regions_from_settings(settings) authentication_policy = AuthTktAuthenticationPolicy('seekrit', callback=groupfinder) authorization_policy = ACLAuthorizationPolicy() config = Configurator(settings=settings, root_factory=RootFactory, authentication_policy=authentication_policy, authorization_policy=authorization_policy) engine = engine_from_config(settings, 'sqlalchemy.') DBSession.configure(bind=engine) Base.metadata.bind = engine config.set_session_factory(session_factory_from_settings(settings)) config.add_mako_renderer('.html') json_renderer = JSON() def datetime_adapter(obj, request): return obj.isoformat() json_renderer.add_adapter(datetime.datetime, datetime_adapter) config.add_renderer('json', json_renderer) # Add static routes (required for static_path in Mako) config.add_static_view(name=settings.get('webassets.base_url'), path='static') config.include(include_views) config.include(include_css) config.include(include_js) config.scan() return config.make_wsgi_app()
def remove_rental(self): id_ = self.request.matchdict.get('id') data = DBSession.query(Stuff).filter(Stuff.id == id_).first() if data: if data.rent: data.rent = False data.rent_by = None data.rent_date = None return dict()
def home(self): date = datetime.now().strftime('%d-%m-%Y') weekday = datetime.now().today().weekday() item = DBSession.query(Test).filter(Test.id == weekday).first() return dict(date=date, openHour=item.openHour, closeHour=item.closeHour, rOpenHour=item.rOpenHour, rCloseHour=item.rCloseHour)
def add_rental(self): request = self.request rent_by = request.params['rent_by'] rent_date = request.params['rent_date'] id_ = self.request.matchdict.get('id') #rent_by = "TEST" #rent_date = datetime.now().strftime('%Y-%m-%d') data = DBSession.query(Stuff).filter(Stuff.id == id_).first() if data: data.rent = True data.rent_by = rent_by data.rent_date = rent_date return dict()
def login(self): request = self.request login = '' password = '' if 'form.submitted' in request.params: login = request.params['login'] password = request.params['password'] user = DBSession.query(Users).filter(Users.login == login).filter( Users.password == password).first() if user: session = request.session session['logged'] = 'yes' session['group'] = user.group headers = remember(request, login) return HTTPFound(location=request.route_url('home'), headers=headers) return dict( url=request.route_url('login'), login=login, password=password, )
def rental(self): data = DBSession.query(Stuff).all() return dict(data=data)