add

Forec · Forec · commit def94ffe0097 · 2015-12-01T14:42:03.000+08:00
diff --git a/Forec/0002/0002.py b/Forec/0002/0002.py
@@ -0,0 +1,46 @@
+# coding = utf-8
+__author__ = 'Forec'
+
+# 保随机码至MySQL
+
+import pymysql
+import random
+
+def make_number( num, length ):
+    letters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'
+    dic = set()
+    i = 0
+    while i < num:
+        str = ''
+        for j in range(length):
+            str += random.choice(letters)
+        if str not in dic:
+            dic |= {str}
+            i += 1
+        else:
+            continue
+    return dic
+
+def save( dic ):
+    connect = pymysql.connect(
+        host = '127.0.0.1',
+        port = 3306,
+        user = 'root',
+        passwd = 'VKDARK'
+    )
+    cur = connect.cursor()
+    try:
+        __create = 'create database if not exists test'
+        cur.execute(__create)
+    except:
+        print('database create error')
+    connect.select_db('test')
+    __create_table = 'create table if not exists codes(code char(64))'
+    cur.execute(__create_table)
+    cur.executemany('insert into codes values(%s)',dic)
+    
+    connect.commit()
+    cur.close()
+    connect.close()
+    
+save(make_number(200,10))
diff --git a/Forec/0004/0004.py b/Forec/0004/0004.py
@@ -0,0 +1,19 @@
+import re
+with open('input.txt',"r") as f:
+    data = f.read()
+
+words = re.compile(r'([a-zA-Z]+)')
+dic = {}
+for x in words.findall(data):
+    if x not in dic:
+        dic[x] = 1
+    else:
+        dic[x] += 1
+L = []
+for k,value in dic.items():
+    L.append((k, value))
+
+L.sort(key = lambda t:t[0])
+
+for x in L:
+    print( x[0], x[1])
diff --git a/Forec/0005/0005.py b/Forec/0005/0005.py
@@ -0,0 +1,12 @@
+from PIL import Image, ImageOps
+import os, os.path
+
+L = [ x for x in os.listdir('.') if os.path.isfile(x) and os.path.splitext(x)[1]=='.jpg' ] 
+
+for x in L:
+    img = Image.open(x)
+    xsize, ysize = img.size
+    xsize = 500
+    ysize = ysize * 500 // xsize
+    img = ImageOps.fit(img,(xsize,ysize))
+    img.save("out"+x)
