def an_come_from(): print('an device') count_list = yield from orm.just_get_rs('SELECT come_from,COUNT(*) as num FROM weibos GROUP BY come_from') print("device len: %s" % len(count_list)) print(count_list) count_result = [] activity = {'num': 0, 'come_from': '活动'} for i in range(len(count_list)): come_from = count_list[i]['come_from'] print('come from : %s' % come_from) find = come_from.find('href') print('find : %s' % find) if find > 0: activity['num']+=count_list[i]['num'] else: count_result.append(count_list[i]) count_result.append(activity) return count_result
def an_location(): count_list = yield from orm.just_get_rs('SELECT location,COUNT(*) AS num FROM weibo_users GROUP BY location') return count_list
def an_sex_orientation(): count_list = yield from orm.just_get_rs('SELECT sex_orientation,COUNT(*) AS num FROM weibo_users GROUP BY sex_orientation') return count_list
def an_single_state(): count_list = yield from orm.just_get_rs('SELECT single_state,COUNT(*) AS num FROM weibo_users GROUP BY single_state') return count_list
def an_user_sex(): count_list = yield from orm.just_get_rs('SELECT sex,COUNT(*) AS num FROM weibo_users GROUP BY sex') return count_list