def test_themedetail_success(self): '''所有参数都传''' db = MyDB().getCon() cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "select * from mipot_theme where deleted!='1'" data_count = cursor.execute(sql) print data_count if data_count > 0: cursor.scroll(0) rows = cursor.fetchone() print rows id = rows['id'] print id self.url_path=self.url_path + str(id) params = '' r = self.bujiami('GET', self.url_path, params ) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('success', js['message']) else: print "不存在话题"
def test_review_pa(self): '''只传必填参数都传,发表作品评论或回复评论''' token = Login().login() # 引用登录 # token = 'YTk2OGZjODJkYTNhMzA1ZGNjODhiMzJjMDhkOGQwMzI=' # 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_comment" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows showId = rows['recipe_show_id'] print showId params = 'content=test&showId=' + str(showId) r = self.myhttp( 'POST', self.url_path, params, # {'showId': 695, 'content': '好'}, token) print r js = json.loads(r) print js 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_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_recipeCommentdelpost_br(self): '''所有参数都传,删除别人的评论,删除失败''' token = Login().login() # 引用登录 # 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_recipe_comment A,mipot_recipe B where A.userid !='1081' and B.state='2200' and A.recipeId=B.id" data_count = cursor.execute(sql) print data_count if data_count > 0: cursor.scroll(0) rows = cursor.fetchone() print rows ypcommentid = rows['id'] print ypcommentid params = 'commentId=' + str(ypcommentid) r = self.myhttp('POST', self.url_path, params, # {'commentId': ypcommentid}, token ) print r js = json.loads(r) self.assertEqual(js['state'], -1) self.assertIn('删除失败 : 您没有权限删除此评论', js['message']) else: print '删除失败 : 该评论已经被删除'
def test_checknew_renew(self): '''release_code传入最新的版本代码时,未有新版本''' # 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_app_release where state='2200' and platform='1' ORDER BY id DESC " data_count = cursor.execute(sql) print data_count rows = cursor.fetchone() print rows release_code = rows['release_code'] print release_code params= 'release_code='+ str(release_code) print params r = self.myhttp('GET', self.url_path, params, ) print r js = json.loads(r) if data_count > 1: self.assertEqual(js['state'], -4) self.assertIn('未有新版本', js['message']) else: self.assertEqual(js['state'],1) self.assertIn('新版本获取成功', js['message'])
def test_topicdpost_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_topic where user_id!='1081' and is_deleted ='0'" data_count = cursor.execute(sql) print data_count cursor.scroll(0) rows = cursor.fetchone() print rows id = rows['id'] print id # params = 'type=15030&content=其他&topicId=' + str(id) r = self.topicpost('POST', self.url_path, { 'type': 15030, 'content': u'其他', 'topicId': id }, token) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('举报成功', js['message'])
def test_reciperesumepoint_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 B.* from mipot_recipe A,mipot_recipe_step B where A.id = B.recipeId \ and A.state='2200' and B.resumeIndex is NOT NULL" data_count = cursor.execute(sql) print data_count rows = cursor.fetchone() print rows recipeId = rows['recipeId'] resumeIndex = rows['resumeIndex'] print recipeId params = 'recipeid=' + str(recipeId) + '&stepIndex=' + str(resumeIndex) r = self.myhttp('GET', self.url_path, params # {'recipeid':recipeId, 'stepIndex':resumeIndex}, ) print r js = json.loads(r) if data_count > 0: self.assertEqual(js['state'], 1) self.assertIn('获取步骤信息成功', js['message']) else: print "不存在断点食谱"
def test_topicthemelist_success(self): '''所有参数都传''' db = MyDB().getCon() cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "select * from mipot_theme where deleted!='1'" data_count = cursor.execute(sql) print data_count if data_count > 0: cursor.scroll(0) rows = cursor.fetchone() print rows themeid = rows['id'] params = 'pageno=1&perpage=20&themeid='+str(95) # params = 'pageno=1&perpage=10&themeid=175' print params r = self.myhttp('GET', self.url_path, params ) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取话题相关主题列表成功', js['message']) print "话题下的主题数量:"+str(len(js['result'])) print "话题参与人数:" + str(js['result'][0]["themes"][0]["participants"]) for i in range(len(js['result'])): print js['result'][i]['content'] else: print "不存在话题"
def test_articletopadv_zxsuccess(self): '''6202自选banner''' db = MyDB().getCon() # db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接 cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "SELECT * FROM mipot_article WHERE type = '6202'and state='2200'" data_count = cursor.execute(sql) print data_count rows = cursor.fetchall() print rows for row in rows: print row params = 'type=6202' r = self.myhttp('GET', self.url_path, params # {'type': '6202'} ) print r js = json.loads(r) if data_count > 0: self.assertEqual(js['state'], 1) self.assertIn('banner数据获取成功', js['message']) print row['title'] print js['result'][0]['title'] # print js['result'][1]['title'] else: self.assertEqual(js['state'], 0) self.assertIn('头部banner没有数据', js['message'])
def test_test_showcommentdelpost_ysc(self): '''删除已删除的评论,提示已删除''' token = Login().login() # 引用登录 # 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_comment where user_id!='1053'" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows commentId = rows['id'] showId = rows['recipe_show_id'] print showId params = 'showId=' + str(showId) + '&commentId=' + str(commentId) r = self.myhttp( 'POST', self.url_path, params, # {'showId': showId, 'commentId': commentId}, token) print r js = json.loads(r) self.assertEqual(js['state'], -1) self.assertIn('删除失败', js['message']) else: print "不存在评论"
def test_stepinfoget_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 A.* from mipot_recipe A,mipot_recipe_step B where A.id = B.recipeId \ and A.state='2200' and B.resumeIndex is NOT NULL" data_count = cursor.execute(sql) print data_count cursor.scroll(0) rows = cursor.fetchone() print rows recipeid = rows['id'] print recipeid if data_count>0: params = 'recipeid='+str(recipeid) r = self.myhttp('GET', self.url_path, params, # {'recipeid': recipeid} ) print r print '返回结果:'+ r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取食谱步骤成功',js['message']) else: print '不存在食谱'
def test_collectdeviceget_plose(self): '''pageNo未传''' 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_device_useinfo where userId='54644930'" data_count = cursor.execute(sql) print data_count rows = cursor.fetchone() print rows deviceId = rows['deviceId'] print deviceId params = 'deviceId=' + str(deviceId) r = self.myhttp( 'GET', self.url_path, params, # { 'deviceId':deviceId}, token) print r if data_count > 0: js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取菜谱列表成功', js['message']) else: print "不存在收藏食谱"
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_topiccommentdeletes_htys(self): '''话题已经被发布者删除,用户1053''' token = Login().login() # 引用登录 # db = MySQLdb.connect("192.168.1.64", "root", "123456", "new_independent_api") # 打开数据库连接 db = MyDB().getCon() cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "SELECT B.* from mipot_topic A,mipot_topic_comment B \ where A.id=B.topic_id and A.is_deleted =1 and B.user_id='1081' and B.is_deleted != 1" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows commentId = rows['id'] print commentId params = 'commentId=' + str(commentId) 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_literecipeget_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 B.deviceId from mipot_device B ,mipot_device_model_recipe A where \ A.devicemodelid=B.deviceModelId and B.deviceModelId = '1'" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows deviceid = rows['deviceId'] params = 'deviceid=' + str(deviceid) r = self.myhttp( 'GET', self.url_path, params, ) 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_topicthemelist_btsuccess(self): '''只传必填参数''' db = MyDB().getCon() cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "select * from mipot_theme where deleted!='1'" data_count = cursor.execute(sql) print data_count if data_count > 0: cursor.scroll(0) rows = cursor.fetchone() print rows themeid = rows['id'] params = 'themeid=' + str(themeid) print params r = self.myhttp('GET', self.url_path, params) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取话题相关主题列表成功', js['message']) print len(js['result']) for i in range(len(js['result'])): print js['result'][i]['content'] else: print "不存在话题"
def test_praise_weiz(self): '''未赞时,操作类型为:cancelPraise,还没有赞过''' token = Login().login() # 引用登录 # 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_topic where id not in (select mipot_topic.id from mipot_topic,mipot_topic_praise \ where mipot_topic.id=mipot_topic_praise.topic_id and \ mipot_topic.is_deleted='0' and mipot_topic_praise.user_id='1081') and \ is_deleted='0'" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows topicId = rows['id'] print topicId params = 'praise=cancelPraise&topicId=' + str(topicId) 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_v3addpost_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_recipe A where A.state='2200'" data_count = cursor.execute(sql) print data_count rows = cursor.fetchone() print rows recipeId = rows['id'] print recipeId params = 'recipeId=' + str(recipeId) r = self.myhttp('POST', self.url_path, params, # {'recipeId': recipeId},#1957 token ) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn( '收藏成功',js['message'])
def test_showinformationget_ypbr(self): ''' 存在评论记录,发布者查看详情,查看到评论列表''' token = Login().login() # 引用登录 # 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 where praise_count =0 and \ user_id='1081' and id in (select recipe_show_id from mipot_recipe_show_comment)" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows showId = rows['id'] print showId params = 'showId=' + str(showId) r = self.myhttp('GET', self.url_path, params, # {'showId': showId}, token ) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取成功', js['message']) self.assertEqual(False, js['result'][0]['praised']) self.assertEqual(0, js['result'][0]['showing']['praiseCount']) self.assertIsNot(0, js['result'][0]['commentSize']) else: print "不存在对应作品记录"
def test_unreg_success(self): '''解绑饭煲(主动解除分享给别人的设备)''' token = Login().login() # 引用登录 # 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_useinfo where userId != '54644930'" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows deviceId = rows['deviceId'] toUserId = rows['userId'] print deviceId print toUserId params = 'deviceId=' + str(deviceId) + '&toUserId=' + str(toUserId) r = self.myhttp( 'POST', self.url_path, params, # {'deviceId':deviceId,'toUserId':toUserId}, token) print r js = json.loads(r) print js self.assertEqual(js['state'], 1) self.assertIn('操作成功', js['message']) else: print "不存在分享设备"
def test_showinformationget_tokenno(self): '''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 where id in (select recipe_show_id from mipot_recipe_show_praise)" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows showId = rows['id'] praisecount = rows['praise_count'] print showId print praisecount params = 'showId=' + str(showId) r = self.myhttp('GET', self.url_path, params, # {'showId': showId}, ) print r js = json.loads(r) self.assertEqual(js['state'], 1) self.assertIn('获取成功', js['message']) self.assertEqual(False, js['result'][0]['praised']) self.assertEqual(praisecount, js['result'][0]['showing']['praiseCount']) else: print "不存在对应作品记录"
def test_topicdpost_br(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_topic where user_id!='1081'and is_deleted ='0'" data_count = cursor.execute(sql) print data_count cursor.scroll(0) rows = cursor.fetchone() print rows id = rows['id'] print id params = 'topicId=' + str(id) r = self.myhttp('POST', self.url_path, params, token ) print r js = json.loads(r) self.assertEqual(js['state'], -1) self.assertIn('删除话题失败',js['message'])
def test_cpraise_nozan(self): '''未点赞过的作品进行点赞''' token = Login().login() # 引用登录 # 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 where id not in(select A.id from mipot_recipe_show A,mipot_recipe_show_praise B \ where a.id =b.recipe_show_id and b.user_id='1081')" data_count = cursor.execute(sql) print data_count if data_count > 0: rows = cursor.fetchone() print rows showId = rows['id'] print showId params = 'showId=' + str(showId) r = self.myhttp('GET', 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_btsuccess(self): '''只传必填字段,评论成功''' token = Login().login() # 引用登录 # 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'] print topicId params = 'content=test&topicId=' + str(topicId) r = self.myhttp( 'POST', self.url_path, params, # {'topicId': topicId, 'content': 'test'}, token) print r js = json.loads(r) print js self.assertEqual(js['state'], 1) self.assertIn('发表成功', js['message']) else: print "请先发表话题"
def test_themedetail_noncerror(self): '''nonce不正确''' db = MyDB().getCon() cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor) sql = "select * from mipot_theme" data_count = cursor.execute(sql) print data_count cursor.scroll(0) rows = cursor.fetchone() print rows id = rows['id'] print id params = {'': ''} r = self.noncerror('GET', self.url_path + str(id), params) print r
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)
def test_showdetail_success(self): '''所有参数都传''' 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: cursor.scroll(0) rows = cursor.fetchone() print rows id = rows['id'] print id self.url_path = self.url_path + str(id) params = '' r = self.nosign('GET', self.url_path, params ) print r