def hour2float(instring, hint):
"""
hour2float() takes an input hours string in "hh:MM:ss.sss" format or hh.hhh
and returns a floating point value in degrees
"""
outfloat = 0.0
parts = instring.split(':')
if len(parts) == 1: # if only one part, then degrees
outfloat = float(instring)
elif len(parts) == 3: # if three parts, then dd:mm:ss
anangle = angles.AlphaAngle(instring)
outfloat = anangle.d
else:
print("%s format error: %s, zero returned " % (hint, instring))
return outfloat
def time2float(instring, hint):
"""
time2float() takes an input time string in "hh:MM:ss.sss" or ss.sss format
and returns a floating point time value in seconds
"""
outfloat = 0.0
parts = instring.split(':')
if len(parts) == 1: # if only one part, then degrees
outfloat = float(instring)
elif len(parts) == 3: # if three parts, then dd:mm:ss
atime = angles.AlphaAngle(instring)
outfloat = atime.h * 3600.
else:
print("%s format error: %s, zero returned " % (hint, instring))
return outfloat
exit(1)
cursor=db.cursor()
cursor.execute("Select pgc,al2000,de2000 from kleda limit 1;")
results=cursor.fetchall()
db.commit()
#ra=["" if x[1] is None else angles.AlphaAngle(h=float(str(x[1]))) for x in results]
#dec=["" if x[2] is None else angles.DeltaAngle(d=float(str(x[2]))) for x in results]
#ra=[angles.AlphaAngle(h=float(str(x[1]))) for x in results]
#print results
#print ra
#cursor.executemany("INSERT into kleda (RA2000,DEC2000) values (%s,%s);",values)
#db.commit()
coords=[]
for x in results:
#print x[0], x[1]
ra=0 if x[1] is None else str(angles.AlphaAngle(h=float(str(x[1])))).replace("HH","").replace("MM","").replace("SS","").replace(" ","")
dec=0 if x[2] is None else angles.AlphaAngle(h=float(str(x[2])))
coords.append((ra,dec,x[0]))
cursor.execute("select * from kleda limit 1;")
results=cursor.fetchall()
joined=map (lambda x,y: x+y,results,coords)
print joined
#ra=[0.0 if x is None else angles.AlphaAngle(h=float(str(x[0]))) for x in results]
#dec=[0.0 if x is None else angles.DeltaAngle(d=float(str(x[1]))) for x in results]
#values=map (lambda x,y: (x,y), ra,dec)
#cursor.executemany("update kleda set RA2000=%s,DEC2000=%s where pgc='%s';", coords)
#db.commit()
cursor.close()
