Show-Me-the-Code · horx · Sep 18, 2017 · Sep 18, 2017 · Sep 18, 2017
diff --git a/wssywh/0001/0001.py b/wssywh/0001/0001.py
@@ -0,0 +1,19 @@
+#coding:utf-8
+
+"""第0001题：做为Apple Store App独立开发者，你要搞限时促销，为你的应用生成激活码（或者优惠券），
+使用Python如何生成200个激活码（或者优惠券）？"""
+
+
+
+import uuid
+
+def get_id(num):
+    list_id = []
+    for i in range(num):
+        id = str(uuid.uuid1()).replace('-','')
+        list_id.append(id)
+    return list_id
+id = get_id(200)
+with open("file_id.txt","w") as file:
+    for i in id:
+        file.write(i+"\n")
diff --git a/wssywh/0001/file_id b/wssywh/0001/file_id
diff --git a/wssywh/0001/file_id.txt b/wssywh/0001/file_id.txt
@@ -0,0 +1,200 @@
+bac213149c1c11e791d47427ea33ef0a
+bac213159c1c11e791d47427ea33ef0a
+bac213169c1c11e791d47427ea33ef0a
+bac213179c1c11e791d47427ea33ef0a
+bac213189c1c11e791d47427ea33ef0a
+bac213199c1c11e791d47427ea33ef0a
+bac2131a9c1c11e791d47427ea33ef0a
+bac2131b9c1c11e791d47427ea33ef0a
+bac2131c9c1c11e791d47427ea33ef0a
+bac2131d9c1c11e791d47427ea33ef0a
+bac2131e9c1c11e791d47427ea33ef0a
+bac2131f9c1c11e791d47427ea33ef0a
+bac213209c1c11e791d47427ea33ef0a
+bac213219c1c11e791d47427ea33ef0a
+bac213229c1c11e791d47427ea33ef0a
+bac213239c1c11e791d47427ea33ef0a
+bac213249c1c11e791d47427ea33ef0a
+bac213259c1c11e791d47427ea33ef0a
+bac213269c1c11e791d47427ea33ef0a
+bac213279c1c11e791d47427ea33ef0a
+bac213289c1c11e791d47427ea33ef0a
+bac213299c1c11e791d47427ea33ef0a
+bac2132a9c1c11e791d47427ea33ef0a
+bac2132b9c1c11e791d47427ea33ef0a
+bac2132c9c1c11e791d47427ea33ef0a
+bac2132d9c1c11e791d47427ea33ef0a
+bac2132e9c1c11e791d47427ea33ef0a
+bac2132f9c1c11e791d47427ea33ef0a
+bac213309c1c11e791d47427ea33ef0a
+bac213319c1c11e791d47427ea33ef0a
+bac213329c1c11e791d47427ea33ef0a
+bac213339c1c11e791d47427ea33ef0a
+bac213349c1c11e791d47427ea33ef0a
+bac213359c1c11e791d47427ea33ef0a
+bac213369c1c11e791d47427ea33ef0a
+bac213379c1c11e791d47427ea33ef0a
+bac213389c1c11e791d47427ea33ef0a
+bac213399c1c11e791d47427ea33ef0a
+bac2133a9c1c11e791d47427ea33ef0a
+bac2133b9c1c11e791d47427ea33ef0a
+bac2133c9c1c11e791d47427ea33ef0a
+bac2133d9c1c11e791d47427ea33ef0a
+bac2133e9c1c11e791d47427ea33ef0a
+bac2133f9c1c11e791d47427ea33ef0a
+bac213409c1c11e791d47427ea33ef0a
+bac213419c1c11e791d47427ea33ef0a
+bac213429c1c11e791d47427ea33ef0a
+bac213439c1c11e791d47427ea33ef0a
+bac213449c1c11e791d47427ea33ef0a
+bac213459c1c11e791d47427ea33ef0a
+bac213469c1c11e791d47427ea33ef0a
+bac213479c1c11e791d47427ea33ef0a
+bac213489c1c11e791d47427ea33ef0a
+bac213499c1c11e791d47427ea33ef0a
+bac2134a9c1c11e791d47427ea33ef0a
+bac2134b9c1c11e791d47427ea33ef0a
+bac2134c9c1c11e791d47427ea33ef0a
+bac2134d9c1c11e791d47427ea33ef0a
+bac2134e9c1c11e791d47427ea33ef0a
+bac2134f9c1c11e791d47427ea33ef0a
+bac213509c1c11e791d47427ea33ef0a
+bac213519c1c11e791d47427ea33ef0a
+bac213529c1c11e791d47427ea33ef0a
+bac213539c1c11e791d47427ea33ef0a
+bac213549c1c11e791d47427ea33ef0a
+bac213559c1c11e791d47427ea33ef0a
+bac213569c1c11e791d47427ea33ef0a
+bac213579c1c11e791d47427ea33ef0a
+bac213589c1c11e791d47427ea33ef0a
+bac213599c1c11e791d47427ea33ef0a
+bac2135a9c1c11e791d47427ea33ef0a
+bac2135b9c1c11e791d47427ea33ef0a
+bac2135c9c1c11e791d47427ea33ef0a
+bac2135d9c1c11e791d47427ea33ef0a
+bac2135e9c1c11e791d47427ea33ef0a
+bac2135f9c1c11e791d47427ea33ef0a
+bac213609c1c11e791d47427ea33ef0a
+bac213619c1c11e791d47427ea33ef0a
+bac213629c1c11e791d47427ea33ef0a
+bac213639c1c11e791d47427ea33ef0a
+bac213649c1c11e791d47427ea33ef0a
+bac213659c1c11e791d47427ea33ef0a
+bac213669c1c11e791d47427ea33ef0a
+bac213679c1c11e791d47427ea33ef0a
+bac213689c1c11e791d47427ea33ef0a
+bac213699c1c11e791d47427ea33ef0a
+bac2136a9c1c11e791d47427ea33ef0a
+bac2136b9c1c11e791d47427ea33ef0a
+bac2136c9c1c11e791d47427ea33ef0a
+bac2136d9c1c11e791d47427ea33ef0a
+bac2136e9c1c11e791d47427ea33ef0a
+bac2136f9c1c11e791d47427ea33ef0a
+bac213709c1c11e791d47427ea33ef0a
+bac213719c1c11e791d47427ea33ef0a
+bac213729c1c11e791d47427ea33ef0a
+bac213739c1c11e791d47427ea33ef0a
+bac213749c1c11e791d47427ea33ef0a
+bac213759c1c11e791d47427ea33ef0a
+bac213769c1c11e791d47427ea33ef0a
+bac213779c1c11e791d47427ea33ef0a
+bac213789c1c11e791d47427ea33ef0a
+bac213799c1c11e791d47427ea33ef0a
+bac2137a9c1c11e791d47427ea33ef0a
+bac2137b9c1c11e791d47427ea33ef0a
+bac2137c9c1c11e791d47427ea33ef0a
+bac2137d9c1c11e791d47427ea33ef0a
+bac2137e9c1c11e791d47427ea33ef0a
+bac2137f9c1c11e791d47427ea33ef0a
+bac213809c1c11e791d47427ea33ef0a
+bac213819c1c11e791d47427ea33ef0a
+bac213829c1c11e791d47427ea33ef0a
+bac213839c1c11e791d47427ea33ef0a
+bac213849c1c11e791d47427ea33ef0a
+bac213859c1c11e791d47427ea33ef0a
+bac213869c1c11e791d47427ea33ef0a
+bac213879c1c11e791d47427ea33ef0a
+bac213889c1c11e791d47427ea33ef0a
+bac213899c1c11e791d47427ea33ef0a
+bac2138a9c1c11e791d47427ea33ef0a
+bac2138b9c1c11e791d47427ea33ef0a
+bac2138c9c1c11e791d47427ea33ef0a
+bac2138d9c1c11e791d47427ea33ef0a
+bac2138e9c1c11e791d47427ea33ef0a
+bac2138f9c1c11e791d47427ea33ef0a
+bac213909c1c11e791d47427ea33ef0a
+bac213919c1c11e791d47427ea33ef0a
+bac213929c1c11e791d47427ea33ef0a
+bac213939c1c11e791d47427ea33ef0a
+bac213949c1c11e791d47427ea33ef0a
+bac213959c1c11e791d47427ea33ef0a
+bac213969c1c11e791d47427ea33ef0a
+bac213979c1c11e791d47427ea33ef0a
+bac213989c1c11e791d47427ea33ef0a
+bac213999c1c11e791d47427ea33ef0a
+bac2139a9c1c11e791d47427ea33ef0a
+bac2139b9c1c11e791d47427ea33ef0a
+bac2139c9c1c11e791d47427ea33ef0a
+bac2139d9c1c11e791d47427ea33ef0a
+bac2139e9c1c11e791d47427ea33ef0a
+bac2139f9c1c11e791d47427ea33ef0a
+bac213a09c1c11e791d47427ea33ef0a
+bac213a19c1c11e791d47427ea33ef0a
+bac213a29c1c11e791d47427ea33ef0a
+bac213a39c1c11e791d47427ea33ef0a
+bac213a49c1c11e791d47427ea33ef0a
+bac213a59c1c11e791d47427ea33ef0a
+bac213a69c1c11e791d47427ea33ef0a
+bac213a79c1c11e791d47427ea33ef0a
+bac213a89c1c11e791d47427ea33ef0a
+bac213a99c1c11e791d47427ea33ef0a
+bac213aa9c1c11e791d47427ea33ef0a
+bac213ab9c1c11e791d47427ea33ef0a
+bac213ac9c1c11e791d47427ea33ef0a
+bac213ad9c1c11e791d47427ea33ef0a
+bac213ae9c1c11e791d47427ea33ef0a
+bac213af9c1c11e791d47427ea33ef0a
+bac213b09c1c11e791d47427ea33ef0a
+bac213b19c1c11e791d47427ea33ef0a
+bac213b29c1c11e791d47427ea33ef0a
+bac213b39c1c11e791d47427ea33ef0a
+bac213b49c1c11e791d47427ea33ef0a
+bac213b59c1c11e791d47427ea33ef0a
+bac213b69c1c11e791d47427ea33ef0a
+bac213b79c1c11e791d47427ea33ef0a
+bac213b89c1c11e791d47427ea33ef0a
+bac213b99c1c11e791d47427ea33ef0a
+bac213ba9c1c11e791d47427ea33ef0a
+bac213bb9c1c11e791d47427ea33ef0a
+bac213bc9c1c11e791d47427ea33ef0a
+bac213bd9c1c11e791d47427ea33ef0a
+bac213be9c1c11e791d47427ea33ef0a
+bac213bf9c1c11e791d47427ea33ef0a
+bac213c09c1c11e791d47427ea33ef0a
+bac213c19c1c11e791d47427ea33ef0a
+bac213c29c1c11e791d47427ea33ef0a
+bac213c39c1c11e791d47427ea33ef0a
+bac213c49c1c11e791d47427ea33ef0a
+bac213c59c1c11e791d47427ea33ef0a
+bac213c69c1c11e791d47427ea33ef0a
+bac213c79c1c11e791d47427ea33ef0a
+bac213c89c1c11e791d47427ea33ef0a
+bac213c99c1c11e791d47427ea33ef0a
+bac213ca9c1c11e791d47427ea33ef0a
+bac213cb9c1c11e791d47427ea33ef0a
+bac213cc9c1c11e791d47427ea33ef0a
+bac213cd9c1c11e791d47427ea33ef0a
+bac213ce9c1c11e791d47427ea33ef0a
+bac213cf9c1c11e791d47427ea33ef0a
+bac213d09c1c11e791d47427ea33ef0a
+bac213d19c1c11e791d47427ea33ef0a
+bac213d29c1c11e791d47427ea33ef0a
+bac213d39c1c11e791d47427ea33ef0a
+bac213d49c1c11e791d47427ea33ef0a
+bac213d59c1c11e791d47427ea33ef0a
+bac213d69c1c11e791d47427ea33ef0a
+bac213d79c1c11e791d47427ea33ef0a
+bac213d89c1c11e791d47427ea33ef0a
+bac213d99c1c11e791d47427ea33ef0a
+bac213da9c1c11e791d47427ea33ef0a
+bac213db9c1c11e791d47427ea33ef0a
diff --git a/wssywh/0002/0002.py b/wssywh/0002/0002.py
@@ -0,0 +1,24 @@
+#coding:utf-8
+"""第 0002 题：将 0001 题生成的 200 个激活码（或者优惠券）保存到 MySQL 关系型数据库中。"""
+
+import MySQLdb
+
+list_id = []
+with open("../0001/file_id.txt",'r') as file:
+    files = file.readlines()
+    for content in files:
+        list_id.append(str(content).replace('\n',''))
+try:
+    conn = MySQLdb.connect(host='localhost',user='root',passwd='123456',port=3306)
+    cur = conn.cursor()
+    cur.execute('create database if not exists test')
+    conn.select_db('test')
+    cur.execute('create table if not exists Activation_code(id int ,uuid varchar(50))')
+    for i in range(len(list_id)):
+        cur.execute('insert into Activation_code values(%s,%s)',(i,list_id[i]))
+    conn.commit()
+    cur.close()
+    conn.close()
+except MySQLdb.Error as e:
+    print("Mysql Error %d: %s" % (e.args[0], e.args[1]))
+