def getDefault(self, query=None):
if auth.get_login() != None:
usr = data.User.get_by_login(cherrypy.request.db, auth.get_login())
return usr.e_mail
else:
return Text.getDefault(self, query=None)
def getDefault(self, query=None):
if auth.get_login()!=None:
usr=data.User.get_by_login(cherrypy.request.db, auth.get_login())
return usr.e_mail
else:
return Text.getDefault(self, query=None)
def index(self, **kwargs):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
# entities=session.query(self.report_class)
entities = data.get_allowed_entities(session, self.report_class, user,
('REPORTS', ))
reportsettings = session.query(self.reportsetting_class).filter(
self.reportsetting_class.user == user)
settings = {}
for ent in entities:
settings[ent.id] = {}
for t in self.reportsetting_class.types:
settings[ent.id][t] = (report_frequencies[0], None)
for rs in reportsettings:
ent_id = getattr(rs, self.id_column)
settings[ent_id][rs.report_type] = (rs.frequency, rs.last)
return render(self.template,
entities=entities,
settings=settings,
frequencies=report_frequencies,
types_dict=self.reportsetting_class.types,
**kwargs)
def set_report_freq(reportsetting_class, report_type, report_frequency, report_list=None, ent_id=None):
session=cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
query = session.query(reportsetting_class).filter(reportsetting_class.user == user).filter(reportsetting_class.report_type == report_type)
add_args = {}
if report_list is not None:
ent = data.get_by_id(session, report_list.report_class, ent_id)
query = query.with_parent(ent)
add_args[report_list.id_column] = ent.id
if login != 'admin':
acl = ent.acls.filter(data.ACL.userrole_id == user.role.id, data.ACL.privilege == 'REPORTS').one()
add_args['acl_id'] = acl.id
setting = query.first()
if setting is None:
setting = reportsetting_class(user=user, report_type=report_type, frequency=report_frequency, **add_args)
session.add(setting)
setting.frequency = report_frequency
session.commit()
def index(self):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
apps = data.Application.get_allowed_apps(session, user,
('VIEW', 'ADMIN'))
root = cherrypy.tree.apps[config.root].root
def loaded(app):
return app.id in root.apps
view_allowed = {}
admin_allowed = {}
for app in apps:
admin_allowed[app.id] = auth.ForceLogin.match_acl(
app.get_acl('ADMIN'), login)
view_allowed[app.id] = auth.ForceLogin.match_acl(
app.get_acl('VIEW'), login)
return render('system/admin/apps.genshi',
apps=apps,
loaded_test=loaded,
admin=(login == 'admin'),
view_allowed=view_allowed,
admin_allowed=admin_allowed)
def index(self, p=1, **kwargs):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
q = data.Request.get_allowed_requests(session, user, ('VIEW', 'ADMIN'))
apps = data.Application.get_allowed_apps(session, user,
('VIEW', 'ADMIN'))
view_allowed = {}
admin_allowed = {}
for app in apps:
admin_allowed[app.id] = auth.ForceLogin.match_acl(
app.get_acl('ADMIN'), login)
view_allowed[app.id] = auth.ForceLogin.match_acl(
app.get_acl('VIEW'), login)
return render_query_paged('system/admin/requests.genshi',
q,
int(p),
'requests',
config.root + "/admin/requests/",
kwargs,
view_allowed=view_allowed,
admin_allowed=admin_allowed)
def processTemplate(self,file, args, type='xhtml'):
if type=='xhtml':
tmplt=self.templateLoader.load(file)
elif type=='text':
tmplt=self.templateLoader.load(file, cls=NewTextTemplate)
try:
args.mailto=webhelpers.html.tools.mail_to(config.get('Mail', 'admin_email'), unicode(config.get('Mail', 'admin_name'),"UTF-8"), encode="hex")
except:
pass
try:
args.e_mail=config.get('Mail', 'admin_email')
except:
pass
try:
args.server=config.get('Server', 'name')
except:
pass
try:
args.address=config.server_url
except:
pass
try:
args.css=config.get('Server', 'css_url')
except:
pass
try:
args.media=config.root + '/media'
except:
pass
try:
args.root=config.root
except:
pass
try:
tmp = cherrypy.request.db
except:
pass
else:
if tmp is not None:
args.navigation_bar = util.get_WeBIAS().navigation_bar()
else:
args.navigation_bar = []
args.base = self.base_filename()
# args.template_base = config.server_dir + '/templates'
args.login=auth.get_login()
stream = tmplt.generate(**args.__dict__)
return stream.render(type, encoding='UTF-8')
def get_req(self, req_uuid):
session=cherrypy.request.db
req=data.Request.get_request(session, req_uuid)
login=auth.get_login()
user=data.User.get_by_login(session,login)
return req
def stats(self):
if auth.get_login()!='admin':
return ''
session=cherrypy.request.db
sub = data.Hit.session_query(session).subquery()
# sub=session.query(data.Hit.session, sqlalchemy.func.count(data.Hit.id).label('num_hits'), sqlalchemy.func.sum(sqlalchemy.sql.expression.cast(data.Hit.req_sub, sqlalchemy.types.Integer), type_=self.CoerceToInt).label('num_reqs')).group_by(data.Hit.session, data.Hit.ip_address).subquery()
q=session.query(sqlalchemy.func.sum(sub.c.num_hits), sqlalchemy.func.count(sub.c.session), sqlalchemy.func.sum(sub.c.num_reqs))
stats=q.one()
return render('system/statistics/sessions_stats.genshi', num_hits=stats[0], num_sessions=stats[1], num_reqs=stats[2])
def index(self, p=1, **kwargs):
session=cherrypy.request.db
login=auth.get_login()
user=data.User.get_by_login(session,login)
q=data.Request.get_allowed_requests(session, user, ('VIEW', 'ADMIN'))
apps=data.Application.get_allowed_apps(session, user, ('VIEW', 'ADMIN'))
view_allowed={}
admin_allowed={}
for app in apps:
admin_allowed[app.id] = auth.ForceLogin.match_acl(app.get_acl('ADMIN'), login)
view_allowed[app.id] = auth.ForceLogin.match_acl(app.get_acl('VIEW'), login)
return render_query_paged('system/admin/requests.genshi', q, int(p), 'requests', config.root+"/admin/requests/", kwargs, view_allowed=view_allowed, admin_allowed=admin_allowed)
def index(self):
session=cherrypy.request.db
login=auth.get_login()
user=data.User.get_by_login(session,login)
schedulers=data.Scheduler.get_allowed_scheds(session, user, ('VIEW', 'ADMIN'))
view_allowed={}
admin_allowed={}
for sched in schedulers:
admin_allowed[sched.id] = auth.ForceLogin.match_acl(sched.get_acl('ADMIN'), login)
view_allowed[sched.id] = auth.ForceLogin.match_acl(sched.get_acl('VIEW'), login)
return render('system/admin/schedulers.genshi', schedulers=schedulers, admin= (login == 'admin'), view_allowed=view_allowed, admin_allowed=admin_allowed)
def index(self):
def sort_key(t):
try:
return t[1]._order
except AttributeError:
return t[1]._title
def matches_login(t):
acl = auth.safe_get_acl(t[1])
return auth.ForceLogin.match_acl(acl, login)
login = auth.get_login()
features = filter(matches_login, self.get_features().items())
features.sort(key=sort_key)
return render('system/feature_list.genshi', features=features, title=self._title)
def index(self):
session=cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
reportsettings = session.query(self.reportsetting_class).filter(self.reportsetting_class.user == user)
settings = {}
for t in self.reportsetting_class.types:
settings[t] = (report_frequencies[0], None)
for rs in reportsettings:
settings[rs.report_type] = (rs.frequency, rs.last)
return render('system/reports/server.genshi', settings=settings, frequencies=report_frequencies, types_dict=self.reportsetting_class.types)
def error_recorder(hit_id=None):
session=cherrypy.request.db
engine=None
if session==None:
engine= sqlalchemy.create_engine(config.get('Database', 'db_url'), echo=False)
engine.connect();
Session=sqlalchemy.orm.sessionmaker(bind=engine)
session=Session()
login=auth.get_login()
if cherrypy.response.status==None:
status='500 Internal Server Error'
else:
status=cherrypy.response.status
if login!=None:
user=data.User.get_by_login(session, login)
user_id=user.id
else:
user_id=None
date=time.strftime("%Y-%m-%d %H:%M:%S")
ip_address=cherrypy.request.remote.ip
url = cherrypy.url(qs=cherrypy.request.query_string)
headers=["%s: %s"%(k,v) for k,v in cherrypy.request.header_list]
request='\n'.join([cherrypy.request.request_line] + headers)
trace=''.join(traceback.format_exception(*sys.exc_info()))
session_elts=["%s: %s"%(k,v) for k,v in cherrypy.session.items()]
session_dump='\n'.join(["id: %s"%cherrypy.session.id] + session_elts)
error=data.Error(user_id, login, hit_id, date, ip_address, url, status, cherrypy.session.id, trace, request, session_dump)
session.add(error)
if engine!=None:
session.commit()
session.close()
def index(self):
def sort_key(t):
try:
return t[1]._order
except AttributeError:
return t[1]._title
def matches_login(t):
acl = auth.safe_get_acl(t[1])
return auth.ForceLogin.match_acl(acl, login)
login = auth.get_login()
features = filter(matches_login, self.get_features().items())
features.sort(key=sort_key)
return render('system/feature_list.genshi',
features=features,
title=self._title)
def index(self):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
reportsettings = session.query(self.reportsetting_class).filter(
self.reportsetting_class.user == user)
settings = {}
for t in self.reportsetting_class.types:
settings[t] = (report_frequencies[0], None)
for rs in reportsettings:
settings[rs.report_type] = (rs.frequency, rs.last)
return render('system/reports/server.genshi',
settings=settings,
frequencies=report_frequencies,
types_dict=self.reportsetting_class.types)
def index(self, p=1, all=None, **kwargs):
session=cherrypy.request.db
login=auth.get_login()
user=data.User.get_by_login(session,login)
q=session.query(data.Request).with_parent(user)
fb = config.root+'/user/requests/'
all= all!=None
if not all:
q=q.filter(data.Request.starred == True)
if q.count()==0:
raise cherrypy.HTTPRedirect(fb+'?all')
else:
fb=fb+'?all'
return render_query_paged('system/user/requests.genshi', q, int(p), 'requests', fb, kwargs, all=all)
def index(self):
session=cherrypy.request.db
login=auth.get_login()
user=data.User.get_by_login(session,login)
apps=data.Application.get_allowed_apps(session, user, ('VIEW', 'ADMIN'))
root=cherrypy.tree.apps[config.root].root
def loaded(app):
return app.id in root.apps
view_allowed={}
admin_allowed={}
for app in apps:
admin_allowed[app.id] = auth.ForceLogin.match_acl(app.get_acl('ADMIN'), login)
view_allowed[app.id] = auth.ForceLogin.match_acl(app.get_acl('VIEW'), login)
return render('system/admin/apps.genshi', apps=apps, loaded_test=loaded, admin= (login == 'admin'), view_allowed=view_allowed, admin_allowed=admin_allowed)
def index(self, **kwargs):
session=cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
# entities=session.query(self.report_class)
entities=data.get_allowed_entities(session, self.report_class, user, ('REPORTS', ))
reportsettings = session.query(self.reportsetting_class).filter(self.reportsetting_class.user == user)
settings = {}
for ent in entities:
settings[ent.id] = {}
for t in self.reportsetting_class.types:
settings[ent.id][t] = (report_frequencies[0], None)
for rs in reportsettings:
ent_id = getattr(rs, self.id_column)
settings[ent_id][rs.report_type] = (rs.frequency, rs.last)
return render(self.template, entities=entities, settings=settings, frequencies=report_frequencies, types_dict=self.reportsetting_class.types, **kwargs)
def index(self):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
schedulers = data.Scheduler.get_allowed_scheds(session, user,
('VIEW', 'ADMIN'))
view_allowed = {}
admin_allowed = {}
for sched in schedulers:
admin_allowed[sched.id] = auth.ForceLogin.match_acl(
sched.get_acl('ADMIN'), login)
view_allowed[sched.id] = auth.ForceLogin.match_acl(
sched.get_acl('VIEW'), login)
return render('system/admin/schedulers.genshi',
schedulers=schedulers,
admin=(login == 'admin'),
view_allowed=view_allowed,
admin_allowed=admin_allowed)
def hit_recorder():
if sys.exc_info()[0]==cherrypy._cperror.InternalRedirect:
status='XXX Internal redirect'
stat_num=0
elif cherrypy.response.status==None:
status='500 Internal Server Error'
stat_num=500
else:
status=cherrypy.response.status
stat_num=int(status.split(' ')[0])
# try:
# stat_num = int(status)
# except:
# stat_num=int(status.split(' ')[0])
session=cherrypy.request.db
login=auth.get_login()
if login!=None:
user=data.User.get_by_login(session, login)
user_id=user.id
else:
user_id=None
date=time.strftime("%Y-%m-%d %H:%M:%S")
ip_address=cherrypy.request.remote.ip
url = cherrypy.url(qs=cherrypy.request.query_string)
req_sub=getattr(cherrypy.request, 'req_sub', False)
hit=data.Hit(user_id, login, date, ip_address, url, status, cherrypy.session.id, req_sub)
session.add(hit)
session.commit()
if stat_num>400:
error_recorder(hit.id)
def set_report_freq(reportsetting_class,
report_type,
report_frequency,
report_list=None,
ent_id=None):
session = cherrypy.request.db
login = auth.get_login()
user = data.User.get_by_login(session, login)
query = session.query(reportsetting_class).filter(
reportsetting_class.user == user).filter(
reportsetting_class.report_type == report_type)
add_args = {}
if report_list is not None:
ent = data.get_by_id(session, report_list.report_class, ent_id)
query = query.with_parent(ent)
add_args[report_list.id_column] = ent.id
if login != 'admin':
acl = ent.acls.filter(data.ACL.userrole_id == user.role.id,
data.ACL.privilege == 'REPORTS').one()
add_args['acl_id'] = acl.id
setting = query.first()
if setting is None:
setting = reportsetting_class(user=user,
report_type=report_type,
frequency=report_frequency,
**add_args)
session.add(setting)
setting.frequency = report_frequency
session.commit()
def main():
names = get_name()
roles = get_roles()
access = get_login(names, roles)
to_do_something()
def is_available(self):
return self.enabled and auth.ForceLogin().match_acl(self._acl, auth.get_login())
