python接口自动化case requests+pymysql

源码：

#-*- coding:utf-8 -*-
import pymysql
import requests
import json
import unittest

class case_login(unittest.TestCase):
    def setUp(self):
        pass
    def connectdb(self):
        conn=pymysql.Connect('host','uname','upwd','dbname',charset='utf8')
        cursor=conn.cursor()
        sql='select * from store where id=15;'
        cursor.execute(sql)
        result=cursor.fetchone()
        return  result

    def logininfo(self):
        url='xxxxxxx/clothes/app/login'
        info={"appAccount":"xxx","appPassword":"xxx"}
        response=requests.post(url,data=json.dumps(info))
        return response

    def testLoginCase(self):

        dbs=self.connectdb()
        ids=self.logininfo()
        assert dbs[0]==15



    def tearDown(self):
        pass