示例#1
0
 def get(self, raw_tag):
     tag = self.request.path_info.split('/')[-1].decode('utf8')
     if raw_tag:
         query_str = "SELECT * FROM Company WHERE tags='%s'" % tag
     else:
         query_str = "SELECT * FROM Company WHERE tags='alarm'"
         tag='alarm'
     # lets try to memcache the polular pages:
     cache_key = md5.new(query_str.encode('ascii', 'ignore')).hexdigest()
     if memcache.get(key=cache_key):
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = memcache.get(key=cache_key)
         logging.info("Cache works perfectly!")
     else:
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = get_companies_data(query_str)
         memcache.set(key=cache_key, value=get_companies_data(query_str), time=3600)
     user = users.get_current_user()
     if user:
         nickname = user.nickname()
         authurl = users.create_logout_url(self.request.path_info)
     else:
         nickname = ""
         authurl = users.create_login_url(self.request.path_info)
     template_values = {'companies':companies_data, 'results_number':results_number, 'cities_first_letters':first_letters_list, 'cities':unique_cities, 'cities_ordered':cities_ordered, 'search_navbar':navbar, 'category':tag, 'tags':get_unique_tags(), 'name':nickname, 'authurl':authurl}
     template = jinja_environment.get_template('vikarbureau_restyled.htm')
     self.response.out.write(template.render(template_values))
示例#2
0
 def get(self, raw_city):
     city = self.request.path_info.split('/')[-1].decode('utf8')
     if raw_city:
         query_str = "SELECT * FROM Company WHERE city='%s'" % city
     else:
         query_str = "SELECT * FROM Company WHERE city='Aabybro'"
     # lets try to memcache the polular pages:
     cache_key = md5.new(query_str.encode('ascii', 'ignore')).hexdigest()
     if memcache.get(key=cache_key):
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = memcache.get(key=cache_key)
         logging.info("Cache works perfectly!")
     else:
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = get_companies_data(query_str)
         memcache.set(key=cache_key, value=get_companies_data(query_str), time=3600)
     template_values = {'companies':companies_data, 'results_number':results_number, 'cities_first_letters':first_letters_list, 'cities':unique_cities, 'cities_ordered':cities_ordered, 'search_navbar':navbar, 'category':city, 'tags':get_unique_tags()}
     doRender(self,'vikarbureau_restyled.htm', template_values)
示例#3
0
文件: vikar.py 项目: 0--key/lib
 def get(self, raw_tag):
     tag = self.request.path_info.split("/")[-1].decode("utf8")
     if raw_tag:
         query_str = "SELECT * FROM Company WHERE tags='%s'" % tag
     else:
         query_str = "SELECT * FROM Company WHERE tags='alarm'"
         tag = "alarm"
     # lets try to memcache the polular pages:
     cache_key = md5.new(query_str.encode("ascii", "ignore")).hexdigest()
     if memcache.get(key=cache_key):
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = memcache.get(
             key=cache_key
         )
         logging.info("Cache works perfectly!")
     else:
         companies_data, results_number, first_letters_list, unique_cities, cities_ordered, navbar = get_companies_data(
             query_str
         )
         memcache.set(key=cache_key, value=get_companies_data(query_str), time=3600)
     user = users.get_current_user()
     if user:
         nickname = user.nickname()
         authurl = users.create_logout_url(self.request.path_info)
     else:
         nickname = ""
         authurl = users.create_login_url(self.request.path_info)
     template_values = {
         "companies": companies_data,
         "results_number": results_number,
         "cities_first_letters": first_letters_list,
         "cities": unique_cities,
         "cities_ordered": cities_ordered,
         "search_navbar": navbar,
         "category": tag,
         "tags": get_unique_tags(),
         "name": nickname,
         "authurl": authurl,
     }
     template = jinja_environment.get_template("vikarbureau_restyled.htm")
     self.response.out.write(template.render(template_values))