def PanstarrsCrossUpdate(specid, ra, dec, conn, cache):
data = getCatchData(ra, dec, cache)
if data is None:
print "failed [file not exist]:" + specid
return False
for row in data:
ra_panstarrs = row[0]
dec_panstarrs = row[1]
if astroUtil.checkDuplicate(ra, dec, ra_panstarrs, dec_panstarrs):
# mags = row[6]
# values = [mags[0], mags[1], mags[2], mags[3], mags[4], specid]
values = [row[2], row[3], row[4], row[5], row[6], specid]
sqlHelper.execWithValues(conn, sql_update, values)
print "succeed :" + specid
return True
print "failed :" + specid
return False
