def plot(sql_distinct, sql_select_coordinate, sql_select_coordinate_count, tag, onlyShowAll=False):
mainClassList = getMainClassList(sql_distinct, onlyShowAll)
for mainClass in mainClassList:
ras, decs, count = getCoordinateData(sql_select_coordinate, sql_select_coordinate_count, mainClass)
try:
plotSingleCLass(ras, decs, tag, mainClass, count)
except Exception, ex:
exUtil.printMessage(ex, "Density Plot Error", mainClass)
def plotScatter(sql_distinct, sql_select_coordinate, sql_select_coordinate_count, tag, onlyShowAll=False):
mainClassList = getMainClassList(sql_distinct, onlyShowAll)
for mainClass in mainClassList:
ras, decs, count = getCoordinateData(sql_select_coordinate, sql_select_coordinate_count, mainClass)
try:
CommonPlot.plotGrid(plt)
plt.title(tag + " - " + mainClass + "_Scatter")
plt.plot(ras, decs, '.')
CommonPlot.plotGalaxy(plt)
filePath = "/media/zdwdong/my/fits/Scatter/Scatter_%s_%s.png" % (tag, mainClass)
plt.savefig(filePath)
print tag + " : " + mainClass + " saved"
plt.close()
except Exception, ex:
exUtil.printMessage(ex, "Density Plot Error", mainClass)
def importLamostData(sql_select, sql_insert):
conn = sqlHelper.getMySQLConn()
conn45 = sqlHelper.getMySQL45Conn()
count = 0
data = sqlHelper.getFetchManyByConn(conn45, sql_select)
for info in data:
sqlRecord = []
colIndex = 1
try:
for col in info:
if colIndex == 13:
classType = info[10]
subClass = info[11]
mainClass = astroUtil.getMainClass(classType, subClass)
sqlRecord.append(mainClass)
sqlRecord.append(col)
colIndex += 1
sqlHelper.execWithValues(conn, sql_insert, sqlRecord)
count += 1
except Exception, ex:
exUtil.printMessage(ex, "Migration")
def getMySQLConn():
try:
return MySQLdb.connect(host='localhost', user='******', passwd='zdwdong', db='dr3', port=3306)
except Exception, ex:
exUtil.printMessage(ex, exceptionTag)
def getMySQL45Conn():
try:
return MySQLdb.connect(host='10.51.0.45', user='******', passwd='lamost', port=3306)
except Exception, ex:
exUtil.printMessage(ex, exceptionTag)
