Merge pull request Show-Me-the-Code#83 from razzl/master

horx · horx · commit 1134c37b8f72 · 2015-03-30T16:23:12.000+08:00
razzl
diff --git a/razzl/0000/0000.py b/razzl/0000/0000.py
@@ -0,0 +1,22 @@
+#!/usr/bin/env python
+
+'''
+Draw a number on the image
+'''
+
+try:
+	from PIL import Image
+	from PIL import ImageDraw
+	from PIL import ImageFont
+except ImportError:
+	import Image,ImageFont,ImageDraw
+
+def draw_number(path = '/root/Desktop/1.jpg',num = 4):
+	im = Image.open(path)#open the picture
+	size = im.size#get the size of the picture
+	fontsize = size[0]/4
+	draw = ImageDraw.Draw(im)#the ImageDraw.Draw will rerturn a object then you can draw it
+	font = ImageFont.truetype('/usr/share/fonts/dejavu/DejVuSans.ttf',fontsize)#define the font and size of the number 
+	draw.text((3*fontsize,0),str(num),(255, 0, 0),font)#draw it 
+	im.save('/root/Desktop/2.jpg')#save
+draw_number()
diff --git a/razzl/0001/0001.py b/razzl/0001/0001.py
@@ -0,0 +1,17 @@
+#!/usr/bin/env python
+
+'''
+It can generate the activation code
+'''
+
+import random
+#import string
+
+f = open('C:\Users\zzl\Desktop\2.txt','w')
+for x in range(200):
+	words = [chr(a) for a in range(65,91)]+[chr(a) for a in range(97,122)]+[str(a) for a in range(0,11)]
+	# It is equal to string.ascii_letters + string.digits
+	slice = random.sample(words,10)
+	temp = str(words)
+	f.write(temp)
+f.close()
diff --git a/razzl/0002/0002.py b/razzl/0002/0002.py
@@ -0,0 +1,39 @@
+#!/usr/bin/env python
+
+'''
+	It can save the contents of the file to the mysql database.
+'''
+
+import os
+import random
+import MySQLdb
+#import string
+
+f = open(os.getcwd()+'\\2','w')
+for x in range(200):
+	words = [chr(a) for a in range(65,91)]+[chr(a) for a in range(97,122)]+[str(a) for a in range(0,11)]
+	# It is equal to string.ascii_letters + string.digits
+	slices = random.sample(words,10)
+	#temp = str(slices)
+	temp = "".join(slices)+'\n'
+	#print temp
+	f.write(temp)
+f.close()
+
+f = open(os.getcwd()+'\\2','r')
+words = f.readlines()
+try:
+	conn = MySQLdb.connect(host = 'localhost', user = 'root', passwd = '******', port = 3306)#connet to your local database of mysql
+
+	cur = conn.cursor()
+
+	conn.select_db('python')
+
+	count = cur.executemany('insert into test(name) values(%s)',words)#executemant need two parameters sql statement and list
+
+	conn.commit()#commit the implementation results
+	cur.close()#close the cursor
+	conn.close()# close the connect
+except MySQLdb.Error,e:
+	print "Mysql Error %d: %s" % (e.args[0], e.args[1])
+
