def test_user():
user = User(
email='*****@*****.**',
password='******',
admin=True,
name='龙骑士',
)
user.save()
def testdb(loop):
'test class User - add a new user'
print('Create db pool...')
r = yield from orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome')
print('r : %s' % r)
# 以下为测试:
print('Create a new user...')
"create a user with fixed <id> and <created_at>"
#u = User(email='*****@*****.**', passwd='password', admin=True, name='testname2', image='blank', id='testid2',created_at='1.0')
"create a user with fixed auto-generated <id> and <created_at>"
u = User(email='*****@*****.**',
passwd='password',
admin=True,
name='testname3',
image='blank',
id=None,
created_at=None) #
print('Save the new user into database...')
r = yield from u.save()
print('r : %s' % r)
def api_register_user(*, email, name, passwd): # https://www.python.org/dev/peps/pep-3102/
if not name or not name.strip():
raise APIValueError('name')
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
if not passwd or not _RE_SHA1.match(passwd):
raise APIValueError('passwd')
users = yield from User.findAll('email=?', [email])
if len(users) > 0:
raise APIError('register:failed', 'email', 'email already in use')
uid = next_id()
sha1_passwd = '%s:%s' % (uid, passwd) # get SHA1 for uid+passwd
user = User(id=uid, name=name.strip(), email=email, passwd=hashlib.sha1(sha1_passwd.encode('utf-8')).hexdigest(),
image='http://www.gravatar.com/avatar/%s?d=mm&s=120' % hashlib.md5(email.encode('utf-8')).hexdigest())
yield from user.save()
# make session cookie:
r = web.Response()
r.set_cookie(COOKIE_NAME, user2cookie(user, 86400), max_age=86400, httponly=True)
user.passwd = '******'
r.content_type = 'application/json'
r.body = json.dumps(user, ensure_ascii=False).encode('utf-8')
return r
def api_register_user(*,email,name,passwd):
if not name or not name.strip():
raise APIValueError('name')
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
if not passwd or not _RE_SHA1.match(passwd):
raise APIValueError('passwd')
users=yield from User.findAll('email=?',[email])
if len(users)>0:
raise APIError('register:failed','email','Email is already in use')
uid=next_id()
sha1_passwd='%s:%s'%(uid,passwd)
user=User(id=uid,name=name.strip(),email=email,
passwd=hashlib.sha1(sha1_passwd.encode('utf-8')).hexdigest(),
image='http://www.gravator.com/avatar/%s?d=mm&s=120'%hashlib.md5(email.encode('utf-8')).hexdigest())
yield from user.save()
r=web.Response()
r.set_cookie(COOKIE_NAME,user2cookie(user,86400),max_age=86400,httponly=True)
user.passwd='******'
r.content_type='application/json'
r.body=json.dumps(user,ensure_ascii=False).encode('utf-8')
return r
def test(loop):
yield from create_pool(loop=loop, user='******', password='******', db='test')
u = User(name='aaa', email='*****@*****.**', passwd='aaa', image='about:blank')
yield from u.save()
# r = yield from u.findAll()
# print(r)
yield from destory_pool()
def api_register_user(*, email, name, passwd):
#判断name是否为空：
if not name or not name.strip():
raise APIValueError('name')
#判断email是否为空及是否满足email格式：
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
#判断password首付为空及是否满足password格式：
if not passwd or not _RE_SHA1.match(passwd):
raise APIValueError('passwd')
#数据中查询对应的email信息：
users = yield from User.findAll('email=?', [email])
#判断查询结果是否存在，若存在则返回异常提示邮件已存在：
if len(users) > 0:
raise APIError('register:failed', 'email', 'Email is already in use.')
#生成唯一ID：
uid = next_id()
#重构唯一ID和password成新的字符串：
sha1_passwd = '%s:%s' % (uid, passwd)
#构建用户对象信息：
#hashlib.sha1().hexdigest():取得SHA1哈希摘要算法的摘要值。
user = User(id=uid, name=name.strip(), email=email, passwd=hashlib.sha1(sha1_passwd.encode('utf-8')).hexdigest(), image='http://www(first).gravatar.com/avatar/%s?d=mm&s=120' % hashlib.md5(email.encode('utf-8')).hexdigest())
#将用户信息存储到数据库：
yield from user.save()
# make session cookie:
#构造session cookie信息：
r = web.Response()
#aiohttp.web.StreamResponse().set_cookie()：设置cookie的方法。
r.set_cookie(COOKIE_NAME, user2cookie(user, 86400), max_age=86400, httponly=True) #max_age：定义cookie的有效期(秒)；
user.passwd = '******'
r.content_type = 'application/json'
#以json格式序列化响应信息； ensure_ascii默认为True，非ASCII字符也进行转义。如果为False，这些字符将保持原样。
r.body = json.dumps(user, ensure_ascii=False).encode('utf-8')
return r
def registerUser(*, email, name, password):
if not name or not name.strip():
raise APIValueError('name')
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
if not password or not password.strip():
raise APIValueError('password')
users = yield from User.findAll('email=?', email)
if len(users) > 0:
raise APIError('register:failed', 'email', 'Email is already in use.')
uid = nextId()
sha1Password = '******' % (uid, password)
sha1 = hashlib.sha1(sha1Password.encode('utf-8')).hexdigest()
user = User(
id=uid,
name=name.strip(),
email=email,
password=sha1,
image=
'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1542105917178&di=d1f6b6a11859ff9a2436460ed3c691dd&imgtype=0&src=http%3A%2F%2Fimgsrc.baidu.com%2Fimgad%2Fpic%2Fitem%2Fbba1cd11728b47104c5c00e9c9cec3fdfc0323a0.jpg'
)
yield from user.save()
r = web.Response()
r.set_cookie(COOKIE_NAME,
user2Cookie(user, 86400),
max_age=86400,
httponly=True)
user.password = '******'
r.content_type = 'application/json'
r.body = json.dumps(user, ensure_ascii=False).encode('utf-8')
return r
def api_register_user(*, UserID, Phone, name, Pass):
print(UserID)
if not UserID:
raise APIValueError('身份证号')
if not name:
raise APIValueError('姓名')
if not Pass or not _RE_SHA1.match(Pass):
raise APIValueError('密码')
if not Phone:
raise APIValueError('手机号')
users = yield from User.findAll('Phone=?', [Phone])
if len(users) > 0:
raise APIError('register:failed', 'phone', 'Phone is already in use.')
sha1_Pass = '******' % (Phone, Pass)
user = User(UserID=UserID,
User=name,
Pass=hashlib.sha1(sha1_Pass.encode('utf-8')).hexdigest(),
Phone=Phone)
yield from user.save()
r = web.Response()
r.set_cookie(COOKIE_NAME,
user2cookie(user, 86400),
max_age=86400,
httponly=True)
user.Pass = '******'
r.content_type = 'application/json'
r.body = json.dumps(user, ensure_ascii=True).encode('utf-8')
return r
def api_register(*, name, email, password):
logging.info("enter")
check_string(name=name)
check_email_passwd(email, name)
users = yield from User.findAll('email = ?', [email])
if users:
raise APIValueError("email", "Email is already in used")
uid = next_id()
sha1_passwd = '%s:%s' % (email, password)
user = User(name=name.strip(),
email=email,
password=hashlib.sha1(sha1_passwd.encode('utf-8')).hexdigest(),
image="/static/img/user.png",
admin=0)
yield from user.save()
#make session cooike
r = web.Response()
r.set_cookie(COOKIE_NAME,
user2cookie(user, 86400),
max_age=86400,
httponly=True)
user.password = '******'
r.content_type = "application/json"
r.body = json.dumps(user, ensure_ascii=False).encode("utf-8")
return r
def test(loop):
#创建连接池
yield from orm.create_pool(loop,user='******',password='******',database='awesome')
#创建对象
u=User(name='Test231',email='test123@wxample',passwd='123456',image='about:blank')
#调用保存方法
yield from u.save()
def do_signup(sender, interval):
logger("Entering do_signup (%s)" % (sender))
try:
try:
user = User(phonenumber=sender,interval=int(interval))
except (ValueError, IndexError):
user = User(phonenumber=sender)
user.save()
except:
logger("user already exists! %s" % sender)
#TODO send a message back? fail silently?
#raise Exception, "User '%s' already exists" % sender
raise
return
signup_email = "Thank you for signing up! How to play: we will send you a message listing a definition and a choice of four words. You must choose the correct word corresponding to that definition. Respond with only the number of the word that you believe is correct. Text 'stats' to see how you're doing and 'quit' to leave WordiSMS."
SMS(user.phonenumber, signup_email).send()
logger("Exiting do_signup")
return
def test():
try:
print('program start')
yield from www.orm.create_pool(loop, user='******', password='******', db='chen')
from www.models import User
u = User(name='Test', email='*****@*****.**', passwd='111111', image='about:blank')
yield from u.save()
print('program end')
except BaseException as e:
logging.exception(e)
def test_save():
loop = asyncio.get_event_loop()
loop.run_until_complete(www.orm.create_pool(loop, user='******', password='******', db='awesome'))
u = User(name='Test', email='*****@*****.**', passwd='1234567890', image='about:blank')
loop.run_until_complete(u.save())
loop.stop()
def test(loop):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
database='awesome')
u = User(name='Yao',
email='*****@*****.**',
passwd="sas",
image='about:blank')
yield from u.save()
def testSave():
yield from orm.create_pool(loop,
user='******',
password='******',
db='awesome')
u = User(name='awsome_admin',
email='*****@*****.**',
passwd='1234567890',
image='about:blank',
admin=True)
yield from u.save()
def test():
yield from orm.create_pool(user='******',
password='******',
database='awesome')
u = User(name='Test',
email='*****@*****.**',
passwd='1234567890',
image='about:blank')
yield from u.save()
def save_test(loop):
yield from orm.create_pool(loop=loop,
host='123.206.178.243',
user='******',
password='******',
db='awesome')
u = User(name='sanji',
email='*****@*****.**',
passwd='123123',
image='about:blank')
yield from u.save()
def test(loop):
db_dict = {'user': '******', 'password': '******', 'db': 'awesome'}
yield from orm.create_pool(loop=loop, **db_dict)
# yield from orm.create_pool(user='******', password='******', database='awesome')
u = User(name='Test',
email='*****@*****.**',
passwd='1234567890',
image='about:blank')
yield from u.save()
yield from orm.destory_pool()
def test(loop):
yield from www.orm.create_pool(loop=loop,
host='localhost',
port=3306,
user='******',
password='******',
db='awesome')
u = User(name='test77',
email='*****@*****.**',
passwd='test',
image='about:blank')
yield from u.save()
def test(loop):
yield from www.orm.create_pool(loop=loop,
host='localhost',
port=3306,
user='******',
password='******',
db='awesome')
u = User(name='Test',
email='*****@*****.**',
passwd='1234567890',
image='about:blank')
yield from u.save()
def test():
yield from www.orm.create_pool(loop,
user='******',
password='******',
db='awesome')
u = User(name='admin',
email='*****@*****.**',
passwd='123123',
image='about:blank',
admin=True)
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
database='awesome')
u = User(admin=True,
name='kHRYSTAL',
email='*****@*****.**',
passwd=hashlib.sha1(
('%s:%s' %
(next_id(), 'yyg1990918')).encode('utf-8')).hexdigest(),
image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop,
host='127.0.0.1',
port=3306,
user='******',
password='******',
db='awesome')
user = User(name='Test',
email='*****@*****.**',
passwd='123456',
image='ablout:blank')
print('-------create finish-----------')
user.show()
yield from user.save()
yield from orm.destory_pool()
def test(loop, **kw):
yield from orm.create_pool(loop=loop,
user='******',
password='******',
db='awesome')
u = User(name=kw.get('name'),
email=kw.get('email'),
passwd=kw.get('passwd'),
image=kw.get('image'))
yield from u.save()
yield from orm.destory_pool()
# data=dict(name='gaf', email='*****@*****.**', passwd='1312345', image='about:blank')
# loop=asyncio.get_event_loop()
# loop.run_until_complete(test(loop,**data))
# loop.close()
def api_register_user(*,email,name,passwd):
if not name or not name.strip():
raise APIValueError('email','Invalid email.')
if not passwd:
raise APIValueError('passwd','Invalid password')
users=yield from User.findAll('email=?',[email])
if len(users)>0:
raise APIValueError('register:failed', 'email', 'Email is already in use.')
uid=next_id()
user=User(id=uid,name=name,email=email,passwd=passwd,image='http://www.gravatar.com/avatar/%s?d=mm&s=120',created_at='1532590440.177')
yield from user.save()
r=web.Response()
r.set_cookie(COOKIE_NAME,user,max_age=0,httponly=True)
r.content_type=''
r.body=json.dump(user,ensure_ascii=False).encode('utf-8')
return r
def api_register_user(*, email, name, passwd):
if not name or not name.strip():
raise APIValueError('name')
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
if not passwd or not _RE_SHA1.match(passwd):
raise APIValueError('passwd')
users = yield from User.findAll('email=?', [email])
if len(users) > 0:
raise APIError('register:failed', 'email', 'Email is already in use.')
uid = next_id()
sha1_password = '******' % (uid, passwd)
user = User(id=uid, name=name.strip(), email=email,passwd=hashlib.sha1(sha1_password.encode('utf-8').hexdigest(),
image=''))
yield from user.save()
r = web.Response()
r.set_cookie(COOKIE_NAME,user2cookie(user, 86400), max_age=86400, httponly=True)
user.passwd = '******'
r.content_type = 'application/json'
r.body = json.dumps(user,ensure_ascii=False).enconde('utf-8')
return r
def api_register_user(*, email, name, passwd):
if not name or not name.strip():
raise APIValueError('name')
if not email or not _RE_EMAIL.match(email):
raise APIValueError('email')
if not passwd or not _RE_SHA1.match(passwd):
raise APIValueError('passwd')
users = yield from User.findAll('email=?', [email])
if len(users) > 0:
raise APIError('register:failed', 'email', 'Email is already in use.')
uid = next_id()
shal_passwd = '%s:%s' % (uid, passwd)
user = User(id=uid, name=name.strip(), email=email, passwd=hashlib.sha1(shal_passwd.encode('utf-8')).hexdigest(),
image='http://test.download.cycore.cn/test/5ed5fc74-f110-42df-ade8-c5a2f10d572a.png')
yield from user.save()
# make session cookie:
r = web.Response()
r.set_cookie(COOKIE_NAME, user2cookie(user, 86400), max_age=86400, httponly=True)
user.passwd = '******'
r.content_type = 'application/json'
r.body = json.dumps(user, ensure_ascii=False).encode('utf-8')
return r
def test(loop):
yield from www.orm.create_pool(host="127.0.0.1", port=3306, user="******", password="******", db="awesome", loop=loop)
u = User(name="test3", email="*****@*****.**", passwd="test", image="about:blank")
yield from u.save()
def test(loop):
yield from www.orm.create_pool(loop=loop, host='localhost', port=3306, user='******', password='******', db='awesome')
u = User(name='test85',email='*****@*****.**',passwd='test',image='about:blank')
yield from u.save()
def test(loop, x):
yield from orm.create_pool(user='******', password='', database='awesome', loop=loop)
u = User(name='Test%d' % x, email='*****@*****.**' % x, passwd='123456', image='about:blank')
yield from u.save()
def test(loop):
yield from www.orm.create_pool(loop=loop, user='******', password='******', db='awesome')
u = User(name='test77',email='*****@*****.**',passwd='test',image='about:blank')
yield from u.save()
def test(loop):
yield from www.orm.create_pool(loop=loop, user='******', password='******', db='weibo')
u = User(name='Test1', email='*****@*****.**', passwd='1234567890', image='about:blank')
yield from u.save()
def test(loop):
yield from www.orm.create_pool(loop=loop,user='******',password='******',db='awesome')
u=User(name='test3',email='*****@*****.**',passwd='test',image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop, user='******', password='******', database='awesome')
u=User(admin=True, name='kHRYSTAL', email='*****@*****.**', passwd=hashlib.sha1(('%s:%s' % (next_id(), 'yyg1990918')).encode('utf-8')).hexdigest(), image='about:blank')
yield from u.save()
def test(loop):
yield from orm.create_pool(loop=loop, user='******', password='******', database='awesome')
u=User(name='Yao', email='*****@*****.**', passwd="sas", image='about:blank')
yield from u.save()
