yamlapi

Size: px

Start display at page:

Download "yamlapi"

仁轴郭
1 years ago
Views:

1 yamlapi yangjianliang

3 Contents 1 yamlapi 1 2 QQ yaml json 11 7 demo 15 8 Apollo demo i

4 ii

5 CHAPTER 1 yamlapi yamlapi 1

6 2 Chapter 1. yamlapi

7 CHAPTER 2 QQ

8 4 Chapter 2. QQ

9 CHAPTER 3 readthedocs yamlapi yaml +api unittest pytest MySQL PgSQL MongoDB Redis Jenkins GitLab Runner CI/CD yaml json pip install yamlapi yamlapi h yamlapi help yamlapi v yamlapi version pip install U yamlapi yamlapi create p= yamlapi create p=demo_project yamlapi run c= yamlapi run c=test yamlapi clean mvn clean pip uninstall yamlapi 5

10 6 Chapter 3.

11 CHAPTER 4 1 requests+unittest+ddt+pymysql+dbutils+psycopg2binary+pymongo+redis+influxdb+beautifulreport+demjson+loguru+ PyYAML+ruamel.yaml+pytest+pytesthtml+allurepytest+pytestreportlog+pytestassume+pytestrerunfailures+pytestinstafail+pytestsugar+pytesttimeout+pytestparallel+tablib2 requests HTTP 3 unittest Python 4 ddt 5 PyMySQL MySQL 6 DBUtils 7 psycopg2binary PgSQL 8 pymongo Mongo 9 redis Redis 10 influxdb influxdb 11 BeautifulReport html 12 demjson json 13 loguru 14 PyYAML ruamel.yaml yaml 15 pytest 16 pytesthtml html 17 allurepytest allure 18 pytestreportlog resultlog 19 pytestassume 20 pytestrerunfailures 21 pytestinstafail 22 pytestsugar 23 pytesttimeout 24 pytestparallel 25 tablib 7

12 8 Chapter 4.

13 CHAPTER 5 1 case 2 report_log 3 resource yaml 4 setting 5 tool 6.dockerignore docker 7.gitignore.ignore 8 conftest.py 9 Dockerfile 10 Jenkinsfile Jenkins Pipeline 11 pytest.ini pytest 12 requirements.txt 9

14 10 Chapter 5.

15 CHAPTER 6 yaml json yaml case_name: step: step_name: mysql: pgsql: mongo: redis: request_mode: POST api: /api/test file: ( ) 11

16 body: { "key_1": "value_1","key_2": "value_2" } headers: { "ContentType": "application/json" } query_string: { "key_3": "value_3","key_4": "value_4" } expected_time: 3 expected_code: 200 expected_result: { "code": 1,"message": " " } regular: variable: name_1 name_2 expression: '"response_1":"(.+?)"' '"response_2":"(.+?)"' ( ) json [ { "case_name": " ", "step": [ { "step_name": " ", "mysql": [], "pgsql": [], "mongo": [], "redis": [], "request_mode": "POST", "api": "/api/test", "file": [], "body": "{\"key_1\":\"value_1\",\"key_2\":\"value_2\"}", "headers": "{'ContentType': 'application/json'}", "query_string": "{'key_3':'value_3','key_4':'value_4'}", "expected_time": 3, "expected_code": 200, "expected_result": "{\"code\":1,\"message\":\" \"}", "regular": { "variable": [ ( ) 12 Chapter 6. yaml json

17 ] } ] } } "name_1", "name_2" ], "expression": [ "\"response_1\":\"(.+?)\"", "\"response_2\":\"(.+?)\"" ] ( ) mysql mysql MySQL mysql[0] mysql[1] mysql[2] mysql 3 pgsql pgsql PgSQL pgsql[0] pgsql[1] pgsql[2] pgsql 4 mongo mysql mongo Mongo mongo[0] mongo[1] mongo[2] mongo 5 redis mysql redis Redis redis[0] redis[1] redis[2] 13

18 redis 6 file file 7 ${ } MySQL mysql[1] { SQL } { SQL0} { SQL1} { SQL2} { SQL3} PgSQL pgsql[1] { PGSQL } { PGSQL0} { PGSQL1} { PGSQL2} { PGSQL3} Mongo mongo[1] { MONGO } { MONGO0} { MONGO1} { MONGO2} { MONGO3} Redis redis[1] { MONGO } { REDIS0} { REDIS1} { REDIS2} { REDIS3} { RN } { RN15} { RL } { RL10} { MP} { RD, } { RD2019,2020} 9 ${ } 8 14 Chapter 6. yaml json

