Prakash’s Blog

Here is a small piece of code in Python – Zope using MySQL as the database. This will help you build a Google News Sitemap in 2 minutes.
# Import a standard function, and get the HTML request and response objects.
from Products.PythonScripts.standard import html_quote
request = container.REQUEST
response = request.RESPONSE
response.setHeader('Content-Type', 'text/xml')
print ''
print '‘
for item in context.sql.getNewsForToday():
print ‘‘
build_url = “http://www.yoursite.com/news/”+str(item.news_id)+”.html?google”
print ‘%s‘%build_url
print ‘‘
#date w3c format
print ‘%s‘%(DateTime(item.post_date).HTML4())
print ‘%s‘ %(item.keywords)
print ‘‘
print ‘‘
print ”
return printed

Share This