正如很多同学所知道的,楼主开始学习python了,前进的道路曲曲折折,有荆棘也有陷阱,从最简单的小程序写起,每天练习,将python进行到底。
有一点比较别扭的就是python的换行之后空四个空格,ruby都是两个,并且python在方法和循环语句的第一句都要加冒号.
首先先来做一些准备工作,mysql里查看表结构以及增加列的语句:
show create table user;
alter table user add salt char(10);
md5和sha1大家可以自己选
import hashlib
In [64]: passwd=’111111′
In [67]: md5pass=hashlib.md5(passwd)
In [69]: hashlib.md5(passwd).hexdigest()
Out[69]: ’96e79218965eb72c92a549dd5a330112′
In [70]: hashlib.sha1(passwd).hexdigest()
Out[70]: ‘3d4f2bf07dc1be38b20cd6e46949a1071f9d0e3d’
In [71]: len(hashlib.sha1(passwd).hexdigest())
Out[71]: 40
In [72]: import string
In [73]: import random
In [74]: string.letters
Out[74]: ‘abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ’
In [75]: string.digits
Out[75]: ‘0123456789’
In [76]: string.digits+string.letters
Out[76]: ‘0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ’
In [77]: random.sample(string.letters,5)
Out[77]: [‘S’, ‘E’, ‘w’, ‘F’, ‘L’]
In [78]: ”.join(random.sample(string.letters,10))
Out[78]: ‘RVviZAqLQK’
——————————————–
dbconfig ={
‘host’:’localhost’,
‘user’:’root’,
‘passwd’:”,
‘charset’:’utf8′,
‘db’:’db_02′
}
import MySQLdb
import string
import random
import hashlib
class User(object):
def __init__(self, name, email, passwd,salt):
conn = MySQLdb.connect(**dbconfig)
cursor = conn.cursor()
sql = ‘insert into user(name, email, password, salt) values(%s, %s, %s, %s)’
cursor.execute(sql, (name, email, passwd, salt))
#self.name = name
#self.email = email
conn.commit()
cursor.close()
conn.close()
@staticmethod
def regist( name, email, passwd):
salt,passwd = User.salt_passwd(passwd)
User(name, email, passwd, salt)
@staticmethod
def login(name, passwdin):
conn = MySQLdb.connect(**dbconfig)
cursor = conn.cursor()
sql = ‘select id,name,email,password,salt from user where name=%s’
if cursor.execute(sql, (name,)):
userid,name, email, passwd, salt =cursor.fetchone()
#print cursor.fetchone()
salt_passwdin = hashlib.sha1(salt+passwdin).hexdigest()
if passwd == salt_passwdin:
return userid
return None
#def get_user(userid)
def get_name(self, userid):
return userid, name, email,
@staticmethod
def salt_passwd(passwd):
salt = ”.join(random.sample(string.letters, 10))
passwd = hashlib.sha1(salt+passwd).hexdigest()
return salt, passwd
testuser = {
‘name’:’alen’,
‘passwd’:’111111′,
’email’:’alen@a.com’
}
#User.regist(**testuser)
print User.login(name=’alenaaa’, passwdin=’11111′)