19 CHAPTER 7 demo 1 mysql demo case_name: id step: step_name: id mysql: SELECT id FROM invoice_purchaser_main WHERE purchaser_tenant_id=${tenantid} AND purchaser_org_id=${orgid} AND purchaser_company_id=${companyid} AND paper_drew_ date BETWEEN ' :00:00' AND ' :00:00' ORDER BY id DESC LIMIT 1; SELECT id FROM invoice_purchaser_main WHERE purchaser_tenant_id=${tenantid} AND purchaser_org_id=${orgid} AND purchaser_company_id=${companyid} AND paper_drew_ date BETWEEN ' :00:00' AND ' :00:00' ORDER BY id DESC LIMIT 1; request_mode: POST api: /${tenantid}/invoice/v1/pool/input/invoices/advancequery body: { "and": [ { "fieldname": "id","fieldvalue": "{ SQL0}","operationType": "EQUAL" } ],"sorts": [ { "fieldname": "id","sortno": 0,"sortType": "DESC" } ], "orgids": [ "${orgid}" ],"companyids": [ "${companyid}" ] } headers: ContentType: application/json;charset=utf8 xforcesaastoken: ${xforcesaastoken} ( ) 15

20 userid: ${userid} query_string: appid: ${appid} startpaperdrewdate: 2020/01/01 00:00:00 endpaperdrewdate: 2020/08/01 00:00:00 businessflag: 'true' pageno: 1 pagesize: 20 expected_code: 200 expected_result: { "code": "INVOICE0200","message": " ","id": "{ SQL0}" } ( ) 2 pgsql demo case_name: step: step_name: pgsql: SELECT goods_name, salesbill_no, invoice_code, invoice_no, receiver_company_ name, receiver_name, receiver_tel, receiver_addr, sender_company_name FROM goods WHERE tenant_id = '${tenantid}' ORDER BY create_time DESC LIMIT 1; request_mode: GET api: /${tenantid}/enterprise/v1/logistics/goods headers: ContentType: application/json;charset=utf8 xforcesaastoken: ${xforcesaastoken} query_string: { "appid": "${tenantid}", "ordernum": "", "goodsname": "{ SQL0}", "businessno": "{ SQL1}", "invoicecode": "{ SQL2}", "invoiceno": "{ SQL3}", "receivercompanyname": "{ SQL4}", "receivername": "{ SQL5}", "receivertel": "{ SQL6}", "receiveraddress": "{ SQL7}", "sendercompanyname": "{ SQL8}", "page": "1", "size": "20" } ( ) 16 Chapter 7. demo

21 expected_code: 200 expected_result: { "code": "LGSTZZ0200","message": " " } ( ) 3 mongo demo case_name: OPPO step: step_name: mongo: ad_qili { "imei": "{ FA0}" } { "product_name": 1,"_id": 0 } request_mode: GET api: /oppo/common/apis query_string: { "adid": " ADID ", "cid": " CID ", "imei": "{ RN38}", "mac": " MAC ", "android_id": "{ RN39}", "os": " OS ", "timestamp": " TS ", "campaign_id": " CAMPAIGN_ID ", "aid_name": " AID_NAME ", "csite": " CSITE ", "ctype": " CTYPE ", "product_name": "1812", "market_name": "oppo_01", "pkg": "com.geek.jk.weather" } expected_code: 200 expected_result: { "ret": 0,"msg": "success" } mongo_result: [ "1812" ] step_name: mongo: data_qili { "unique_id": "{ FA1}" } { "unique_id": 1,"active_match_status": 1,"active_source": 1,"active_ status": 1,"ad_market": 1,"active_day": 1,"active_error_msg": 1,"is_actual": 1,"_id ( ) ": 0 } 17

22 request_mode: POST api: /calculate body: { "common": { "upload_time": " :39:59.250", "mpc": " ", "screen_width": "720", "screen_height": "1440", "os_system": "1", "os_version": "7.1.1", "imei": "{ FA0}", "idfa": "", "model": "OPPO A83", "message_id": "1", "sdk": 0, "android_id": "{ FA1}", "uuid": "{ RN40}", "product_name": "1812" }, "events": [ { "gender": " ", "app_version": "0.0.9", "page_type": "android", "latitude": " ", "ip": " ", "receive_time": "{ RD2022,2025}", "market_name": "oppo01", "event_type": "custom", "cv": "1.2.3", "user_id": " ", "event_code": "imei", "event_name": " ", "phone_num": " ", "network_type": "WIFI", "age": " ", "oaid": "", "longitude": " ", "province": "provincetest", "city": "test", "ts": " :39:59.250" } ] } ( ) ( ) 18 Chapter 7. demo

