def getMainClassList(sql_distinct, onlyShowAll):
mainClassList = []
if not onlyShowAll:
mainClassList = sqlHelper.getList(sql_distinct)
mainClassList.append("ALL")
return mainClassList
def getSpecTypeByTeff(teff, column="teff_m"):
sql = "SELECT specType from DM.SPECTYPE where %s <= %s order by %s desc limit 0 ,1" % (column, teff, column)
res = sqlHelper.getList(sql)
return res[0]