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
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
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