def get_all_pages(): data = list() query_pages = Query(Object.extend('UserInPage')) query_pages.greater_than('user_num', 0) results = query_pages.find() for result in results: temp_dict = dict() temp_dict['page_url'] = result.get('page_url') temp_dict['user_num'] = result.get('user_num') data.append(temp_dict) return data
def query_data(page, user_id, cur_time): ''' 查询弹幕,暂未使用 :param page: :param user_id: :param cur_time: :return: 弹幕数据 ''' last_post_time = update_user_info(page, user_id, cur_time) data = list() curtain_object = Object.extend('CurtainObject') query = Query(curtain_object) query.equal_to('page', page) query.greater_than('time', last_post_time) query.less_than('time', cur_time) query.ascending('time') results = query.find() for result in results: data.append({'content': result.get('content'), 'timestamp': result.get('time')}) return data
def getYesterdayKDJ(rlist): cyStockData = Object.extend('CYStockData') query = Query(cyStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) cyresults = query.find() for x in cyresults: rlist.append(x.get("stcode")) szStockData = Object.extend('SZStockData') query = Query(szStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) szresults = query.find() for x in szresults: rlist.append(x.get("stcode")) shStockData = Object.extend('SHStockData') query = Query(shStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) shresults = query.find() for x in shresults: rlist.append(x.get("stcode"))
def query_data(page, user_id, cur_time): ''' 查询弹幕,暂未使用 :param page: :param user_id: :param cur_time: :return: 弹幕数据 ''' last_post_time = update_user_info(page, user_id, cur_time) data = list() curtain_object = Object.extend('CurtainObject') query = Query(curtain_object) query.equal_to('page', page) query.greater_than('time', last_post_time) query.less_than('time', cur_time) query.ascending('time') results = query.find() for result in results: data.append({ 'content': result.get('content'), 'timestamp': result.get('time') }) return data
def get_log_data(): leancloud.init("9ra69chz8rbbl77mlplnl4l2pxyaclm612khhytztl8b1f9o", "1zohz2ihxp9dhqamhfpeaer8nh1ewqd9uephe9ztvkka544b") start = datetime(2016, 1, 13) end = datetime(2016, 1, 14) query = Query(Object.extend('Log')) query.equal_to("type", "location") query.greater_than("createdAt", start) query.less_than("createdAt", end) # query_limit = 100 # total_count = query.count() # query_times = (total_count + query_limit - 1) / query_limit result_list = query.find() # for index in xrange(query_times): # query.limit(query_limit) # query.skip(index * query_limit) # result_list.extend(query.find()) # print result_list[1].id # print "###################" # a = json.dumps(result_list[1]) # print type(a) # print a return result_list
def getYesterdayKDJ(rlist): query = Query(CYStockData) query.equal_to('kdjback', 1) query.greater_than('kdj', 0) query.equal_to('volume', 1) cyresults = query.find() for x in cyresults: rlist.append(x['stcode']) query = Query(SZStockData) query.equal_to('kdjback', 1) query.greater_than('kdj', 0) query.equal_to('volume', 1) szresults = query.find() for x in szresults: rlist.append(x['stcode']) query = Query(SHStockData) query.equal_to('kdjback', 1) query.greater_than('kdj', 0) query.equal_to('volume', 1) cyresults = query.find() for x in cyresults: rlist.append(x['stcode'])
def getYesterdayKDJ(rlist): query = Query(CYStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) cyresults = query.find() for x in cyresults: rlist.append(x['stcode']) query = Query(SZStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) szresults = query.find() for x in szresults: rlist.append(x['stcode']) query = Query(SHStockData) query.equal_to('kdjback', 1) query.greater_than('kdj',0) query.equal_to('volume',1) cyresults = query.find() for x in cyresults: rlist.append(x['stcode'])
def get_date_news(self): query = Query(Question) query.greater_than("createdAt", datetime.now() - timedelta(days=1)) r = query.find() return [i for i in r if i not in [j.question for j in Option.get_date_news()]]