python生成激活码

#coding=utf-8
import uuid
import pymysql
'''
uuid库生成128位全局唯一标识符
'''
#生成num个验证码，每个验证码长度位length，可设置默认长度
def create_num(num,length=16):
    result=[]
    while num>0:
        uuid_id=uuid.uuid1()
        temp=str(uuid_id).replace('-','')[:length]
        if temp not in result:
            result.append(temp)
            num-=1
    return result

def save_to_mysql(code):
    conn=pymysql.connect(
        host='127.0.0.1',
        port=3306,
        user='root',
        passwd='root',
        db='test')
    try:
        with conn.cursor() as cursor:
            #获取操作游标
            sql="INSERT INTO `codes`(`code`)VALUES(%s)"
            cursor.execute(sql,code)
            conn.commit()

        with conn.cursor() as cursor:
            sql="SELECT `id`,`code` FROM `codes` WHERE `code`=%s"
            cursor.execute(sql,code)
            # 使用 fetchone() 方法获取一条数据库
            result=cursor.fetchone()
            print(result)
    finally:
        conn.close()
for code in create_num(200):
    save_to_mysql(code)