def _list(session): users = sess.query(Users) q = request.query.q if q: users = users.filter(Users.username.like('%' + q + '%')) users = users.order_by(Users.username) return utils.paged_template('usr.html', _users=users)
def _list(session): users = sess.query(Users) q = request.query.q if q: users = users.filter(Users.username.like('%'+q+'%')) users = users.order_by(Users.username) return utils.paged_template('usr.html', _users=users)
def _show(session, id): rec = sess.query(Records).filter_by(id=id).scalar() if not rec: return 'rec not exist.' reclogs = sess.query(RecordLogs).filter_by(recordid=id).order_by(RecordLogs.time) utils.log(logger, 'view record log list id: %d, start: %s, dest: %s@%s.' % ( rec.id, rec.starttime.strftime('%Y%m%d %H:%M:%S'), rec.account, rec.host)) sess.commit() return utils.paged_template('rec.html', _reclogs=reclogs)
def _list(session): hosts = sess.query(Hosts) q = request.query.q if q: hosts = hosts.filter(or_( Hosts.host.like('%'+q+'%'), Hosts.hostname.like('%'+q+'%'))) hosts = hosts.order_by(Hosts.id) return utils.paged_template('hosts.html', _hosts=hosts)
def _show(session, id): rec = sess.query(Records).filter_by(id=id).scalar() if not rec: return "rec not exist." reclogs = sess.query(RecordLogs).filter_by(recordid=id).order_by(RecordLogs.time) utils.log( logger, "view record log list id: %d, start: %s, dest: %s@%s." % (rec.id, rec.starttime.strftime("%Y%m%d %H:%M:%S"), rec.account, rec.host), ) sess.commit() return utils.paged_template("rec.html", _reclogs=reclogs)
def _list(session): audits = sess.query(AuditLogs) audits = audits.order_by(desc(AuditLogs.id)) utils.log(logger, "view audit list.") sess.commit() return utils.paged_template("adts.html", _audits=audits)
@route("/rec/") @utils.chklogin("audit") def _list(session): recs = sess.query(Records) q = request.query.q if q: try: recs = adv_query(recs, q) except Exception, e: return str(e) recs = recs.order_by(desc(Records.starttime)) utils.log(logger, "view record list.") sess.commit() return utils.paged_template("recs.html", _recs=recs) @route("/rec/<id:int>") @utils.chklogin("audit") def _show(session, id): rec = sess.query(Records).filter_by(id=id).scalar() if not rec: return "rec not exist." reclogs = sess.query(RecordLogs).filter_by(recordid=id).order_by(RecordLogs.time) utils.log( logger, "view record log list id: %d, start: %s, dest: %s@%s." % (rec.id, rec.starttime.strftime("%Y%m%d %H:%M:%S"), rec.account, rec.host), ) sess.commit()
def _select(session): users = sess.query(Users).order_by(Users.username) return utils.paged_template('usr_sel.html', _users=users, selected=set(session.pop('selected')))
def _select(session): groups = sess.query(Groups).order_by(Groups.id) return utils.paged_template('grp_sel.html', _groups=groups, selected=set(session.pop('selected')))
def _list(session): groups = sess.query(Groups).order_by(Groups.id) return utils.paged_template('grp.html', _groups=groups)
def _list(session): audits = sess.query(AuditLogs) audits = audits.order_by(desc(AuditLogs.id)) utils.log(logger, 'view audit list.') sess.commit() return utils.paged_template('adts.html', _audits=audits)
else: raise Exception('unknow command') return objs @route('/rec/') @utils.chklogin('audit') def _list(session): recs = sess.query(Records) q = request.query.q if q: try: recs = adv_query(recs, q) except Exception, e: return str(e) recs = recs.order_by(desc(Records.starttime)) utils.log(logger, 'view record list.') sess.commit() return utils.paged_template('recs.html', _recs=recs) @route('/rec/<id:int>') @utils.chklogin('audit') def _show(session, id): rec = sess.query(Records).filter_by(id=id).scalar() if not rec: return 'rec not exist.' reclogs = sess.query(RecordLogs).filter_by(recordid=id).order_by(RecordLogs.time) utils.log(logger, 'view record log list id: %d, start: %s, dest: %s@%s.' % ( rec.id, rec.starttime.strftime('%Y%m%d %H:%M:%S'), rec.account, rec.host)) sess.commit() return utils.paged_template('rec.html', _reclogs=reclogs) header = struct.Struct('>BH') def read_sublog(s, b):
def _select(session): groups = sess.query(Groups).order_by(Groups.id) return utils.paged_template( 'grp_sel.html', _groups=groups, selected=set(session.pop('selected')))
def _list(session): groups = sess.query(Groups).order_by(Groups.id) return utils.paged_template('grp.html', _groups=groups)
def _select(session): users = sess.query(Users).order_by(Users.username) return utils.paged_template( 'usr_sel.html', _users=users, selected=set(session.pop('selected')))
def _select(session): hosts = sess.query(Hosts).order_by(Hosts.id) return utils.paged_template( 'acct_sel.html', _hosts=hosts, selected=set(session.pop('selected')))