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 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()]]
