def judge_need_crawser(self):
current = time.time()
current = float(current)
x = time.localtime(current)
x = time.strftime('%H%M', x)
if int(x) < 1000 and int(x) > 160:
print '重庆时时彩 =======> 当前时间不需要抓取 -----'
return 0
sql = "select {0} from {1} order by {2} desc limit 1".format(
CF.HISTIME, CF.HISTAB, CF.HISQI)
result = DBM.maka_do_sql(sql)
if not result:
return 1
if len(result) == 0:
return 1
lastTime = result[0][0]
print lastTime
lastTimeSeconds = DU.date_to_time(lastTime)
currentInset = timeInset
if int(x) > 1000 and int(x) < 2200:
currentInset = 10
if current - lastTimeSeconds >= currentInset * 60:
print '重庆时时彩 ***********需要抓取********** {0} {1} *****'.format(
lastTimeSeconds, current)
return 1
return 0
def getTouzhuForPerson(self,person,name,qishu):
sql = "select * from {0} where {1} = {2};".format(DBC.PSTAB,DBC.PSID,person)
result = DBM.maka_do_sql(sql)
if len(result) == 0:
result = UserController.inertPersonWith(person, name, name)
print '~~~~~~~~~~~~~~~~~~ 插入用户 ~~~~~~~~~~~~~~~~~~~~~~'
else:
tuple = result[0]
touzhu = self.getRandom()
currentTime = long(time.time())
currentTime = DU.time_to_date(currentTime)
numbers = touzhu['numbers']
numbers = ','.join(numbers)
sql = "insert into {0} ({1},{2},{3},{4},{5},{6},{7}) values ('{8}','{9}','{10}','{11}',{12},{13},{14})" \
.format(DBC.BLTAB,DBC.BLQI,DBC.BLTIME,DBC.BLROAD,DBC.BLNUMBER,DBC.BLMONEY,DBC.BLSTATUS,DBC.BLPERSON, \
qishu,currentTime,str(touzhu['road']),numbers,touzhu['beat'],0,person)
DBM.maka_do_sql(sql)
print '用户预测完成------------------------------------'