#!/usr/bin/env python
import cgitb; cgitb.enable()
import cgi
import MySQLdb

db = "wanderin_suzanne"   # your username (= login name  = account name )
host = "localhost"     # = "localhost", the server your are on.
user = "wanderin_stan" # your Database name is the same as your account name.
passwd = "fortune"     # Your account password
db = MySQLdb.connect(db=db, host=host, user=user, passwd=passwd)

	
pageURL = "http://www.trustbase.org/get_eval.py?fUserID="


o=""
form = cgi.FieldStorage()
if not (form.has_key("fUserID")):
	o += "<error>No user specified</error>"
	
else:

	userURI = pageURL + form["fUserID"].value
	
	c = db.cursor(MySQLdb.cursors.DictCursor)

	#########################################
	
	c.execute("""
		SELECT *
		FROM `tbl_trusts` 
		WHERE user_uri=%s
	""",(userURI))
	
#	c.execute("""
#		SELECT *
#		FROM `tbl_trusts` 
#	""")
	
	results = c.fetchall()
	trustsXMLtest=""
	for row in results:
		trustsXMLtest+="<trust "
		for column in row.keys():
			if (column=="id"):
				continue
			trustsXMLtest+= "%s=\"%s\" " % (column,row[column]) 
		trustsXMLtest+="/>\n"

	#########################################
	
	c.execute("""
		SELECT *
		FROM `tbl_import_trusts` 
		WHERE user_uri=%s
	""",(userURI))
	
	results = c.fetchall()
	importTrustsXMLtest=""
	for row in results:
		importTrustsXMLtest+="<importTrust "
		for column in row.keys():
			if (column=="id"):
				continue
			importTrustsXMLtest+= "%s=\"%s\" " % (column,row[column]) 
		importTrustsXMLtest+="/>\n"

	#########################################
	
	o += """<?xml version="1.0"?>
	
				<user>		
					<info>
						<URI>%s</URI>
						<!-- name and stuff here -->
					</info>
					<trusts>
						%s
					</trusts>
					<importTrusts>
						%s
					</importTrusts>
				</user>
	""" % (userURI,trustsXMLtest,importTrustsXMLtest)
	
print 'Content-type: application/xml\n'
print o