def handle(self, fitsInfo):
keywords = fitsInfo[0].header
classType = astroUtil.getKeyword(keywords, "CLASS", "1D_CLASS")
if classType == "SKY":
return
ra = astroUtil.getKeyword(keywords, 'RA')
dec = astroUtil.getKeyword(keywords, 'DEC')
subClass = astroUtil.getKeyword(keywords, "SUBCLASS", "1D_SUBCL")
mainClass = astroUtil.getMainClass(classType, subClass)
date = astroUtil.getKeyword(keywords, "DATE-OBS")[0:10]
planID = astroUtil.getKeyword(keywords, "PLANID")
z = astroUtil.getKeyword(keywords, "Z", "1D_Z")
z_err = astroUtil.getKeyword(keywords, "1D_Z_ERR", "Z_ERR")
version_idl = astroUtil.getKeyword(keywords, "VERSIDL")
version_ppl = astroUtil.getKeyword(keywords, "VERS2D", "VERSPIPE")
SN_U = astroUtil.getKeyword(keywords, "SN_U")
SN_G = astroUtil.getKeyword(keywords, "SN_G")
SN_R = astroUtil.getKeyword(keywords, "SN_R")
SN_I = astroUtil.getKeyword(keywords, "SN_I")
SN_Z = astroUtil.getKeyword(keywords, "SN_Z")
sqlRecord = [planID, version_idl, version_ppl, date, ra, dec,
classType, mainClass, subClass, z, z_err, SN_U, SN_G, SN_R, SN_I, SN_Z]
sqlHelper.execWithValues(self.conn, self.sql_insert, sqlRecord)
self.count += 1
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")
