def error_panel(db): host = zoom.system.request.host data = db( """ select log.id, username, path, timestamp from log left join users on log.user_id = users.id where log.status in ("E") and timestamp>=%s and server = %s order by log.id desc limit 10 """, today(), host) rows = [] for rec in data: row = [ link_to(str(rec[0]), '/admin/entry/' + str(rec[0])), link_to_user(rec[1]), rec[2], how_long_ago(rec[3]), ] rows.append(row) labels = 'id', 'user', 'path', 'when' return zoom.browse(rows, labels=labels, title=link_to_page('Errors'))
def users_panel(db): host = zoom.system.request.host data = db( """ select users.username, max(log.timestamp) as timestamp, count(*) as requests from log, users where log.user_id = users.id and timestamp >= %s and server = %s and path not like "%%\\/\\_%%" group by users.username order by timestamp desc limit 10 """, today() - datetime.timedelta(days=14), host) rows = [] for rec in data: row = [ link_to_user(rec[0]), how_long_ago(rec[1]), rec[2], ] rows.append(row) labels = 'user', 'last seen', 'requests' return zoom.browse(rows, labels=labels, title=link_to_page('Users'))
def activity_panel(db): host = zoom.system.request.host data = db( """ select log.id, users.username, log.address, log.path, log.timestamp, log.elapsed from log left join users on log.user_id = users.id where server = %s and path not like "%%\\/\\_%%" and log.status = 'C' order by timestamp desc limit 15 """, host) rows = [] for rec in data: row = [ link_to(str(rec[0]), '/admin/entry/' + str(rec[0])), link_to_user(rec[1]), rec[2], zoom.link_to(rec[3]), how_long_ago(rec[4]), rec[4], rec[5], ] rows.append(row) labels = 'id', 'user', 'address', 'path', 'when', 'timestamp', 'elapsed' return zoom.browse(rows, labels=labels, title=link_to_page('Requests'))
def index(self, **k): index_query = "select distinct kind from entities" db = self.model.site.db queues = Queues(db) engines = ('<H3>Engines</H3>' + ', '.join(str(e[0]) for e in db('show engines'))) entities = ('<H3>Entities</H3>' + ', '.join([ link_to(kind, 'storage', 'entity', kind) for kind, in db(index_query) ])) tables = ('<H3>Tables</H3>' + ', '.join([ link_to(kind, 'storage', 'table', kind) for kind, in db('show tables') ])) zap = link_to_page('clear queues', 'clear_queues') + '<br>' queues = ('<H3>Queues</H3>' + zap + ', '.join([ link_to(kind, 'storage', 'queue', kind) for kind in Queues(db).topics() ])) content = tables + entities + queues database_info = 'database: %s' % zoom.system.site.db.connect_string return Page(content, title='Storage', subtitle=database_info)