def sitemap(): """ googleクローラー用のsitemap.xml """ all_sites = Site.get_all() new_pages = Page.gets_new(10000) new_keywords = PageKeywordRelation.gets_new(10000) now = datetime.datetime.now(pytz.utc) - datetime.timedelta(seconds=3600) new_keyword_pages = [keyword for keyword in new_keywords if keyword.page and keyword.page.is_enable(now)] return render_template('sitemap/sitemap.html', url_base='http://www.niku.tokyo/', new_site_date=max([site.created_at for site in all_sites]), all_sites=all_sites, new_pages=new_pages, new_keyword_pages=new_keyword_pages, one_days_ago=datetime.datetime.now() - datetime.timedelta(days=1), three_days_ago=datetime.datetime.now() - datetime.timedelta(days=3), )