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):
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!!')
