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 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)
