def get(self): f = open('num3.csv', 'r') for idx, l in enumerate(f): l = l.replace('\n', '') colArray = l.split(',') if len(colArray) == 8: ssqInfo = SsqInfo() #2003-1,10,11,12,13,26,28,11 issueStr = colArray[0] replaceWord = '' if len(issueStr) == 6: replaceWord = '00' elif len(issueStr) == 7: replaceWord = '0' elif len(issueStr) == 8: replaceWord = '' ssqInfo.issue = issueStr.replace('-', replaceWord) ssqInfo.red = '%s %s %s %s %s %s' % (colArray[1], colArray[2], colArray[3], colArray[4], colArray[5], colArray[6]) ssqInfo.blue = '%s' % colArray[7] ssqInfo.save() self.response.out.write('%d is Done<br/>' % idx)
def get(self): f = open('num3.csv', 'r') for idx,l in enumerate(f): l = l.replace('\n','') colArray = l.split(',') if len(colArray) == 8 : ssqInfo = SsqInfo() #2003-1,10,11,12,13,26,28,11 issueStr = colArray[0]; replaceWord = '' if len(issueStr) == 6 : replaceWord = '00' elif len(issueStr) == 7 : replaceWord = '0' elif len(issueStr) == 8 : replaceWord = '' ssqInfo.issue = issueStr.replace('-',replaceWord) ssqInfo.red = '%s %s %s %s %s %s' % (colArray[1],colArray[2],colArray[3],colArray[4],colArray[5],colArray[6]) ssqInfo.blue = '%s' % colArray[7] ssqInfo.save() self.response.out.write('%d is Done<br/>' % idx)
def get(self): ssqInfo = None q = SsqInfo.all() q.order('-issue') results = q.fetch(limit=1) if len(results) > 0: ssqInfo = results[0] dict = {} if ssqInfo is not None: if ssqInfo.kjDate is not None : dict["kjDate"] = ssqInfo.kjDate if ssqInfo.issue is not None : dict["issue"] = ssqInfo.issue if ssqInfo.red is not None : dict["red"] = ssqInfo.red if ssqInfo.blue is not None : dict["blue"] = ssqInfo.blue if ssqInfo.ballNum is not None : dict["ballNum"] = ssqInfo.ballNum if ssqInfo.poolMoneyAmount is not None : dict["poolMoneyAmount"] = ssqInfo.poolMoneyAmount if ssqInfo.soldMoneyAmount is not None : dict["soldMoneyAmount"] = ssqInfo.soldMoneyAmount if ssqInfo.oneMoneyAmount is not None : dict["oneMoneyAmount"] = ssqInfo.oneMoneyAmount if ssqInfo.oneBetAmount is not None : dict["oneBetAmount"] = ssqInfo.oneBetAmount if ssqInfo.twoMoneyAmount is not None : dict["twoMoneyAmount"] = ssqInfo.twoMoneyAmount if ssqInfo.twoBetAmount is not None : dict["twoBetAmount"] = ssqInfo.twoBetAmount if ssqInfo.threeMoneyAmount is not None : dict["threeMoneyAmount"] = ssqInfo.threeMoneyAmount if ssqInfo.threeBetAmount is not None : dict["threeBetAmount"] = ssqInfo.threeBetAmount if ssqInfo.fourMoneyAmount is not None : dict["fourMoneyAmount"] = ssqInfo.fourMoneyAmount if ssqInfo.fourBetAmount is not None : dict["fourBetAmount"] = ssqInfo.fourBetAmount if ssqInfo.fiveMoneyAmount is not None : dict["fiveMoneyAmount"] = ssqInfo.fiveMoneyAmount if ssqInfo.fiveBetAmount is not None : dict["fiveBetAmount"] = ssqInfo.fiveBetAmount if ssqInfo.sixMoneyAmount is not None : dict["sixMoneyAmount"] = ssqInfo.sixMoneyAmount if ssqInfo.sixBetAmount is not None : dict["sixBetAmount"] = ssqInfo.sixBetAmount self.response.out.write(json.dumps(dict))
def get(self): issue = 2013001 #需要的开奖期号 ssqInfo = None q = SsqInfo.all() q.order('-issue') results = q.fetch(limit=1) if len(results) > 0: ssqInfo = results[0] if ssqInfo is not None: issue = int(ssqInfo.issue) + 1 url = "http://kj.zhcw.com/kjData/2012/zhcw_ssq_index_last30.js" result = urlfetch.fetch(url) if result.status_code == 200: doc = result.content self.lastDataByIssue(doc, issue)
def get(self): issue = 2013001 #需要的开奖期号 ssqInfo = None q = SsqInfo.all() q.order('-issue') results = q.fetch(limit=1) if len(results) > 0: ssqInfo = results[0] if ssqInfo is not None: issue = int(ssqInfo.issue) + 1 url = "http://kj.zhcw.com/kjData/2012/zhcw_ssq_index_last30.js" result = urlfetch.fetch(url) if result.status_code == 200: doc = result.content self.lastDataByIssue(doc,issue)
def get(self): self.response.out.write('there are %d records in DB!!<br/>' % SsqInfo.all(keys_only=True).count(999999))
def get(self): beginIssue = None #起始期号 pageCount = 15 #分页数量 try: beginIssue = self.request.headers['beginIssue'] except: pass q = SsqInfo.all() if beginIssue is not None : q.filter('issue <', beginIssue) q.order('-issue') results = q.fetch(limit=pageCount) resultArray = [] if len(results) > 0 : for ssqInfo in results : dict = {} if ssqInfo.kjDate is not None : dict["kjDate"] = ssqInfo.kjDate if ssqInfo.issue is not None : dict["issue"] = ssqInfo.issue if ssqInfo.red is not None : dict["red"] = ssqInfo.red if ssqInfo.blue is not None : dict["blue"] = ssqInfo.blue if ssqInfo.ballNum is not None : dict["ballNum"] = ssqInfo.ballNum if ssqInfo.poolMoneyAmount is not None : dict["poolMoneyAmount"] = ssqInfo.poolMoneyAmount if ssqInfo.soldMoneyAmount is not None : dict["soldMoneyAmount"] = ssqInfo.soldMoneyAmount if ssqInfo.oneMoneyAmount is not None : dict["oneMoneyAmount"] = ssqInfo.oneMoneyAmount if ssqInfo.oneBetAmount is not None : dict["oneBetAmount"] = ssqInfo.oneBetAmount if ssqInfo.twoMoneyAmount is not None : dict["twoMoneyAmount"] = ssqInfo.twoMoneyAmount if ssqInfo.twoBetAmount is not None : dict["twoBetAmount"] = ssqInfo.twoBetAmount if ssqInfo.threeMoneyAmount is not None : dict["threeMoneyAmount"] = ssqInfo.threeMoneyAmount if ssqInfo.threeBetAmount is not None : dict["threeBetAmount"] = ssqInfo.threeBetAmount if ssqInfo.fourMoneyAmount is not None : dict["fourMoneyAmount"] = ssqInfo.fourMoneyAmount if ssqInfo.fourBetAmount is not None : dict["fourBetAmount"] = ssqInfo.fourBetAmount if ssqInfo.fiveMoneyAmount is not None : dict["fiveMoneyAmount"] = ssqInfo.fiveMoneyAmount if ssqInfo.fiveBetAmount is not None : dict["fiveBetAmount"] = ssqInfo.fiveBetAmount if ssqInfo.sixMoneyAmount is not None : dict["sixMoneyAmount"] = ssqInfo.sixMoneyAmount if ssqInfo.sixBetAmount is not None : dict["sixBetAmount"] = ssqInfo.sixBetAmount resultArray.append(dict) self.response.out.write(json.dumps(resultArray))
def lastDataByIssue(self, doc, issue): """根据开奖期号分析双色球原数据,并把目标数据转换为期望的数据结构""" if doc is None: return None self.response.out.write('we need issue is %s <br/>' % str(issue)) ssqInfo = SsqInfo() kjDataRE = re.compile(r'var kjData_1 = eval\(\'\(\' \+ \'' r'(?P<data>.*)\' \+ \'\)\'\)\;') zjDataRE = re.compile(r'var zjData_1 = eval\(\'\(\' \+ \'' r'(?P<data>.*)\' \+ \'\)\'\)\;') for l in doc.split('\n'): kjData = kjDataRE.search(l) if kjData: kjDict = ast.literal_eval(kjData.group('data')) if kjDict.has_key(str(issue)): self.response.out.write('date :\t %s <br/>' % kjDict[str(issue)]['kjDate']) self.response.out.write('issue :\t %s <br/>' % kjDict[str(issue)]['kjIssue']) self.response.out.write('red :\t %s <br/>' % kjDict[str(issue)]['kjZNum']) self.response.out.write('blue :\t %s <br/>' % kjDict[str(issue)]['kjTNum']) ssqInfo.kjDate = kjDict[str(issue)]['kjDate'] ssqInfo.issue = kjDict[str(issue)]['kjIssue'] ssqInfo.red = kjDict[str(issue)]['kjZNum'] ssqInfo.blue = kjDict[str(issue)]['kjTNum'] zjData = zjDataRE.search(l) if zjData: zjDict = ast.literal_eval(zjData.group('data')) if zjDict.has_key(str(issue)): self.response.out.write('本期开奖采用 :\t 第%s套球<br/>' % zjDict[str(issue)]['QNum']) self.response.out.write('奖池累计金额 :\t %d<br/>' % zjDict[str(issue)]['jcMoney']) self.response.out.write('本期销售额 :\t %d<br/>' % zjDict[str(issue)]['tzMoney']) ssqInfo.ballNum = zjDict[str(issue)]['QNum'] ssqInfo.poolMoneyAmount = zjDict[str(issue)]['jcMoney'] ssqInfo.soldMoneyAmount = zjDict[str(issue)]['tzMoney'] self.response.out.write('一等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['oneJ']) self.response.out.write('一等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['oneZ']) ssqInfo.oneBetAmount = zjDict[str(issue)]['oneZ'] ssqInfo.oneMoneyAmount = float(zjDict[str(issue)]['oneJ']) self.response.out.write('二等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['twoJ']) self.response.out.write('二等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['twoZ']) ssqInfo.twoBetAmount = zjDict[str(issue)]['twoZ'] ssqInfo.twoMoneyAmount = float(zjDict[str(issue)]['twoJ']) self.response.out.write('三等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['threeJ']) self.response.out.write('三等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['threeZ']) ssqInfo.threeBetAmount = zjDict[str(issue)]['threeZ'] ssqInfo.threeMoneyAmount = float( zjDict[str(issue)]['threeJ']) self.response.out.write('四等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['fourJ']) self.response.out.write('四等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['fourZ']) ssqInfo.fourBetAmount = zjDict[str(issue)]['fourZ'] ssqInfo.fourMoneyAmount = float( zjDict[str(issue)]['fourJ']) self.response.out.write('五等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['fiveJ']) self.response.out.write('五等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['fiveZ']) ssqInfo.fiveBetAmount = zjDict[str(issue)]['fiveZ'] ssqInfo.fiveMoneyAmount = float( zjDict[str(issue)]['fiveJ']) self.response.out.write('六等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['sixJ']) self.response.out.write('六等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['sixZ']) ssqInfo.sixBetAmount = zjDict[str(issue)]['sixZ'] ssqInfo.sixMoneyAmount = float(zjDict[str(issue)]['sixJ']) ssqInfo.save() self.response.out.write('<br/><br/>All things have DONE!!')
def lastDataByIssue(self,doc,issue): """根据开奖期号分析双色球原数据,并把目标数据转换为期望的数据结构""" if doc is None: return None self.response.out.write( 'we need issue is %s <br/>' % str(issue)) ssqInfo = SsqInfo() kjDataRE = re.compile(r'var kjData_1 = eval\(\'\(\' \+ \'' r'(?P<data>.*)\' \+ \'\)\'\)\;') zjDataRE = re.compile(r'var zjData_1 = eval\(\'\(\' \+ \'' r'(?P<data>.*)\' \+ \'\)\'\)\;') for l in doc.split('\n'): kjData = kjDataRE.search(l) if kjData: kjDict = ast.literal_eval(kjData.group('data')) if kjDict.has_key(str(issue)): self.response.out.write( 'date :\t %s <br/>' % kjDict[str(issue)]['kjDate']) self.response.out.write( 'issue :\t %s <br/>' % kjDict[str(issue)]['kjIssue']) self.response.out.write( 'red :\t %s <br/>' % kjDict[str(issue)]['kjZNum']) self.response.out.write( 'blue :\t %s <br/>' % kjDict[str(issue)]['kjTNum']) ssqInfo.kjDate = kjDict[str(issue)]['kjDate'] ssqInfo.issue = kjDict[str(issue)]['kjIssue'] ssqInfo.red = kjDict[str(issue)]['kjZNum'] ssqInfo.blue = kjDict[str(issue)]['kjTNum'] zjData = zjDataRE.search(l) if zjData: zjDict = ast.literal_eval(zjData.group('data')) if zjDict.has_key(str(issue)): self.response.out.write( '本期开奖采用 :\t 第%s套球<br/>' % zjDict[str(issue)]['QNum']) self.response.out.write( '奖池累计金额 :\t %d<br/>' % zjDict[str(issue)]['jcMoney']) self.response.out.write( '本期销售额 :\t %d<br/>' % zjDict[str(issue)]['tzMoney']) ssqInfo.ballNum = zjDict[str(issue)]['QNum'] ssqInfo.poolMoneyAmount = zjDict[str(issue)]['jcMoney'] ssqInfo.soldMoneyAmount = zjDict[str(issue)]['tzMoney'] self.response.out.write( '一等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['oneJ']) self.response.out.write( '一等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['oneZ']) ssqInfo.oneBetAmount = zjDict[str(issue)]['oneZ'] ssqInfo.oneMoneyAmount = float(zjDict[str(issue)]['oneJ']) self.response.out.write( '二等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['twoJ']) self.response.out.write( '二等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['twoZ']) ssqInfo.twoBetAmount = zjDict[str(issue)]['twoZ'] ssqInfo.twoMoneyAmount = float(zjDict[str(issue)]['twoJ']) self.response.out.write( '三等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['threeJ']) self.response.out.write( '三等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['threeZ']) ssqInfo.threeBetAmount = zjDict[str(issue)]['threeZ'] ssqInfo.threeMoneyAmount = float(zjDict[str(issue)]['threeJ']) self.response.out.write( '四等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['fourJ']) self.response.out.write( '四等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['fourZ']) ssqInfo.fourBetAmount = zjDict[str(issue)]['fourZ'] ssqInfo.fourMoneyAmount = float(zjDict[str(issue)]['fourJ']) self.response.out.write( '五等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['fiveJ']) self.response.out.write( '五等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['fiveZ']) ssqInfo.fiveBetAmount = zjDict[str(issue)]['fiveZ'] ssqInfo.fiveMoneyAmount = float(zjDict[str(issue)]['fiveJ']) self.response.out.write( '六等奖 单注中奖金额(元) :\t %d<br/>' % zjDict[str(issue)]['sixJ']) self.response.out.write( '六等奖 中奖注数(注) :\t %d<br/>' % zjDict[str(issue)]['sixZ']) ssqInfo.sixBetAmount = zjDict[str(issue)]['sixZ'] ssqInfo.sixMoneyAmount = float(zjDict[str(issue)]['sixJ']) ssqInfo.save() self.response.out.write( '<br/><br/>All things have DONE!!')