qdyxmas's Room

Done is better than perfect...

禅道统计bug

select count(case when openedDate>=20181215 and openedDate<=20190103 then id end) as "w1", count(case when openedDate>=20190104 and openedDate<=20190115 then id end) as "w2",
count(case when openedDate>=20190116 and openedDate<=20190210 then id end) as "w3",
count(case when openedDate>=20190211 and openedDate<=20190222 then id end) as "w4",
count(case when openedDate>=20190223 and openedDate<=20190303 then id end) as "w5",
count(case when openedDate>=20190304 and openedDate<=20190317 then id end) as "w6",
count(case when openedDate>=20190318 and openedDate<=20190324 then id end) as "w7",
count(case when openedDate>=20190325 then id end) as "w8" from zt_bug

阅读全文 »

pytest+allure+katalon+UI

https://www.missshi.cn/api/view/blog/5af97f3613d85b1617000000 https://docs.pytest.org/en/latest/ https://www.allure.com/ https://docs.pytest.org/en/latest/#documentation

阅读全文 »

重新拉取分支执行

拉取分支

git fetch
git checkout -b dev origin/dev  ;dev为本地分支 origin/dev为远程分支名    
git pull origin

python3 testrun_tmp.py 9217092b0a6bd6750349d395cde8b5e80e55dc05 2795 origin/feature/wyy_jiazhaoye_data test_backend

阅读全文 »

grpc性能测试工具ghz

CAD

cad_processor

Download:

    ghz  --insecure  --proto cad_processor.proto --call cad_processor.service.CadProcessor.Download -d '{"source_file":"","geometry_entity_list":{},"text_entity_list":{}}' 10.0.0.131:8102

Upload:

    ghz  --insecure  --proto cad_processor.proto --call cad_processor.service.CadProcessor.Upload -d '{"source_file":"cad_processor.proto"}' 10.0.0.131:8102

ConnectionTest:

    ghz  --insecure  --proto cad_processor.proto --call cad_processor.service.CadProcessor.ConnectionTest -d '' 10.0.0.131:8102

Ping:

    ghz  --insecure  --proto cad_processor.proto --call cad_processor.service.CadProcessor.Ping -d '{"current_timestamp":1}' 10.0.0.131:8102

PPT

ppt_service

GeneratePpt

    ghz  --insecure  --proto ppt_service.proto --call ppt_service.service.PptService.GeneratePpt -d '{"title":"","template_name":"","legal_entity_name":"","plans":{},"project":{},"divisions":{},"base_multipolygon_wkt":"","task_id":1,"plans_imgs_data_urls":"","map_imgs_data_urls":"","echarts_imgs_data_urls":"","recommended_plan_json":"{}","recommended_project_json":"{}","recommended_residences_json":"{}"}' 10.0.0.131:7749

Ping

    ghz  --insecure  --proto ppt_service.proto --call ppt_service.service.PptService.Ping -d '{"current_timestamp":1}' 10.0.0.131:7749

task center

task_center

poolTask:

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.PoolTask -d '{"task_name":"1","priority":3,"arguments":"{}","pool_name":""}' 10.0.0.131:7000

BroadcastTask

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.BroadcastTask -d '{"task_name":"1","arguments":"{}","topic_name":""}' 10.0.0.131:7000

CancelTask

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.CancelTask -d '{"task_id":"1","topic_name":""}' 10.0.0.131:7000

QueryTaskStatus

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.QueryTaskStatus -d '{"task_ids":1}' 10.0.0.131:7000

UpdateTaskStatus

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.UpdateTaskStatus -d '{"task_id":1,"current_state":"","info":"","description":""}' 10.0.0.131:7000

RedoTask

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.RedoTask -d '{"task_id":1}' 10.0.0.131:7000

Ping

ghz  --insecure  --proto task_center.proto --call task_center.service.TaskCenter.Ping -d '{"current_timestamp":1}' 10.0.0.131:7000

阅读全文 »