class ServiceInterfaceCaseTest(unittest.TestCase):
def setUp(self):
folderpath = "C:\Users\gepeng\workspace\ZTEST\Case\demo"
self.config = CaseFolderParser(folderpath)
def test_execute(self):
inPut = self.config.getInPut()
expect = self.config.getExpect()
print expect
d = JSONDecoder()
data = d.decode(inPut.get("parameters"))
if inPut.get("method") == "POST":
r = requests.post(inPut.get("url"), data)
else:
r = requests.get(inPut.get("url"), parameters=data)
response = d.decode(str(r.text))
expectResponse = d.decode(expect.get("response"))
print expect.get("sql")
expectSql = d.decode(expect.get("sql"))
print expectSql
expectSqlQuery = expectSql.get("query")
expectSqlResult = tuple(expectSql.get("result").encode(encoding="UTF-8", errors="strict").split(","))
conn = MySQLdb.connect(host="172.18.33.37", user="******", passwd="123456", db="meshare", port=3306)
cur = conn.cursor()
cur.execute(expectSqlQuery)
result = cur.fetchone()
self.assertTupleEqual(result, expectSqlResult)
self.assertDictContainsSubset(expectResponse, response)
def tearDown(self):
pass
def setUp(self):
folderpath = "C:\Users\gepeng\workspace\ZTEST\Case\demo"
self.config = CaseFolderParser(folderpath)
