python习题：双色球，把号码写到数据库里

import random
import pymysql,datetime
def add_zero(num):
    if len(num) == 1:
        num = '0' + num
    return num

def tickets(num: int):
    all_nums = []  # 存放所有的结果 [ ['06,05,27,22,14,17', '07','2018-01-23'], ['10,06,11,19,28,24', '09']]
    all_blues = list(map(add_zero, [str(x) for x in range(1, 17)]))
    all_reds = list(map(add_zero, [str(x) for x in range(1, 34)]))
    for i in range(num):  # 循环一次就是生成一个篮球、6个红球
        new_all_reds = all_reds[:]  # 写这里是为了不让删空
        tmp_reds = []#存每次随机生成红球
        for i in range(6):
            choice = random.choice(new_all_reds)
            tmp_reds.append(choice)
            new_all_reds.remove(choice)
        blue = random.choice(all_blues)
        red = ','.join(tmp_reds)  #'01,02,03'
        all_nums.append([red, blue,datetime.datetime.now().strftime('%Y-%d-%m %H:%M%S')])
    return all_nums

def insert_db(list):
    conn = pymysql.connect(host='211.149.218.16',
      user='jxz',password='123456',#port这里一定要写int类型
      port=3306,db='jxz',charset='utf8')
    cur = conn.cursor()
    cur.executemany('insert into seq(red,blue,date)values (%s,%s,%s);',list)
    conn.commit()
    cur.close()
    conn.close()

res = tickets(10)
insert_db(res)