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)