def __register__(self):
'''
regist the user.
'''
post_data = self.get_post_data()
form = SumForm(self.request.arguments)
ckname = MUser.get_by_name(post_data['user_name'])
ckemail = MUser.get_by_email(post_data['user_email'])
if ckname is None:
pass
else:
kwd = {
'info': '用户名已存在，请更换用户名。',
'link': '/user/regist',
}
self.set_status(400)
self.render('misc/html/404.html',
cfg=config.CMS_CFG,
kwd=kwd,
userinfo=None)
if ckemail is None:
pass
else:
kwd = {
'info': '邮箱已经存在，请更换邮箱。',
'link': '/user/regist',
}
self.set_status(400)
self.render('misc/html/404.html',
cfg=config.CMS_CFG,
kwd=kwd,
userinfo=None)
if form.validate():
res_dic = MUser.create_user(post_data)
if res_dic['success']:
self.redirect('/user/login')
else:
kwd = {
'info': '注册不成功',
'link': '/user/regist',
}
self.set_status(400)
self.render('misc/html/404.html',
cfg=config.CMS_CFG,
kwd=kwd,
userinfo=None)
else:
kwd = {
'info': '注册不成功',
'link': '/user/regist',
}
self.set_status(400)
self.render('misc/html/404.html',
cfg=config.CMS_CFG,
kwd=kwd,
userinfo=None)
def add_message(self, **kwargs):
post_data = {
'user_name': self.username,
'user_pass': kwargs.get('user_pass', 'g131322'),
'user_email': kwargs.get('user_email', '*****@*****.**'),
}
MUser.create_user(post_data)
aa = MUser.get_by_name(self.username)
self.user_id = aa.uid
p_d = {
'title': kwargs.get('title', 'iiiii'),
'cnt_md': kwargs.get('cnt_md', 'grgr'),
'time_create': kwargs.get('time_create', '1992'),
'time_update': kwargs.get('time_update', '1996070600'),
'user_name': kwargs.get('user_name', 'ngng'),
'view_count': kwargs.get('view_count', 1),
'logo': kwargs.get('logo', 'prprprprpr'),
'memo': kwargs.get('memo', ''),
'order': kwargs.get('order', '1'),
'keywords': kwargs.get('keywords', ''),
'extinfo': kwargs.get('extinfo', {}),
'kind': kwargs.get('kind2', '1'),
'valid': kwargs.get('valid', 1),
}
MPost.create_post(self.post_id, p_d)
post_reply={
'post_id':self.post_id,
'user_name':self.username,
'user_id':self.user_id,
'cnt_reply':'daswrevwefgfgff'
}
self.reply_uid=MReply.create_reply(post_reply)
MReplyid.create_replyid(self.post_id,self.reply_uid)
aa=MReplyid.get_by_rid(self.post_id)
for i in aa:
if i.reply1==self.reply_uid:
self.reply_id_uid=i.reply0
MReply2User.create_reply(self.user_id,self.reply_uid)
def json_register(self):
'''
The first char of 'code' stands for the different field.
'1' for user_name
'2' for user_email
'3' for user_pass
'4' for user_role
The seconde char of 'code' stands for different status.
'1' for invalide
'2' for already exists.
'''
# user_create_status = {'success': False, 'code': '00'}
post_data = self.get_post_data()
user_create_status = self.__check_valid(post_data)
if not user_create_status['success']:
return json.dump(user_create_status, self)
form = SumForm(self.request.arguments)
if form.validate():
user_create_status = MUser.create_user(post_data)
logger.info('user_register_status: {0}'.format(user_create_status))
return json.dump(user_create_status, self)
return json.dump(user_create_status, self)
class TestMReply():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.post = MPost()
self.user = MUser()
self.reply = MReply()
self.post_title = 'ccc'
self.username = '******'
self.uid = tools.get_uu4d()
# def test_insert_post(self):
# # raw_count = self.post.get_counts()
#
# post_data = {
# 'title': self.post_title,
# 'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
# 'user_name': 'Tome',
# 'view_count': 1,
# 'logo': '/static/',
# 'keywords': 'sdf',
#
# }
# self.post.insert_data(self.uid, post_data)
#
#
# tt = self.post.get_by_uid(self.uid)
def test_insert_user(self):
post_data = {
'user_name': self.username,
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.user.create_user(post_data)
print('=' * 20)
print(tt)
assert tt['success'] == True
self.tearDown()
def test_insert_reply(self):
post_data = {
'user_name': self.username,
'user_pass': '******',
'user_email': '*****@*****.**',
}
# tt=self.user.create_user(post_data)
# u_id = self.user.get_by_name(self.username)
#
#
# self.userid = u_id.uid
#
# print("*" * 50)
# print(self.userid)
# print("*" * 50)
# post_data = {
# 'user_name':[self.username],
# 'create_user_id':[self.userid],
# 'timestamp':['2'],
# 'date':['1'],
# 'cnt_md':['###adfafasf/sdf'],
# 'cnt_html':['###adfafasf/sdf'],
# 'vote':0,
# }
self.tearDown()
#
# def test_update_vote(self):
# self.reply.update_vote()
# assert True
#
#
# def test_delete_by_uid(self):
# self.reply.delete_by_uid()
# assert True
#
#
# def test_modify_by_uid(self):
# self.reply.modify_by_uid()
# assert True
#
def test_query_pager(self):
self.reply.query_pager()
assert True
def test_total_number(self):
self.reply.total_number()
assert True
def test_count_of_certain(self):
self.reply.count_of_certain()
assert True
#
# def test_delete(self):
# self.reply.delete()
# assert True
#
# def test_query_all(self):
# self.reply.query_all()
# assert True
#
# def test_get_by_zan(self):
# self.reply.get_by_zan()
# assert True
#
# def test_query_by_post(self):
# self.reply.query_by_post()
# assert True
#
# def test_create_reply(self):
# self.reply.create_reply()
# assert True
#
# def test_get_by_uid(self):
# self.reply.get_by_uid()
# assert True
def tearDown(self):
print("function teardown")
tt = self.post.get_by_uid(self.uid)
if tt:
self.post.delete(tt.uid)
self.user.delete_by_user_name(self.username)
class TestMEntity2User():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.M2U = MEntity2User()
self.username = '******'
self.uu = MUser()
self.user_uid = ''
self.e_uid = 'q112'
self.path = '/static/123123'
self.userip = '10.6.0.177'
self.ee = MEntity()
self.uid = ''
def add_user(self, **kwargs):
name = kwargs.get('user_name', self.username)
post_data = {
'user_name': name,
'user_pass': kwargs.get('user_pass', 'g131322'),
'user_email': kwargs.get('user_email', '{}@kljhqq.com'.format(random.randint(1, 1000000))),
}
self.uu.create_user(post_data)
aa = self.uu.get_by_name(name)
self.user_uid = aa.uid
def add_entity(self):
desc = 'create entity'
self.ee.create_entity(self.e_uid, self.path, desc)
def add_E2U(self):
self.add_user()
self.add_entity()
self.M2U.create_entity2user(self.e_uid, self.user_uid, self.userip)
tt = self.M2U.query_all()
for i in tt:
if i.entity_id == self.e_uid:
self.uid = i.uid
def test_get_by_uid(self):
self.add_E2U()
tt = self.M2U.get_by_uid(self.uid)
assert tt.user_ip == self.userip
assert tt.entity_id == self.e_uid
self.tearDown()
def test_delete_by_uid(self):
self.add_E2U()
tt = self.M2U.get_by_uid(self.uid)
assert tt.user_ip == self.userip
self.M2U.delete_by_uid(self.e_uid)
tt = self.M2U.query_all()
tf = True
for i in tt:
if i.entity_id == self.e_uid:
tf = False
self.tearDown()
assert tf
def test_query_all(self):
tt = self.M2U.query_all()
tf = True
for i in tt:
if i.entity_id == self.e_uid:
tf = False
assert tf
self.add_E2U()
tt = self.M2U.query_all()
tf = True
for i in tt:
if i.entity_id == self.e_uid:
tf = True
self.tearDown()
assert tf
def test_get_all_pager(self):
self.add_E2U()
aa = self.M2U.query_all(limit=200)
a = int(aa.count() / 10) + 2
tf = False
for i in range(a):
tt = self.M2U.get_all_pager(current_page_num=i)
for t in tt:
if t.uid == self.uid:
tf = True
assert t.user_id == self.user_uid
assert t.user_ip == self.userip
self.tearDown()
assert tf
def test_get_all_pager_by_username(self):
self.add_E2U()
tf = False
aa = self.M2U.get_all_pager_by_username(self.user_uid)
for t in aa:
if t.uid == self.uid:
tf = True
assert t.user_ip == self.userip
self.tearDown()
assert tf
def test_create_entity2user(self):
self.add_E2U()
tt = self.M2U.get_by_uid(self.uid)
assert tt.user_ip == self.userip
self.tearDown()
def test_total_number(self):
a = self.M2U.total_number()
self.add_E2U()
b = self.M2U.total_number()
self.tearDown()
assert a + 1 <= b
def test_total_number_by_user(self):
self.add_user()
aa = self.M2U.total_number_by_user(self.user_uid)
self.add_E2U()
bb = self.M2U.total_number_by_user(self.user_uid)
self.tearDown()
assert aa + 1 <= bb
def tearDown(self):
print("function teardown")
self.uu.delete_by_user_name(self.username)
self.ee.delete(self.e_uid)
self.M2U.delete_by_uid(self.e_uid)
class TestUser():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.uu = MUser()
self.username = '******'
def test_insert(self):
post_data = {
'user_name': self.username,
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == True
def test_insert2(self):
post_data = {
'user_name': '',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '天',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '/sdfadf',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
def test_update_info(self):
post_data = {'user_email': '*****@*****.**'}
self.test_insert()
user_info = self.uu.get_by_name(self.username)
tt = self.uu.update_info(user_info.uid, post_data['user_email'])
assert tt['success'] == True
def test_update_pass(self):
post_data = {'user_pass': '******'}
# tt = self.uu.update_pass(self.username, post_data['user_pass'])
# assert tt
def test_update_privilege(self):
post_data = {'role': '1111'}
tt = self.uu.update_role(self.username, post_data['role'])
assert tt == True
def test_upate(self):
assert True
def tearDown(self):
print("function teardown")
self.uu.delete_by_user_name(self.username)
class TestMUser():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.uu = MUser()
self.username = '******'
self.uid = ''
def test_create_user(self):
post_data = {
'user_name': self.username,
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == True
self.tearDown()
def add_mess(self, **kwargs):
name = kwargs.get('user_name', self.username)
post_data = {
'user_name':
name,
'user_pass':
kwargs.get('user_pass', 'g131322'),
'user_email':
kwargs.get('user_email',
'{}@kljhqq.com'.format(random.randint(1, 1000000))),
}
self.uu.create_user(post_data)
aa = self.uu.get_by_name(name)
self.uid = aa.uid
def test_create_user2(self):
post_data = {
'user_name': '',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '天',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '/sdfadf',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
self.tearDown()
def test_update_info(self):
post_data = {'user_email': '*****@*****.**'}
self.add_mess()
user_info = self.uu.get_by_name(self.username)
tt = self.uu.update_info(user_info.uid, post_data['user_email'])
assert tt['success'] == True
self.tearDown()
def test_update_pass(self):
self.add_mess()
post_data = {'user_pass': '******'}
self.uu.update_pass(self.uid, post_data['user_pass'])
tt = self.uu.get_by_uid(self.uid)
assert tt.user_pass == tools.md5(post_data['user_pass'])
self.tearDown()
def test_update_role(self):
self.add_mess()
post_data = {'role': '1111'}
self.uu.update_role(self.username, post_data['role'])
tt = self.uu.get_by_uid(self.uid)
assert tt.role == post_data['role']
self.tearDown()
def test_total_number(self):
a = self.uu.total_number()
self.add_mess()
b = self.uu.total_number()
assert a + 1 <= b
self.tearDown()
def test_query_pager_by_slug(self):
self.add_mess()
a = self.uu.total_number()
x = int(a / 10)
tf = False
for i in range(x + 2):
aa = self.uu.query_pager_by_slug(current_page_num=i)
for y in aa:
if y.uid == self.uid:
tf = True
self.tearDown()
assert tf
def test_count_of_certain(self):
a = self.uu.count_of_certain()
self.add_mess()
b = self.uu.count_of_certain()
assert a + 1 <= b
self.tearDown()
def test_delete(self):
user_info = self.uu.get_by_name(self.username)
self.add_mess()
user_info2 = self.uu.get_by_name(self.username)
aa = self.uu.delete(self.uid)
user_info3 = self.uu.get_by_name(self.username)
assert aa == True
assert user_info == user_info3
assert user_info == None
assert user_info2.uid == self.uid
self.tearDown()
def test_delete_by_user_name(self):
user_info = self.uu.get_by_name(self.username)
self.add_mess()
user_info2 = self.uu.get_by_name(self.username)
aa = self.uu.delete_by_user_name(self.username)
user_info3 = self.uu.get_by_name(self.username)
assert aa == True
assert user_info == user_info3
assert user_info == None
assert user_info2.uid == self.uid
self.tearDown()
def test_get_by_keyword(self):
self.add_mess()
aa = self.uu.get_by_keyword('me')
tf = False
for i in aa:
if i.uid == self.uid:
tf = True
self.tearDown()
assert tf
def test_update_time_login(self):
self.add_mess()
user_info = self.uu.get_by_name(self.username)
time.sleep(2)
self.uu.update_time_login(self.username)
aa = self.uu.get_by_name(self.username)
assert user_info.time_login != aa.time_login
self.tearDown()
def test_update_time_reset_passwd(self):
self.add_mess()
time_r = 11111111
aa = self.uu.update_time_reset_passwd(self.username, time_r)
assert aa == True
aa = self.uu.get_by_name(self.username)
assert aa.time_reset_passwd == time_r
self.tearDown()
def test_query_nologin(self):
aa = self.uu.query_nologin()
self.add_mess()
bb = self.uu.query_nologin()
assert aa.count() == bb.count()
self.tearDown()
def test_check_user_by_email(self):
post_data = {'user_email': '*****@*****.**', 'user_pass': '******'}
self.add_mess(**post_data)
aa = self.uu.check_user_by_email(post_data['user_email'],
post_data['user_pass'])
assert aa == 1
self.tearDown()
def test_check_user_by_name(self):
post_data = {'user_pass': '******'}
self.add_mess(**post_data)
aa = self.uu.check_user_by_name(self.username, post_data['user_pass'])
assert aa == 1
self.tearDown()
def test_check_user(self):
post_data = {'user_pass': '******'}
self.add_mess(**post_data)
aa = self.uu.check_user(self.uid, post_data['user_pass'])
assert aa == 1
self.tearDown()
def test_get_by_email(self):
post_data = {'user_email': '*****@*****.**'}
self.add_mess(**post_data)
aa = self.uu.get_by_email(post_data['user_email'])
assert aa.uid == self.uid
self.tearDown()
def test_set_sendemail_time(self):
self.add_mess()
bb = self.uu.get_by_uid(self.uid)
time.sleep(2)
self.uu.set_sendemail_time(self.uid)
aa = self.uu.get_by_uid(self.uid)
assert bb.time_email <= aa.time_email
self.tearDown()
def test_get_by_name(self):
self.add_mess()
aa = self.uu.get_by_name(self.username)
assert aa.uid == self.uid
self.tearDown()
def test_get_by_uid(self):
self.add_mess()
aa = self.uu.get_by_uid(self.uid)
assert aa.user_name == self.username
self.tearDown()
def test_query_all(self):
aa = self.uu.query_all()
tf = True
for i in aa:
if i.user_name == self.username:
tf = False
assert tf
self.add_mess()
aa = self.uu.query_all()
tf = False
for i in aa:
if i.user_name == self.username:
tf = True
assert tf
self.tearDown()
def test_db_email(self):
self.tearDown()
pdata = {
'user_name': 'asdfdsf',
'user_pass': '******',
'user_email': '*****@*****.**',
}
MUser.create_user(pdata)
bb = MUser.create_user(pdata)
assert bb == {'code': '31', 'success': False}
self.uu.delete_by_user_name(pdata['user_name'])
def tearDown(self):
print("function teardown")
tt = self.uu.get_by_uid(self.uid)
if tt:
self.uu.delete(tt.uid)
self.uu.delete_by_user_name(self.username)
class TestMUser():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.uu = MUser()
self.username = '******'
self.uid = ''
def test_create_user(self):
post_data = {
'user_name': self.username,
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == True
self.tearDown()
def add_mess(self, **kwargs):
name = kwargs.get('user_name', self.username)
post_data = {
'user_name': name,
'user_pass': kwargs.get('user_pass', 'g131322'),
'user_email': kwargs.get('user_email', '*****@*****.**'),
}
self.uu.create_user(post_data)
aa = self.uu.get_by_name(name)
self.uid = aa.uid
def test_create_user2(self):
post_data = {
'user_name': '',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '天',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
post_data = {
'user_name': '/sdfadf',
'user_pass': '******',
'user_email': '*****@*****.**',
}
tt = self.uu.create_user(post_data)
assert tt['success'] == False
self.tearDown()
def test_update_info(self):
post_data = {'user_email': '*****@*****.**'}
self.add_mess()
user_info = self.uu.get_by_name(self.username)
tt = self.uu.update_info(user_info.uid, post_data['user_email'])
assert tt['success'] == True
self.tearDown()
def test_update_pass(self):
self.add_mess()
post_data = {'user_pass': '******'}
self.uu.update_pass(self.uid, post_data['user_pass'])
tt = self.uu.get_by_uid(self.uid)
assert tt.user_pass == tools.md5(post_data['user_pass'])
self.tearDown()
def test_update_role(self):
post_data = {'role': '1111'}
tt = self.uu.update_role(self.username, post_data['role'])
assert tt == True
self.tearDown()
# def test_total_number(self):
# self.uu.total_number()
#
#
# def test_query_pager_by_slug(self):
# self.uu.query_pager_by_slug()
#
# def test_count_of_certain(self):
# self.uu.count_of_certain()
#
# def test_delete(self):
# self.uu.delete()
#
# def test_delete_by_user_name(self):
# self.uu.delete_by_user_name()
#
# def test_get_by_keyword(self):
# self.uu.get_by_keyword()
#
# def test_update_time_login(self):
# self.uu.update_time_login()
#
# def test_update_time_reset_passwd(self):
# self.uu.update_time_reset_passwd()
#
# def test_query_nologin(self):
# self.uu.query_nologin()
#
# def test_check_user_by_email(self):
# self.uu.check_user_by_email()
#
# def test_check_user_by_name(self):
# self.uu.check_user_by_name()
#
# def test_check_user(self):
# self.uu.check_user()
#
# def test_get_by_email(self):
# self.uu.get_by_email()
def test_set_sendemail_time(self):
self.add_mess()
bb = self.uu.get_by_uid(self.uid)
time.sleep(2)
aa = self.uu.set_sendemail_time(self.uid)
aa = self.uu.get_by_uid(self.uid)
assert bb.time_email <= aa.time_email
self.tearDown()
def test_get_by_name(self):
self.add_mess()
aa = self.uu.get_by_name(self.username)
assert aa.uid == self.uid
self.tearDown()
def test_get_by_uid(self):
self.add_mess()
aa = self.uu.get_by_uid(self.uid)
assert aa.user_name == self.username
self.tearDown()
def test_query_all(self):
aa = self.uu.query_all()
tf = True
for i in aa:
if i.user_name == self.username:
tf = False
assert tf
self.add_mess()
aa = self.uu.query_all()
tf = False
for i in aa:
if i.user_name == self.username:
tf = True
assert tf
self.tearDown()
def tearDown(self):
print("function teardown")
tt = self.uu.get_by_uid(self.uid)
if tt:
self.uu.delete(tt.uid)
self.uu.delete_by_user_name(self.username)
class TestMReply():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.post = MPost()
self.user = MUser()
self.reply = MReply()
self.r2u = MReply2User()
self.post_title = 'fwwgccc'
self.username = '******'
self.user_uid = ''
self.reply_uid = ''
self.post_uid = '998h'
self.password = '******'
def add_user(self, **kwargs):
name = kwargs.get('user_name', self.username)
post_data = {
'user_name': name,
'user_pass': kwargs.get('user_pass', self.password),
'user_email': kwargs.get('user_email', '*****@*****.**'),
}
self.user.create_user(post_data)
aa = self.user.get_by_name(name)
self.user_uid = aa.uid
def add_post(self, **kwargs):
p_d = {
'title': kwargs.get('title', self.post_title),
'cnt_md': kwargs.get('cnt_md', 'grgr'),
'time_create': kwargs.get('time_create', '1992'),
'time_update': kwargs.get('time_update', '1996070600'),
'user_name': self.username,
'view_count': kwargs.get('view_count', 1),
'logo': kwargs.get('logo', 'prprprprpr'),
'memo': kwargs.get('memo', ''),
'order': kwargs.get('order', '1'),
'keywords': kwargs.get('keywords', 'sd,as'),
'extinfo': kwargs.get('extinfo', {}),
'kind': kwargs.get('kind', '1'),
'valid': kwargs.get('valid', 1),
}
MPost.create_post(self.post_uid, p_d)
def test_insert_post(self):
# raw_count = self.post.get_counts()
self.add_post()
tt = self.post.get_by_uid(self.post_uid)
assert tt.title == self.post_title
self.tearDown()
def test_insert_user(self):
self.add_user()
tt = self.user.get_by_uid(self.user_uid)
assert tt.user_name == self.username
self.tearDown()
def add_reply(self, **kwargs):
p_d = {
'post_id': self.post_uid,
'user_name': self.username,
'user_id': self.user_uid,
'category': '0',
'cnt_reply': kwargs.get('cnt_reply', 'f4klkj进口国海关好姐姐4'),
}
uid = self.reply.create_reply(p_d)
self.reply_uid = uid
self.r2u.create_reply(self.user_uid, uid)
def test_insert_reply(self):
self.add_user()
self.add_post()
self.add_reply()
aa = self.reply.get_by_uid(self.reply_uid)
assert aa.user_name == self.username
assert aa.post_id == self.post_uid
assert aa.user_id == self.user_uid
self.tearDown()
def test_update_vote(self):
self.add_user()
self.add_post()
self.add_reply()
before = self.reply.get_by_uid(self.reply_uid)
self.reply.update_vote(self.reply_uid, 10)
after = self.reply.get_by_uid(self.reply_uid)
assert after.vote == 10
assert before.vote < after.vote
self.tearDown()
def test_delete_by_uid(self):
self.add_user()
self.add_post()
self.add_reply()
yesrep = self.reply.get_by_uid(self.reply_uid)
assert yesrep.post_id == self.post_uid
aa = self.reply.delete_by_uid(self.reply_uid)
assert aa
nosrep = self.reply.get_by_uid(self.reply_uid)
assert nosrep == None
self.tearDown()
def test_modify_by_uid(self):
self.add_user()
self.add_post()
self.add_reply()
p_d = {
'user_name': self.username,
'user_id': self.user_uid,
'category': '1',
'cnt_reply': '一二三四',
}
aa = self.reply.modify_by_uid(self.reply_uid, p_d)
assert aa == self.reply_uid
tt = self.reply.get_by_uid(self.reply_uid)
assert tt.category == p_d['category']
assert tt.cnt_md == p_d['cnt_reply']
self.tearDown()
def test_query_pager(self):
self.add_user()
self.add_post()
self.add_reply()
aa = self.reply.total_number()
a = int(aa / 10)
tf = False
for i in range(a + 3):
list = self.reply.query_pager(current_page_num=i)
for x in list:
if x.uid == self.reply_uid:
tf = True
break
self.tearDown()
assert tf
def test_total_number(self):
aa = self.reply.total_number()
self.add_user()
self.add_post()
self.add_reply()
bb = self.reply.total_number()
assert aa + 1 <= bb
self.tearDown()
def test_count_of_certain(self):
aa = self.reply.count_of_certain()
self.add_user()
self.add_post()
self.add_reply()
bb = self.reply.count_of_certain()
assert aa + 1 <= bb
self.tearDown()
# def test_delete(self):
# self.tearDown()
# bb = self.reply.count_of_certain()
# print(bb)
# self.add_user()
# self.add_post()
# self.add_reply()
# bb = self.reply.count_of_certain()
# print(bb)
# aa=self.reply.get_by_uid(self.reply_uid)
# assert aa.post_id==self.post_uid
# aa = self.reply.query_by_post(self.post_uid)
# tf = False
# for i in aa:
# if i.uid == self.reply_uid:
# tf = True
# break
# assert tf
# vv=self.reply.delete(self.post_uid)
# print('LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLl')
# print(vv)
# s = self.reply.count_of_certain()
# print(s)
# # assert vv
# aa = self.reply.get_by_uid(self.reply_uid)
# self.tearDown()
# assert aa==None
def test_query_all(self):
self.tearDown()
aa = self.reply.query_all()
tf = True
for i in aa:
if i.uid == self.reply_uid:
tf = False
break
assert tf
self.add_user()
self.add_post()
self.add_reply()
bb = self.reply.query_all()
tf = False
for i in bb:
if i.uid == self.reply_uid:
tf = True
assert i.post_id == self.post_uid
break
assert tf
self.tearDown()
def test_get_by_zan(self):
self.add_user()
self.add_post()
self.add_reply()
aa = self.reply.get_by_zan(self.reply_uid)
assert aa >= 1
self.tearDown()
def test_query_by_post(self):
self.add_user()
self.add_post()
self.add_reply()
aa = self.reply.query_by_post(self.post_uid)
tf = False
for i in aa:
if i.uid == self.reply_uid:
tf = True
break
assert tf
self.tearDown()
def test_get_by_uid(self):
self.add_user()
self.add_post()
self.add_reply()
aa = self.reply.get_by_uid(self.reply_uid)
assert aa.user_id == self.user_uid
self.tearDown()
def tearDown(self):
print("function teardown")
tt = self.post.get_by_uid(self.post_uid)
if tt:
self.post.delete(tt.uid)
self.user.delete_by_user_name(self.username)
tt = self.user.get_by_uid(self.user_uid)
if tt:
self.user.delete(tt.uid)
tt = self.reply.get_by_uid(self.reply_uid)
if tt:
self.reply.delete_by_uid(tt.uid)
self.r2u.delete(self.reply_uid)
class TestMReply2User():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.user = MUser()
self.reply = MReply()
self.r2u = MReply2User()
self.username = '******'
self.password = '******'
self.user_uid = '12345'
self.reply_uid = '65412'
def add_user(self, **kwargs):
name = kwargs.get('user_name', self.username)
post_data = {
'user_name': name,
'user_pass': kwargs.get('user_pass', self.password),
'user_email': kwargs.get('user_email', '*****@*****.**'),
}
self.user.create_user(post_data)
aa = self.user.get_by_name(name)
self.user_uid = aa.uid
def add_reply(self, **kwargs):
p_d = {
'post_id': 'gtyu',
'user_name': self.username,
'user_id': self.user_uid,
'category': '0',
'cnt_reply': kwargs.get('cnt_reply', 'kfjd速度很快很低'),
}
uid = self.reply.create_reply(p_d)
self.reply_uid = uid
self.r2u.create_reply(self.user_uid, uid)
def test_create_reply(self):
self.add_user()
self.add_reply()
self.r2u.create_reply(self.user_uid, self.reply_uid)
aa = self.r2u.get_voter_count(self.reply_uid)
assert aa >= 1
self.tearDown()
#
# def test_update(self):
# self.r2u.update()
def test_delete(self):
self.add_user()
self.add_reply()
self.r2u.create_reply(self.user_uid, self.reply_uid)
aa = self.r2u.get_voter_count(self.reply_uid)
assert aa >= 1
self.r2u.delete(self.reply_uid)
aa = self.r2u.get_voter_count(self.reply_uid)
assert aa == 0
self.tearDown()
def test_get_voter_count(self):
self.add_user()
self.add_reply()
self.r2u.create_reply(self.user_uid, self.reply_uid)
aa = self.r2u.get_voter_count(self.reply_uid)
assert aa >= 1
self.tearDown()
def tearDown(self):
print("function teardown")
tt = self.user.get_by_uid(self.user_uid)
if tt:
self.user.delete(tt.uid)
tt = self.reply.get_by_uid(self.reply_uid)
if tt:
self.reply.delete_by_uid(tt.uid)
self.r2u.delete(self.reply_uid)
