def analyse_raw_data():
conn = DBUtil.getConnection("192.168.245.128", "slf", "slf1234", "SLF_DB")
sql = "SELECT trem_No,blue_Num,red_Num FROM TBL_Lottery_Raw_Data"
data = DBUtil.getDataBySQL(sql, conn)
if len(data) > 0:
final = []
for rawData in data:
tmp = [rawData[0]]
blue = (rawData[1].strip(",")).split(",")
red = (rawData[2].strip(",")).split(",")
if len(blue) == 5 and len(red) == 2:
blue.sort()
red.sort()
tmp += blue
tmp += red
# 计算每一组中奖数据的离散情况
ls_blue = _get_lsval(blue)
ls_red = _get_lsval(red)
tmp.append(ls_blue)
tmp.append(ls_red)
final.append(tmp)
if len(final) > 0:
# 这边对连接进行关闭
persistData.saveAnalysedData(final)
return len(final)
def saveDltData(dltdatas):
conn = DBUtil.getConnection("192.168.245.128", "slf", "slf1234", "SLF_DB")
for row in dltdatas:
sql = '''INSERT INTO TBL_Lottery_Raw_Data(trem_No,blue_Num,red_num) VALUES('{0}','{1}','{2}')'''.format(*row)
DBUtil.saveData(sql, conn)
conn.commit()
DBUtil.closeConnection(conn)
def saveAnalysedData(analyseDatas):
conn = DBUtil.getConnection("192.168.245.128", "slf", "slf1234", "SLF_DB")
for row in analyseDatas:
sql = '''INSERT INTO TBL_Lottery_analysed_Data(trem_No,blue_No1,blue_No2,blue_No3,blue_No4,blue_No5,red_No1, red_No2,ls_blue,ls_red)
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')'''.format(*row)
DBUtil.saveData(sql, conn)
conn.commit()
DBUtil.closeConnection(conn)
def batchSaveLotteryNumberPoolRed(red_nums_list):
# 根据两个参数进行全连接进行数据的保存
conn = DBUtil.getConnection("192.168.245.128", "slf", "slf1234", "SLF_DB")
# 循环保存所有可能的组合
for x in red_nums_list:
sql = '''insert into TBL_Lottery_Number_pool_red(red_No1,red_No2)
VALUES ('{0}','{1}') '''.format(*x)
DBUtil.saveData(sql, conn)
conn.commit()
DBUtil.closeConnection(conn)
return None
def select_nums():
conn = DBUtil.getConnection("192.168.245.128", "slf", "slf1234", "SLF_DB")
sql = "SELECT ls_blue,ls_red FROM TBL_Lottery_analysed_Data"
data = DBUtil.getDataBySQL(sql, conn)
