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():
