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
