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)