def get_sitemap_by_id(self, id=''):
obj = self.get_cat_by_id(id)
if not obj:
return ''
if not obj.content:
return ''
urlstr = """<url><loc>%s</loc><lastmod>%s</lastmod><changefreq>%s</changefreq><priority>%s</priority></url>\n """
urllist = []
urllist.append('<?xml version="1.0" encoding="UTF-8"?>\n')
urllist.append(
'<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">\n')
urllist.append(
urlstr % ("%s/c/%s" % (BASE_URL, str(obj.id)),
cnnow().strftime("%Y-%m-%dT%H:%M:%SZ"), 'daily', '0.8'))
objs = Article.get_post_for_sitemap(obj.content.split(','))
for p in objs:
if p:
urllist.append(
urlstr %
("%s/t/%s" %
(BASE_URL, str(p.id)), timestamp_to_datetime(
p.edit_time).strftime("%Y-%m-%dT%H:%M:%SZ"), 'weekly',
'0.6'))
urllist.append('</urlset>')
return ''.join(urllist)
def get_sitemap_by_id(self, id=""):
obj = self.get_cat_by_id(id)
if not obj:
return ""
if not obj.content:
return ""
urlstr = (
"""<url><loc>%s</loc><lastmod>%s</lastmod><changefreq>%s</changefreq><priority>%s</priority></url>\n """
)
urllist = []
urllist.append('<?xml version="1.0" encoding="UTF-8"?>\n')
urllist.append('<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">\n')
urllist.append(
urlstr % ("%s/c/%s" % (BASE_URL, str(obj.id)), cnnow().strftime("%Y-%m-%dT%H:%M:%SZ"), "daily", "0.8")
)
objs = Article.get_post_for_sitemap(obj.content.split(","))
for p in objs:
if p:
urllist.append(
urlstr
% (
"%s/t/%s" % (BASE_URL, str(p.id)),
timestamp_to_datetime(p.edit_time).strftime("%Y-%m-%dT%H:%M:%SZ"),
"weekly",
"0.6",
)
)
urllist.append("</urlset>")
return "".join(urllist)
def post_detail_formate(obj):
if obj:
slug = slugfy(obj.title)
obj.slug = slug
obj.absolute_url = '%s/topic/%d/%s' % (BASE_URL, obj.id, slug)
obj.shorten_url = '%s/t/%s' % (BASE_URL, obj.id)
if '[/code]' in obj.content:
obj.highlight = True
else:
obj.highlight = False
obj.content = tran_content(obj.content, obj.highlight)
obj.taglist = ', '.join(["""<a href="%s/tag/%s/" rel="tag">%s</a>"""%(BASE_URL, tag, tag) for tag in obj.tags.split(',')])
obj.add_time_fn = time_from_now(int(obj.add_time))
obj.last_modified = timestamp_to_datetime(obj.edit_time)
obj.keywords = obj.tags
obj.description = HTML_REG.sub('',obj.content[:DESCRIPTION_CUT_WORDS])
#get prev and next obj
obj.prev_obj = sdb.get('SELECT `id`,`title` FROM `sp_posts` WHERE `id` > %s LIMIT 1' % str(obj.id))
if obj.prev_obj:
obj.prev_obj.slug = slugfy(obj.prev_obj.title)
obj.next_obj = sdb.get('SELECT `id`,`title` FROM `sp_posts` WHERE `id` < %s ORDER BY `id` DESC LIMIT 1' % str(obj.id))
if obj.next_obj:
obj.next_obj.slug = slugfy(obj.next_obj.title)
#get relative obj base tags
obj.relative = []
if obj.tags:
idlist = []
getit = False
for tag in obj.tags.split(','):
tagobj = Tag.get_tag_by_name(tag)
if tagobj and tagobj.content:
pids = tagobj.content.split(',')
for pid in pids:
if pid != str(obj.id) and pid not in idlist:
idlist.append(pid)
if len(idlist) >= RELATIVE_POST_NUM:
getit = True
break
if getit:
break
#
if idlist:
obj.relative = sdb.query('SELECT `id`,`title` FROM `sp_posts` WHERE `id` in(%s) LIMIT %s' % (','.join(idlist), str(len(idlist))))
if obj.relative:
for robj in obj.relative:
robj.slug = slugfy(robj.title)
#get comment
obj.coms = []
if obj.comment_num >0:
if obj.comment_num >= EACH_PAGE_COMMENT_NUM:
first_limit = EACH_PAGE_COMMENT_NUM
else:
first_limit = obj.comment_num
obj.coms = Comment.get_post_page_comments_by_id( obj.id, 0, first_limit )
return obj
def post_detail_formate(obj):
if obj:
slug = slugfy(obj.title)
obj.slug = slug
obj.absolute_url = "%s/topic/%d/%s" % (BASE_URL, obj.id, slug)
obj.shorten_url = "%s/t/%s" % (BASE_URL, obj.id)
if "[/code]" in obj.content:
obj.highlight = True
else:
obj.highlight = False
obj.content = tran_content(obj.content, obj.highlight)
obj.taglist = ", ".join(
["""<a href="%s/tag/%s/" rel="tag">%s</a>""" % (BASE_URL, tag, tag) for tag in obj.tags.split(",")]
)
obj.add_time_fn = time_from_now(int(obj.add_time))
obj.last_modified = timestamp_to_datetime(obj.edit_time)
obj.keywords = obj.tags
obj.description = HTML_REG.sub("", obj.content[:DESCRIPTION_CUT_WORDS])
# get prev and next obj
obj.prev_obj = sdb.get("SELECT `id`,`title` FROM `sp_posts` WHERE `id` > %s LIMIT 1" % str(obj.id))
if obj.prev_obj:
obj.prev_obj.slug = slugfy(obj.prev_obj.title)
obj.next_obj = sdb.get(
"SELECT `id`,`title` FROM `sp_posts` WHERE `id` < %s ORDER BY `id` DESC LIMIT 1" % str(obj.id)
)
if obj.next_obj:
obj.next_obj.slug = slugfy(obj.next_obj.title)
# get relative obj base tags
obj.relative = []
if obj.tags:
idlist = []
getit = False
for tag in obj.tags.split(","):
tagobj = Tag.get_tag_by_name(tag)
if tagobj and tagobj.content:
pids = tagobj.content.split(",")
for pid in pids:
if pid != str(obj.id) and pid not in idlist:
idlist.append(pid)
if len(idlist) >= RELATIVE_POST_NUM:
getit = True
break
if getit:
break
#
if idlist:
obj.relative = sdb.query(
"SELECT `id`,`title` FROM `sp_posts` WHERE `id` in(%s) LIMIT %s"
% (",".join(idlist), str(len(idlist)))
)
if obj.relative:
for robj in obj.relative:
robj.slug = slugfy(robj.title)
# get comment
obj.coms = []
if obj.comment_num > 0:
if obj.comment_num >= EACH_PAGE_COMMENT_NUM:
first_limit = EACH_PAGE_COMMENT_NUM
else:
first_limit = obj.comment_num
obj.coms = Comment.get_post_page_comments_by_id(obj.id, 0, first_limit)
return obj