view_ip_url_hits.py

import cgi
import os

from google.appengine.ext import webapp
from google.appengine.ext.webapp.util import run_wsgi_app
from google.appengine.ext import db
from google.appengine.ext.webapp import template

from data import IpUrlHits

class ViewIpUrlHits(webapp.RequestHandler):
		
	def get(self):
		self.response.headers['Content-Type'] = 'text/html'
		
		hash = cgi.escape(self.request.query_string)
		
		if hash == '':
			hash = None
		
		if hash is None:
			iuhits_list = db.GqlQuery("select * from IpUrlHits order by hits desc limit 1000")
		else:
			iuhits_list = db.GqlQuery("select * from IpUrlHits where hash = :h order by hits desc limit 1000", h=hash)
		
		template_values = {
			'iuhits_list' : iuhits_list
		}
		
		path = os.path.join(os.path.dirname(__file__), 'view_ip_url_hits.html')
		self.response.out.write(template.render(path, template_values))