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