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)