#!/usr/bin/python
import MySQLdb

print "Content-Type: text/xml\n"


conn = MySQLdb.connect (host = "database",
			user = "ccadmin",
			passwd = "8f#pcs844g",
			db = "classical")
cursor = conn.cursor()
cursor.execute("SELECT COUNT(DISTINCT value) FROM en_attr_text attr_catno INNER JOIN en_rectrack rt ON(attr_catno.item_id=rt.recwork_id) INNER JOIN en_rectrack_format USING(rectrack_id) WHERE name=1007 AND value <> ''")

print """<?xml version='1.0' encoding='UTF-8'?>
<urlset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
         http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd"
         xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">"""

while(1):
	row = cursor.fetchone()
	if row==None: break
	print """<url>
	<loc>http://www.classical.com/album/%s</loc>
</url>""" % row[0].replace(" ","+").replace("(", "%28").replace(")","%29")

print "</urlset>"
cursor.close()
conn.close()