def updatePairData():
results = get_long_data()
insertPairData(results)
def updateThripleData():
results = get_long_data()
insertThripleData(results)
pair_list = list(combinations(range(1, 34), 2))
for i in pair_list:
count=0
for j in results:
if set(i).issubset(set(j)):
count+=1
data_tuple=(str(i),count)
values.append(data_tuple)
try:
del_sql="TRUNCATE TABLE pair_num"
cur.execute(del_sql)
# 执行sql语句
cur.executemany(sql_all, values)
# cur.execute(sql)
# 提交到数据库执行
conn.commit()
except Exception as e:
print(e)
# 如果发生错误则回滚
conn.rollback()
cur.close()
conn.close()
def updatePairData():
results = get_long_data()
insertPairData(results)
if __name__ =='__main__':
results=get_long_data()
# # results=((3,5,9,11,25,28),(1,5,9,11,25,28),(2,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(2,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(2,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(2,5,9,11,25,28),(2,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(1,5,9,11,25,28),(2,5,9,11,25,28),(2,5,9,11,25,28),)
# results=((1,2,3,4,5,6),)
insertPairData(results)
# print(get_prime_number_count((1,2,3,4,22,30)))
def updateDHR():
results = get_long_data()
insertDHRData(results)