Python 练习册，每天一个小程序(0002)

第 0002 题：
将 0001 题生成的 200 个**码（或者优惠券）保存到 MySQL 关系型数据库中。
代码

import random
import pymysql
db=pymysql.connect(host="localhost",
                  user="root",
                  password="****",
                  db="big_database",
                  charset="utf8")

def getKeys():
   list=[]
   str=string.ascii_uppercase
   for i in range(200):
       key = ""
       for j in range(16):
           key+=random.choice(str)
           if (j+1)%4==0 and j !=15:
               key+="-"
       if not key in list:
           list.append(key)
           print(key)
       else:
           i-=1
   return list
def main():
   list=getKeys()
   try:
       with db.cursor() as cursor:
           for i in range(200):
               sql="insert into pythoneveryday0002keys (keyName) values  ('"+\
                   list[i]+"');"
               print("执行sql："+sql)
               cursor.execute(sql)
           cursor.connection.commit()
   finally:
       db.close()

main()

结果