23 ( ) headers: { "ContentType": "application/json;charset=utf8" } expected_code: 200 expected_result: { "ret": 0,"msg": "success" } mongo_result: [ "{ FA1}", "1", "oppo", "1", "oppo_01","{ TODAY}", " ", "1" ] step_name: mongo: data_qili update { "unique_id": "{ FA1}" } { "$set": { "active_day": "{ YESTERDAY}" } } data_qili { "unique_id": "{ FA1}" } { "unique_id": 1,"active_match_status": 1,"active_source": 1,"active_ status": 1,"ad_market": 1,"active_day": 1,"active_error_msg": 1,"is_actual": 1, "next_day_retain_status": 1,"next_day_error_msg": 1,"next_day_retain_day": 1,"_id": 0 } request_mode: POST api: /calculate body: { "common": { "upload_time": " :39:59.250", "mpc": " ", "screen_width": "720", "screen_height": "1440", "os_system": "1", "os_version": "7.1.1", "imei": "{ FA0}", "idfa": "", "model": "OPPO A83", "message_id": "1", "sdk": 0, "android_id": "{ FA1}", "uuid": "{ FA2}", "product_name": "1812" }, "events": [ { "gender": " ", "app_version": "0.0.9", "page_type": "android", "latitude": " ", ( ) 19

24 "ip": " ", "receive_time": "{ RD2022,2025}", "market_name": "oppo01", "event_type": "cold_start", "cv": "1.2.3", "user_id": " ", "event_code": "cold_start", "event_name": " ", "phone_num": " ", "network_type": "WIFI", "age": " ", "oaid": "", "longitude": " ", "province": "provincetest", "city": "test", "ts": " :39:59.250" } ] } headers: { "ContentType": "application/json;charset=utf8" } expected_code: 200 expected_result: { "ret": 0,"msg": "success" } mongo_result: [ "{ FA1}", "1", "oppo", "1", "oppo_01","{ YESTERDAY}", " ", "1", "1", " ", "{ TODAY}" ] ( ) 20 Chapter 7. demo

25 CHAPTER 8 Apollo demo test_scenario= XXX test_story= XXX test_case_priority=critical test_case_address= test_case_address_title=xxx # allure beautiful_filename=xxx_report beautiful_description=xxx # BeautifulReport html_report_title=xxx project_name=xxx swagger_address= test_department= tester= # conftest test_case_format=yaml # yaml json # first_test_case_file=demo_one.yaml # robot=feishu # feishu dingtalk # feishu_webhook= ( ) 21

26 # webhook feishu_secret=abcdefghij # card_header_title_content= # card_elements_actions_text_content= # card_elements_actions_url= # dingtalk_webhook= # webhook dingtalk_secret= abcdefghij # wechat_webhook= # webhook influxdb_switch=true # influxdb, true # influxdb_host= influxdb_port=8086 influxdb_database=influxdb_database influxdb_user=root influxdb_password= influxdb_measurement=influxdb_measurement # InfluxDB db_host=mysql.test.com db_port=3306 db_user=root db_password= db_database= # MySQL pgsql_host=pgsql.test.com pgsql_port=5432 pgsql_user=root pgsql_password= pgsql_database=pgsql_db_1 # PgSQL mongo_host=mongo.test.com mongo_port=27017 mongo_database=mongo_db_1 mongo_user=root mongo_password= # Mongo ( ) ( ) 22 Chapter 8. Apollo demo

27 redis_host=redis.test.com redis_port=6379 redis_password= redis_database=0 # Redis ( ) 23

28 24 Chapter 8. Apollo demo

29 CHAPTER 9 1 unittest python+ + python case/demo_test.py dev python case/demo_test.py test python case/demo_test.py pre python case/demo_test.py formal 2 pytest pytest+ cmd= pytest cmd=dev pytest cmd=test pytest cmd=pre pytest cmd=formal 3 yamlapi yamlapi+run+ c= yamlapi run c=dev yamlapi run c=test yamlapi run c=pre yamlapi run c=formal 4 report_log allurereportlog.logreport.htmlreport.xmltest_case.csvtest_case.htmltest_case.jsontest_case.xlsxtest_case.yaml 25

30 26 Chapter 9.

31 CHAPTER 10 docker pull registry.cnhangzhou.aliyuncs.com/yangjianliang/yamlapi:0.0.8 yamlapi docker build t demo_image.docker build t. demo_image docker run e cmd= :latestdocker run e cmd="dev" demo_image:latest docker run e cmd="test" demo_image:latest docker run e cmd="pre" demo_image:latest docker run e cmd="formal" demo_image:latest 27

32 28 Chapter 10.

33 CHAPTER 11 genindex modindex search 29

Contents 1 深圳大学经济学院学生代表大会章程 2 2 优秀毕业生评选细则 7 3 议事规则 8 i

Contents 1 深圳大学经济学院学生代表大会章程 2 2 优秀毕业生评选细则 7 3 议事规则 8 i 深圳大学经济学院学代委执事指南发布 0.0.1 深圳大学经济学院学代委 2016 年 05 月 25 日 Contents 1 深圳大学经济学院学生代表大会章程 2 2 优秀毕业生评选细则 7 3 议事规则 8 i ii 深圳大学经济学院学代委执事指南, 发布 0.0.1