import MySQLdb
import csv

def pN(inp): 
 if len(str(inp).strip())==0: 
  return -99.99
 return inp 


conn = MySQLdb.connect(host = "localhost",user = "root",passwd = "",unix_socket="/home/belikov/mysql/mysql.sock",read_default_file="/home/belikov/mysql/my.cnf")
cursor  = conn.cursor()
cursor.execute ("USE PROB")
cursor.execute ("SELECT T1.CROSSID, T2.RA2000, T2.DEC2000, T2.JMAG, T2.HMAG, T2.KMAG, T3.RA2000, T3.DEC2000, T3.BMAG, T3.RMAG FROM CROSSID T1, TWOMASS T2, USNOA2 T3 WHERE T3.ID=T1.IDUSNOA2 AND T2.ID=T1.IDTWOMASS")

f=open("prob.xml","w")
f.write("<?xml version=\"1.0\" ?>\n")
f.write("<cross-id xmlns=\"just a fake\">")
while(1): 
 row=cursor.fetchone()
 if row==None: break 
 print row[0], row[1], row[6], row[2], row[7]
 str_out='''<cross><id>%s</id><RA EQUINOX="J2000">%s</RA><DEC EQUINOX="J2000">%s</DEC><MAG FILTER="B">%s</MAG><MAG FILTER="R">%s</MAG><MAG FILTER="J">%s</MAG><MAG FILTER="H">%s</MAG><MAG FILTER="K">%s</MAG></cross>\n''' % (row[0],row[1],row[2],row[8],row[9],row[3],row[4],row[5])
 f.write(str_out)

f.write("</cross-id>")
f.close() 
cursor.close ()
conn.close ()