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 '用户预测完成------------------------------------'