示例#1
0
# coding = utf-8
import unittest

import jsonpath
import requests

from Conf.Oracle import Oracle
from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-goods/cart/list'


class CartList(unittest.TestCase):
    def test_cart_list(self):
        res = requests.get(url, params=None, headers=heads)
        product_sum = jsonpath.jsonpath(res.json(), '$...productId')[0]
        oraDb = Oracle()
        sql = '''Select t.product_id From bas_cust_cart t Where t.con_id =:con_id'''
        con_id = 'e08296fa2ed84476890c8eb7d4d2b78f'
        lists = oraDb.queryBy(sql, {'con_id': con_id})[0][0]
        self.assertEqual(product_sum, lists, msg='数据错误')


if __name__ == '__main__':
    t = CartList()
    t.test_cart_list()
示例#2
0
# coding=utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-goods/product/index/all/list'

# print(url)


# 首页商品列表
class GetList(unittest.TestCase):
    def test_index_list(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        msg2 = jsonpath.jsonpath(res.json(), '$...productId')
        # print(msg2)
        self.assertEqual(msg1, '成功')
        return msg2


#        oraDb = Oracle()
#        sql = """Select t.product_id From pnt_product t, pnt_brand d
# Where t.product_type In ('0','1') And t.pro_status In ('0','4') And  t.shop_type Like '%app%' And t.brand_id = d.id
# Order By d.c_index Desc ,t.display_sequence Desc"""
#        lists = oraDb.queryBy(sql)
#        msg3 = []
示例#3
0
# coding = utf-8
import unittest

import jsonpath
import requests

from Conf.Oracle import Oracle
from MainExecute.readConfig import ReadConfig
from Lib.headers import heads
from MainInterface.index_all_list import GetList

product_id = GetList().test_index_list()[0]
url = ReadConfig().get_http(
    'baseurl') + '/ms-goods/reviews/countproductreview/' + product_id


class CountProductReview(unittest.TestCase):
    def test_count_product_review(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')
        oraDb = Oracle()
        sql = '''Select Count(1) From pnt_product_reviews  t Where t.product_id =: product_id'''
        lists = oraDb.queryBy(sql, {'product_id': 'product_id'})[0][0]
        msg2 = jsonpath.jsonpath(res.json(), '$..count')[0]
        self.assertEqual(msg2, lists)


if __name__ == '__main__':
    t = CountProductReview()
    t.test_count_product_review()
示例#4
0
# coding = urt-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http(
    'baseurl') + '/ms-sys/operation-navigation/operation/list'
print(url)


class GetOperatiponList(unittest.TestCase):
    def test_get_operation_list(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        print(msg1)
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = GetOperatiponList()
    t.test_get_operation_list()
示例#5
0
# coding = utf-8
import json
import time
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from MainInterface.address_isdefault import AddressIsdefault
from MainInterface.confirm_query_quick import ConfirmQuery
from Lib.headers import heads
from MainInterface.index_all_list import GetList

url = ReadConfig().get_http('baseurl') + '/ms-order/order-put/order/put/price'


class PutPrice(unittest.TestCase):
    def test_put_price(self):
        # 获取商品首购价
        firstPrice = ConfirmQuery().test_confirm_query_quick()[0]
        # 获取商品复购价
        rePrice = ConfirmQuery().test_confirm_query_quick()[1]
        # 获取商品价格
        productPrice = ConfirmQuery().test_confirm_query_quick()[2]
        # 获取商品id
        product_id = GetList().test_index_list()[0]
        # 获取地址信息
        memberAddressId = AddressIsdefault().test_address_isdefault()[0]
        # 获取时间戳
        tag = time.time()
示例#6
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http(
    'baseurl') + '/ms-promotion/assist-free/myself/index'


class AssistMyselfList(unittest.TestCase):
    def test_assist_myself_list(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = AssistMyselfList()
    t.test_assist_myself_list()
示例#7
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-order/order/cherk/add'


class OrderCheckAdd(unittest.TestCase):
    def test_order_check_add(self):
        res = requests.get(url, params=None, headers=heads)
        msg = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg, '成功')


if __name__ == '__main__':
    t = OrderCheckAdd()
    t.test_order_check_add()
示例#8
0
# coding = utf-8
import unittest

import jsonpath
import requests

from Conf.Oracle import Oracle
from MainExecute.readConfig import ReadConfig
from Lib.headers import heads
from MainInterface.index_all_list import GetList

url = ReadConfig().get_http('baseurl') + '/ms-goods/product/index/confirm/query/quick'


class ConfirmQuery(unittest.TestCase):
    def test_confirm_query_quick(self):
        product_id = GetList().test_index_list()[0]
        data1 = {"productId": product_id}
        res = requests.post(url, json=data1, headers=heads)
        firstPrice = jsonpath.jsonpath(res.json(), '$...firstPrice')[0]
        rePrice = jsonpath.jsonpath(res.json(), '$...rePrice')[0]
        productPrice = jsonpath.jsonpath(res.json(), '$...productPrice')[0]
        return firstPrice, rePrice, productPrice
        oraDb = Oracle()
        sql = '''Select (1-t.befor_agent/100)*t.buy_price,(1-t.after_agent/100)*t.buy_price From 
        pnt_product  t Where t.product_id =:product_id'''
        lists = oraDb.queryBy(sql, {'product_id': product_id})
        self.assertEqual(firstPrice, lists[0][0])
        self.assertEqual(rePrice, lists[0][1])

示例#9
0
import unittest

import jsonpath
import requests
from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-member/customer/info/get'


class GetInfo(unittest.TestCase):
    def test_get_info(self):
        res = requests.get(url, params=None, headers=heads)
        # print(res.json())
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        # print('我是msg1:'+msg1)
        self.assertEqual(msg1, '成功')
        con_id = jsonpath.jsonpath(res.json(), '$..conId')[0]
        return con_id


if __name__ == '__main__':
    t = GetInfo()
    t.test_get_info()
示例#10
0
# coding = utf-8
import json
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig

url = ReadConfig().get_http('baseurl_admin2') + '/auth/login'


def auth_login():
    data1 = {
        "username": "******",
        "password": "******",
        "channel": "4"
    }
    res = requests.post(url, json=data1)
    # print(res.json())
    token = jsonpath.jsonpath(res.json(), '$..Authorization')[0]
    return token
示例#11
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-promotion/coupon/homepage/list'


class CouponHomepageList(unittest.TestCase):
    def test_coupon_homepage_list(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = CouponHomepageList
    t.test_coupon_homepage_list()
示例#12
0
# coding = utf-8
import unittest

import jsonpath
import requests

from Lib.headers import heads
from MainExecute.readConfig import ReadConfig
from MainInterface.get_info import GetInfo
from MainInterface.index_all_list import GetList
from MainInterface.order_put import OrderPut

orderId = OrderPut().test_order_put()[0]
url = ReadConfig().get_http('baseurl') + '/ms-order/order/info/' + orderId

print(url)


class OrderInfo(unittest.TestCase):
    def test_order_info(self):
        res = requests.get(url, params=None, headers=heads)
        print(res.json())
        orderId_res = jsonpath.jsonpath(res.json(), '$..orderId')[0]
        conId_res = jsonpath.jsonpath(res.json(), '$..conId')[0]
        orderTotal_res = float(
            '%.2f' % (jsonpath.jsonpath(res.json(), '$..orderTotal')[0]))
        productId_res = jsonpath.jsonpath(res.json(), '$...productId')[0]
        # print(productId_res)
        conId = GetInfo().test_get_info()
        # print(conId)
        orderTotal = OrderPut().test_order_put()[2]
示例#13
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http(
    'baseurl') + '/ms-promotion/coupon-detail/active/payed/coupon'


class ActivePayedCoupon(unittest.TestCase):
    def test_active_payed_coupon(self):
        res = requests.post(url, json=None, headers=heads)
        # print(res.json())
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = ActivePayedCoupon()
    t.test_active_payed_coupon()
示例#14
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-promotion/promotion/advertisement/list?adPosition=1'


class AdvertisementList(unittest.TestCase):
    def test_advertisement_list(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = AdvertisementList()
    t.test_advertisement_list()
示例#15
0
# coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads
from MainInterface.index_all_list import GetList

product_id = GetList().test_index_list()[0]
# print(product_id)
url = ReadConfig().get_http(
    'baseurl') + '/ms-goods/product/index/detail/new/' + product_id


class IndexDetailNew(unittest.TestCase):
    def test_index_detail_new(self):
        res = requests.get(url, params=None, headers=heads)
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = IndexDetailNew()
    t.test_index_detail_new()
示例#16
0
#  coding = utf-8
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-promotion/coupon/listbystatus'


class CouponListByStatus(unittest.TestCase):
    def test_coupon_list_by_status(self):
        res = requests.get(url, params=None, headers=heads)

        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]

        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = CouponListByStatus()
    t.test_coupon_list_by_status()
示例#17
0
# coding = utf-8
import unittest

import jsonpath
import requests

from Conf.mySql import Mysql
from MainExecute.readConfig import ReadConfig
from MainInterface.get_info import GetInfo
from Lib.headers import heads

url = ReadConfig().get_http(
    'baseurl') + '/ms-order/member-address/address/isdefault'


class AddressIsdefault(unittest.TestCase):
    def test_address_isdefault(self):
        res = requests.get(url, params=None, headers=heads)
        # print(res.json())
        address_id = int(jsonpath.jsonpath(res.json(), '$..id')[0])
        provinceId = int(jsonpath.jsonpath(res.json(), '$..provinceId')[0])
        # print(provinceId)
        # print(res.json())
        # print(address_id)
        oraDb = Mysql()
        con_id = GetInfo().test_get_info()
        sql = '''select * from member_address t where  is_default = '1'AND t.con_id =(%s)'''
        lists = oraDb.queryBy(sql, con_id)
        # print(lists)
        address_id_mysql = lists[0][0]
        # print(lists)
示例#18
0
# coding = utf-8
import json
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from MainInterface.address_isdefault import AddressIsdefault
from MainInterface.confirm_query_quick import ConfirmQuery
from MainInterface.get_freight import GetFreight
from Lib.headers import heads
from MainInterface.index_all_list import GetList

url = ReadConfig().get_http('baseurl') + '/ms-order/order-put/order/put/freight'


class OrderPutFreight(unittest.TestCase):
    def test_order_put_freight(self):
        # 获取地址信息
        memberAddressId = AddressIsdefault().test_address_isdefault()[0]
        # 获取商品id
        product_id = GetList().test_index_list()[0]
        # 获取商品首购价
        firstPrice = ConfirmQuery().test_confirm_query_quick()[0]
        # 获取商品复购价
        rePrice = ConfirmQuery().test_confirm_query_quick()[1]
        # 获取商品价格
        productPrice = ConfirmQuery().test_confirm_query_quick()[2]
        # 入参格式化
        data = json.dumps({"isUsePoints": "1", "memberAddressId": memberAddressId, "putProductItemsList": [
示例#19
0
import requests
import jsonpath as jsonpath

from MainExecute.readConfig import ReadConfig

from DataSource.readExcel import readExcel

xls_info = readExcel().get_xls('personinfo.xls', 'Sheet1')

openid = xls_info[1][0]
# print(openid)
unionid = xls_info[1][1]
# print(unionid)

url = ReadConfig().get_http('baseurl') + '/ms-auth/auth/app/login/wechat'
# print(url)
data = {"openidApp": openid, "unionid": unionid}
headerP = {"version": "3.2.0", "mobileBrand": "IOS", "anonymousId": "6E7B9681-F967-4728-8303-DA04C16A253B"}
heads = {
    "channel": "5",
    'headerParams': json.dumps(headerP),
    "Authorization": "d2a57dc1d883fd21fb9951699df71cc7"
}


class LoginWechat(unittest.TestCase):

    # @staticmethod
    def test_login_wechat(self):
        res = requests.post(url, json=data, headers=heads)
示例#20
0
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads

url = ReadConfig().get_http('baseurl') + '/ms-sys/api-config-cache/list'

# 协议版本缓存


class ConfigList(unittest.TestCase):
    def test_get_config_list(self):
        res = requests.get(url, params=None, headers=heads)
        # print(res.json())
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        print(msg1)
        self.assertEqual(msg1, '成功')
        # oraDb = Oracle()
        # sql = """select * from   tld_orders  where con_no =: con_no """
        # msg2 = oraDb.queryBy(sql, {'con_no': '260053441'})
        # self.assertEqual(msg1, msg2)


if __name__ == '__main__':
    t = ConfigList()
    t.test_get_config_list()
示例#21
0
# coding = utf-8
import json
import unittest

import jsonpath
import requests

from MainExecute.readConfig import ReadConfig
from Lib.headers import heads
from MainInterface.order_put import OrderPut

url = ReadConfig().get_http('baseurl') + '/ms-order/pay/topay'


class PayToPay(unittest.TestCase):
    def test_pay_to_pay(self):
        orderId = OrderPut().test_order_put()[0]
        data = {"orderId": orderId, "tradeType": "APP"}
        res = requests.post(url, data=json.dumps(data), headers=heads)
        # print(res.json())
        msg1 = jsonpath.jsonpath(res.json(), '$.msg')[0]
        self.assertEqual(msg1, '成功')


if __name__ == '__main__':
    t = PayToPay()
    t.test_pay_to_pay()