def getCoordinateData(sql_select_coordinate, sql_select_coordinate_count, mainClass):
sql_select_format = "%s where mainCLass = \'%s\'"
sql_select_count_format = "%s where mainCLass = \'%s\'"
if sql_select_coordinate.find("where") >= 0:
sql_select_format = "%s and mainCLass = \'%s\'"
sql_select_count_format = "%s and mainCLass = \'%s\'"
sql_select = sql_select_format % (sql_select_coordinate, mainClass)
sql_select_count = sql_select_count_format % (sql_select_coordinate_count, mainClass)
if mainClass == "ALL":
sql_select = sql_select_coordinate
sql_select_count = sql_select_coordinate_count
ras, decs, count = dfh.get2FieldsData(sql_select, sql_select_count)
return ras, decs, count
__author__ = 'zdwdong'
import matplotlib.pyplot as plt
import numpy as np
import CodeLib.Database.DataFetchHandle as dfh
import CodeLib.Util.PlotUtil as plotUtil
import CodeLib.Util.CommonUtil as util
sql_select_distance = "select mag3,teff from dr3.All_Distance where mag3>0"
sql_count_distance = "select count(*) from dr3.All_Distance where mag3>0"
rs, teffs, count = dfh.get2FieldsData(sql_select_distance, sql_count_distance)
dic = {}
for i in range(count):
k = int(teffs[i])
k1 = int(k / 100)
k2 = k1 + 1
r = float(rs[i])
util.addItemToDic(dic, k1, r)
util.addItemToDic(dic, k2, r)
x_mean = []
y_mean = []
x_3std1 = []
y_3std1 = []
x_3std2 = []
y_3std2 = []
for key in dic.keys():
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
specids, ras, decs, count = dfh.get3FieldsData(sql_select, sql_count)
conn = sqlHelper.getMySQLConn()
succeedCount = 0
currentCount = 0
dic = []
for i in range(count):
specid = str(specids[i])
ra = float(ras[i])
dec = float(decs[i])
if PanstarrsCrossUpdate(specid, ra, dec, conn, dic):
succeedCount += 1
currentCount += 1
print "succeed/current count %d/%d:" % (succeedCount, currentCount)
