Create an RSS feed from an SQL query (See related posts)

#!/usr/bin/env python
# -*- encoding: latin1 -*-

import datetime,PyRSS2Gen,sqlobject
from sqlobject.postgres import builder

con = builder()(user = 'user', passwd = '', host = 'localhost', db='name')

# set db encoding (maybe optional)
con.queryOne("SET client_encoding TO 'latin1'; SELECT 1;")

items = []
for res in con.queryAll("""SELECT title,url,datum,description FROM table ORDER BY datum DESC LIMIT 30"""):
    items.append(
        PyRSS2Gen.RSSItem(
        title = res[0], link = res[1],
        description = """<h2>%s</h2>on %s<br/><p>%s</p>"""%(res[0],res[2],res[]3),
        guid = PyRSS2Gen.Guid(res[1]), pubDate = res[2]))

    # generate rss feed
PyRSS2Gen.RSS2(
    title         = "sql2rss feed",
    link          = "http://localhost/die URL",
    description   = "The latest sql2rss news",
    lastBuildDate = datetime.datetime.now(),
    items         = items).write_xml(open("sql2rss.xml", "w"))