예제 #1
0
def getMainClassList(sql_distinct, onlyShowAll):
    mainClassList = []
    if not onlyShowAll:
        mainClassList = sqlHelper.getList(sql_distinct)
    mainClassList.append("ALL")
    return mainClassList
예제 #2
0
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]