def test_showall_btsuccess(self):
'''必填字段传入正确，获取成功'''
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "SELECT * from mipot_recipe_show"
data_count = cursor.execute(sql)
print data_count
if data_count > 0:
rows = cursor.fetchone()
print rows
recipeId = rows['recipe_id']
params = 'curPage=1&recipeId=' + str(recipeId)
r = self.myhttp(
'GET',
self.url_path,
params,
# {'recipeId': recipeId, 'curPage': '1'},
)
print r
js = json.loads(r)
self.assertEqual(js['state'], 1)
self.assertIn('获取成功', js['message'])
else:
print "未找到作品"
def test_cookscriptget_sysuccess(self):
'''所有参数都传'''
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "SELECT recipe_cooktemplet_id,dmg_id FROM mipot_recipe_cook_templet_script " \
"WHERE recipe_cooktemplet_id IN (SELECT id FROM mipot_recipe_cook_templet WHERE state = 2200) "
data_count = cursor.execute(sql)
print data_count
rows = cursor.fetchone()
print rows
templetid = rows['recipe_cooktemplet_id']
dmgid = rows['dmg_id']
# params={'templetid':templetid,'deviceid':dmgid}
params = 'templetid=' + str(10) + '&deviceid=' + str(45423531)
print params
r = self.myhttp(
'GET',
self.url_path,
params,
)
print r
js = json.loads(r)
self.assertEqual(js['state'], 1)
self.assertIn("get recipecooktempletscript success", js['message'])
def test_readpost_success(self):
'''所有参数都传，阅读成功'''
token = Login().login() # 引用登录
print token
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "select * from mipot_message where username='******'"
data_count = cursor.execute(sql)
print data_count
cursor.scroll(0)
rows = cursor.fetchone()
print rows
mid = rows['id']
print mid
if data_count > 0:
params = 'mid='+str(mid)
r = self.myhttp('POST',
self.url_path,
params,
token
)
print r
js = json.loads(r)
self.assertEqual(js['state'], 1)
self.assertIn( '操作成功',js['message'])
else:
print "不存在消息"
def test_topiccomment_success(self):
'''所有字段都传，评论成功'''
token = Login().login() # 引用登录
# token = 'ZTI0NTgwNmY0YTljZTcyOTc5ZWFiYTdjYzRkYTNkNGE='
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "SELECT A.* from mipot_topic_comment A,mipot_topic B where A.is_deleted != 1 and B.is_deleted !=1 and A.topic_id =B.id"
data_count = cursor.execute(sql)
print data_count
if data_count > 0:
rows = cursor.fetchone()
print rows
topicId = rows['topic_id']
parentId = rows['id']
print topicId
print parentId
params = 'content=test&topicId=' + str(
topicId) + '&parentId=' + str(parentId)
print params
r = self.myhttp('POST', self.url_path, params, token)
print r
js = json.loads(r)
print js
self.assertEqual(js['state'], 1)
self.assertIn('发表成功', js['message'])
else:
print "请先发表话题"
def test_showreport_btsuccess(self):
''' 类型不为其他，只传必填参数举报成功'''
token = Login().login() # 引用登录
print token
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "SELECT * from mipot_recipe_show"
data_count = cursor.execute(sql)
print data_count
cursor.scroll(0)
rows = cursor.fetchone()
print rows
showId = rows['id']
print showId
params = 'type=15000&showId=' + str(showId)
r = self.myhttp(
'POST',
self.url_path,
params,
# {'type': 15000, 'showId': showId},
token)
print r
js = json.loads(r)
self.assertEqual(js['state'], 1)
self.assertIn('举报作品成功', js['message'])
def test_recipehintget_success(self):
'''所有参数都传'''
# db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接
db = MyDB().getCon()
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = "select * from mipot_device where deviceModelId='1'"
data_count = cursor.execute(sql)
print data_count
cursor.scroll(0)
rows = cursor.fetchone()
print rows
deviceid = rows['deviceId']
print deviceid
params = 'content=饭&deviceid=' + str(deviceid)
r = self.myhttp('GET', self.url_path, params)
print r
js = json.loads(r)
self.assertEqual(js['state'], 1)