Ejemplo n.º 1
0
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)
Ejemplo n.º 2
0
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)
Ejemplo n.º 3
0
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)
Ejemplo n.º 4
0
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)
Ejemplo n.º 5
0
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)
Ejemplo n.º 6
0
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)
Ejemplo n.º 7
0

@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()
Ejemplo n.º 8
0
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')))
Ejemplo n.º 9
0
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')))
Ejemplo n.º 10
0
def _list(session):
    groups = sess.query(Groups).order_by(Groups.id)
    return utils.paged_template('grp.html', _groups=groups)
Ejemplo n.º 11
0
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)
Ejemplo n.º 12
0
        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):
Ejemplo n.º 13
0
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')))
Ejemplo n.º 14
0
def _list(session):
    groups = sess.query(Groups).order_by(Groups.id)
    return utils.paged_template('grp.html', _groups=groups)
Ejemplo n.º 15
0
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')))
Ejemplo n.º 16
0
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')))