def __init__(self, *args, **kwargs):
super(Testcases, self).__init__(*args, **kwargs)
self.maxDiff = None
self.hive = hve.Hive()
if xiaoqu in xiaoquDic:
sumUV = sumUV + xiaoquDic[xiaoqu]['uv']
sumPV = sumPV + xiaoquDic[xiaoqu]['pv']
return sumUV, sumPV
#}}
#def getData(startDate,endDate):
dts = ["2013-09-" + (str(i), str(i))[len(str(i)) - 1] for i in range(10, 29)]
dyn = globals()
for day in dts:
dyn['hive' + day] = hive.Hive()
#sql = "select regexp_extract(url, '/xiaoqu/([^/]*)/(.*|$)',1), uuid from web_pv_log_detail3 where dt = '" + day + "' and gjch regexp 'xiaoqu'"
sql = "select regexp_extract(url, '/xiaoqu/([^/]*)/(.*|$)',1), uuid from web_pv_log_detail3 where dt = '" + day + "' and url regexp 'http://bj.ganji.com/xiaoqu/' and ca_name='se'"
dyn['hive' + day].desc = day + 'xiaoquPvLog'
dyn['hive' + day].session_name = day + 'xiaoquPvLog'
print dyn['hive' + day].desc
dyn['hive' + day].select(sql, dyn['hive' + day].desc,
dyn['hive' + day].session_name)
xiaoquSEOUV = {}
for day in dts:
#print dyn['hive'+day]
print day
print dyn['hive' + day].getData()
def __init__(self, telegram=False, temperature_game_over=True):
# Define Screen Size
self.disp_height = DISP_HEIGHT
self.disp_width = DISP_WIDTH
self.t0 = time.time()
# self.screen = pygame.display.set_mode((self.disp_width, self.disp_height))
self.screen = pygame.display.set_mode((0, 0), pygame.FULLSCREEN)
self.grid_height = GRID_HEIGHT
self.grid_width = GRID_WIDTH
self.map = Map(self.grid_height, self.grid_width)
self.bees = {}
self.thermometer = pygame.image.load(
os.path.join(current_path, 'Thermometer_grey.png'))
self.game_over_win = pygame.image.load(
os.path.join(current_path, 'Game_Finished_Repaired.png'))
self.game_over_heat = pygame.image.load(
os.path.join(current_path, 'Game_Finished_T_high.png'))
self.game_over_cold = pygame.image.load(
os.path.join(current_path, 'Game_Finished_T_low.png'))
h = self.game_over_win.get_height()
w = self.game_over_win.get_width()
scale = min(0.8 * DISP_HEIGHT / h, 0.8 * DISP_WIDTH / w)
self.game_over_win = pygame.transform.scale(
self.game_over_win, (int(w * scale), int(h * scale)))
self.game_over_heat = pygame.transform.scale(
self.game_over_heat, (int(w * scale), int(h * scale)))
self.game_over_cold = pygame.transform.scale(
self.game_over_cold, (int(w * scale), int(h * scale)))
self.queue = queue.Queue(maxsize=10)
self.webserver = make_app(self.queue)
self.webserver.listen(8090)
self.hive = hive.Hive(self.grid_height, self.grid_width)
self.tornado_target = tornado.ioloop.IOLoop.current()
self.tornado_thread = threading.Thread(
target=self.tornado_target.start)
self.tornado_thread.start()
self.bot_queue = queue.Queue()
if telegram:
self.bot = bot.Bot(self.bot_queue)
self.temperature = 150
self.temperature_game_over = temperature_game_over
self.temperature_limits = [0, 210]
background_path = os.path.join(current_path, 'background_bees.ogg')
dance_path = os.path.join(current_path, 'wild_bees.ogg')
self.base_volume = 0.2
self.background_sound = pygame.mixer.Sound(background_path)
self.background_sound.set_volume(self.base_volume)
self.dance_sound = pygame.mixer.Sound(dance_path)
self.dance_sound.set_volume(self.base_volume)
#coding:utf-8
import sys
import html
import hive
from commonFunction import dateVal
hiveHandle = hive.Hive()
def fromAnalysisSimple(dt, conditions):
sql = 'select dt,count(distinct uuid) as uv, count(1) as pv from web_pv_log_detail3 where dt="' + dt + '" and ' + conditions + ' and cat regexp "/fang/" group by dt;'
print sql
hiveHandle.desc = 'temp' + dt
hiveHandle.session_name = 'temp' + dt
try:
hiveHandle.select(sql, hiveHandle.desc, hiveHandle.session_name)
hiveHandle.getData()
except Exception, e:
print e
def fromAnalysisAll(select, conditions):
sql = 'select ' + select + ' from web_pv_log_detail3 where ' + conditions + ';'
print sql
hiveHandle.desc = 'temp'
hiveHandle.session_name = 'temp'
try:
hiveHandle.select(sql, hiveHandle.desc, hiveHandle.session_name)
hiveHandle.getData()
return str(int(string_num.upper(), 16))
UvPv = {}
UvPv['all'] = {}
UvPv['all']["uv"] = 0
UvPv['all']["pv"] = 0
count = 0
import hive
#查询数据
sql = 'select topn(1,array(FROM_UNIXTIME(access_at),cat,ca_source,url_decoding(ca_kw),url_decoding(refer),url),array(access_at),array(true)),uuid,sum(if(instr(cat,"list")>0,1,0)), sum(if(instr(cat,"search")>0,1,0)) as search_pv, sum(if(instr(cat,"detail")>0,1,0)) as detail_pv, sum(if(instr(cat,"index")>0,1,0)) as index_pv, count(1) as pv from web_pv_log_detail3 where dt>="' + dateEarly + '" and dt<="' + dateToday + '" and cat regexp "/fang/" group by uuid order by pv desc;'
desc = 'FangLastSevenDayPVUV'
session_name = 'FangLastSevenDayPVUV'
hive = hive.Hive()
hive.select(sql, desc, session_name)
hive.getData()
source = hive.outContent
for userCase in source:
try:
#print userCase
access_at, cat, ca_source, ca_kw, refer, url, uuid, list_pv, search_pv, detail_pv, index_pv, pv = userCase.split(
'\t')
'''if int(pv[:-1]) >= 100 or uuid == "-":
continue'''
except:
continue