Example #1
0
def getMaleNumFromDataBase():
    conditionList = ["sex"]
    conditionValList = ["male"]
    operatorList = ["="]
    sqlEnd = SQLServerEnd(USER_BASIC_TABLE_NAME)
    maleNum = sqlEnd.selectCount(conditionList, conditionValList, operatorList)
    return maleNum
def getOnlineNum():
    sql = SQLServerEnd(LOGIN_TABLE_NAME)
    conditionList = ['status']
    conditionValList = ['1']
    operatorList = ['=']
    num = sql.selectCount(conditionList,conditionValList,operatorList)
    return num
Example #3
0
def getAgeCountFromDataBase(begin, end):
    endYear = getYearsAgoDate(begin)
    beginYear = getYearsAgoDate(end)
    conditionList = ["birthday", "birthday"]
    conditionValList = [beginYear, endYear]
    operatorList =  [">=", "<="]
    sqlEnd = SQLServerEnd(USER_BASIC_TABLE_NAME)
    count = sqlEnd.selectCount(conditionList, conditionValList, operatorList)
    return count
Example #4
0
def getMapDictFromDataBase():
    dict = {}
    for k in PROVINCE_DICT.keys():
        dict[PROVINCE_DICT[k]] =  0

    sqlEnd = SQLServerEnd(USER_BASIC_TABLE_NAME)
    queryList = ["hometown"]

    resultList = sqlEnd.select(queryList)

    for item in resultList:
        province = item["hometown"].split()[0]
        try:
            dict[PROVINCE_DICT[province]] = dict[PROVINCE_DICT[province]] + 1
        except:
            print province + u"不存在列表中"
    return dict