"以太网TCP/IP协议测试报告及配置分析"

以太网测试
TCPIP
需积分: 9 6 下载量 129 浏览量 更新于2024-01-12 1 收藏 19.05MB PDF 举报
The "Report_TC8_Test_Configuration.pdf" is a detailed report on the testing configuration and results of the Ethernet TCP/IP protocol. The report provides a comprehensive analysis of the test configuration, test case results, general information, and test setup. The test configuration consists of 305 test cases, out of which 51.6% were marked as fail, 80.7% as pass, and 17.7% as inconclusive. There were no errors in the test system, resulting in a total of 100% completion of the test cases. The test began on 3/6/2021 at 10:02:45 PM and concluded at 3/6/2021 11:17:26 PM. The tester utilized Windows Login Name: 36560 and the test setup version was CANoe.CAN.Ethernet /pro 13.0.155 (SP2) with the configuration location at D:\Program Files (x86)\someIP\EthernetTC8Test_v1_3_1-yuan\EthernetTC8Test\EthernetTC8Test.cfg. Additionally, the database TC8_TES was referenced. Overall, the report provides a comprehensive overview of the testing process, results, and configuration, allowing for a thorough understanding of the performance of the Ethernet TCP/IP protocol.

性能测试报告.pdf

2019-08-21 上传
LoadRunner性能测试巧匠训练营高级性能测试技术，花钱得到的干货拿出来分享

Automotive_Ethernet_TestSpecification_v2.0_TC8_ECU_TEST.pdf.zip

2021-12-02 上传
Automotive_Ethernet_ECU_TestSpecification_v2.0_TC8_ECU_TEST 汽车以太网测试规范TC8-V2.0最终版

车载以太网OPEN联盟TC8测试规范。OA_Automotive_Ethernet_ECU_TestSpecification_v2.0.pdf

2019-05-13 上传
open联盟TC8测试规范是行业的标准测试规范，包括物理层PMA,IOP,TCP/IP/ARP等协议一致性测试。

SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs.receivable_fee, bs.sample_no, bs.ranges, bs.grade, bs.sample_remark AS remark, bs.factory, bs.item_name, bs.apply_dept, bs.specification, bs.factory_number, bs.calibrat_point, bs.mandatory_flag, bs.inspection_type, bs.report_org_name, bs.plan_complete_date, bs.standard_instrument_name, bs.bleeding_site_name, bs.arrive_date, DATEDIFF( bs.plan_complete_date, NOW()) AS surplus_days, bs.order_no, bs.order_type, bs.customer_name, bs.order_id, bs.business_type, bs.group_id, bs.group_name, bs.item_id, bs.is_merge, bs.pass_time, bs.audit_time, bs.report_id, bs.compile_time, bs.generate_time, bs.pass_user_name, bs.audit_user_name, bs.compile_user_name, bs.report_state, bs.is_just_certificate, bs.label_price, bs.labor_cost, bs.product_type, bs.batch_number, bs.original_number, bs.type_no, bs.template_id, bs.template_version, bs.standard_instrument_id, bs.standard_instrument_name, bs.report_query_code, bs.test_user_id, bs.test_user_name, bs.test_time, bs.review_user_id, bs.review_user_name, bs.review_time, bs.or_number, bs.test_result, bs.test_result_text, bs.test_date, bs.test_address, bs.result_value, bs.unit, bs.test_dept_id, bs.test_dept_name, bs.sample_mass, bs.form, bs.color, bs.clarity, bs.amplification_detection, bs.precious_metal, bs.remarks, bs.photo, bs.identifying_code, bs.diamond_quality, bs.hand_ring, bs.craft, bs.instrument_photo, bs.customer_item_basis, bs.quality_photo, bs.check_point, bs.check_code, bs.mass_unit, bs.manufacturer_name, bs.manufacturer_addr, bs.result_sample_describe AS sampleDescribe, bs.test_rule AS metalRuleIdsStr, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 需要按照bs.report_no 的整数来从小到大进行排序

2023-07-15 上传
你可以使用以下SQL语句来按照bs.report_no的整数值从小到大进行排序： ```sql SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs.receivable_fee, bs....

SELECT bs.sample_id, bs.item_id, bs.report_id, bs.order_no, bs.order_id, bs.order_business_type, bs.commission_date, bs.customer_name, bs.applicant, bs.phone, bs.receive_user_name, bs.contract_no, bs.special_requirements, bs.report_org_name, bs.report_org_address, bs.sample_name, bs.standard_instrument_name, bs.complete_day, bs.sample_remark AS remark, bs.standard_instrument_id, bs.sample_no, bs.factory_number, bs.item_name, /*bs.item_quantity,*/ bs.inspection_type, bs.mandatory_flag, bs.test_quantity, bs.sample_state, bs.current_site, bs.plan_complete_date, bs.affix, bs.ranges, bs.grade, bs.factory, bs.calibrat_point, bs.apply_dept, bs.specification, bs.final_fee, bs.service_type, CASE WHEN bs.actual_complete_date IS NOT NULL THEN DATEDIFF( bs.plan_complete_date, bs.actual_complete_date ) ELSE datediff( bs.plan_complete_date, now()) END AS surplus_days, bs.report_no, bs.is_report_back, bs.back_reason AS report_back_reason, bs.is_just_certificate, bs.report_state, bs.temper, bs.humidity, bs.test_result, bs.test_date, bs.next_test_date, bs.test_cycle, bs.test_address, bs.generate_time, bs.point_report_id, bs.is_merge, bs.circulation_flag, bs.item_proposal_fee AS proposal_fee, bs.change_price_reason, bs.test_user_name, bs.group_id, bs.group_name, bs.charging_num, bs.other_fee, bs.receivable_fee, bs.affix_quantity, bs.test_org, bs.out_org_order_no, bs.out_org_sample_no, bs.business_user_name, bs.pdf_path, bs.settlement_state, bs.result_describe, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 根据bs.commission_date 进行排序最近的排上面 bs.commission_date

2023-07-15 上传
bs.pdf_path, bs.settlement_state, bs.result_describe, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id ...

bs.report_no 是 varchar

2023-07-15 上传
如果bs.report_no是varchar类型的，并且其中只包含数字，你可以使用以下SQL语句进行排序： ```sql SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs....

SELECT f.PAR_FAULT_CODE AS "parFaultCode", f.FAULT_NAME AS "faultName", COALESCE( r.REPORT_DEPT_CODE, 'N/A' ) AS "reportDeptCode", COUNT( r.REPORT_DEPT_CODE ) AS "report", ( SELECT COUNT( * ) FROM FAULT_REPORT d WHERE d.FAULT_CODE = f.FAULT_CODE ) AS "reportCount" FROM FAULT_TYPE f LEFT JOIN FAULT_REPORT r ON f.FAULT_CODE = r.FAULT_CODE GROUP BY f.PAR_FAULT_CODE, f.FAULT_NAME, COALESCE( r.REPORT_DEPT_CODE, 'N/A' ) ORDER BY f.PAR_FAULT_CODE, f.FAULT_NAME为什么在oracle中报不是group by表达式，请帮我正确修改

2023-06-10 上传
在你的查询中，COUNT(r.REPORT_DEPT_CODE)是一个聚合函数，但是GROUP BY子句中只包含了f.PAR_FAULT_CODE、f.FAULT_NAME和COALESCE(r.REPORT_DEPT_CODE, 'N/A')三个字段，没有包含COUNT(r.REPORT_DEPT_CODE)。...

SELECT f.PAR_FAULT_CODE AS "parFaultCode", (SELECT t.FAULT_NAME FROM FAULT_TYPE t WHERE f.PAR_FAULT_CODE = t.FAULT_CODE) AS "faultName", COALESCE( r.REPORT_DEPT_CODE, 'N/A' ) AS "reportDeptCode", COUNT( r.REPORT_DEPT_CODE ) AS "report", COUNT(*) AS "reportCount" FROM FAULT_TYPE f LEFT JOIN FAULT_REPORT r ON f.FAULT_CODE = r.FAULT_CODE GROUP BY f.PAR_FAULT_CODE, f.FAULT_NAME, COALESCE( r.REPORT_DEPT_CODE, 'N/A' ), f.FAULT_CODE ORDER BY f.PAR_FAULT_CODE, f.FAULT_NAME按parfaultcode的report的和加到一起放到reportCount字段怎么修改

2023-06-10 上传
COUNT(r.REPORT_DEPT_CODE) AS "report", SUM(COUNT(r.REPORT_DEPT_CODE)) OVER (PARTITION BY f.PAR_FAULT_CODE) AS "reportCount" FROM FAULT_TYPE f LEFT JOIN FAULT_REPORT r ON f.FAULT_CODE = r.FAULT_...

将下面SQL语句通过sqlalchemy转换成orm语句实现：ELECT j.element, count(distinct b.requisition_no) as cnt FROM dws_v2_test.dws_biz_detail b JOIN dws_v2_test.dws_test_result p ON b.requisition_no=p.requisition_no JOIN JSON_TABLE(p.biok_category, '$[*]' columns (element varchar(50) path '$')) j WHERE b.tech_platform=:tech_platform AND b.prod_id=:prod_id and b.biz_type=:biz_type and b.report_status like '报告%' and b.report_result=:report_result and b.serv_id in :service_ids and j.element <> '' GROUP BY j.element;

2023-06-02 上传
b.report_status.like('报告%'), b.report_result == :report_result, b.serv_id.in_(service_ids)) query = query.group_by(j.element) # 获取查询结果 result = query.all() ``` 其中，`models`是你定义的ORM...

SELECT f.PAR_FAULT_CODE AS "parFaultCode", f.FAULT_NAME AS "faultName", COALESCE( r.REPORT_DEPT_CODE, 'N/A' ) AS "reportDeptCode", COUNT( r.REPORT_DEPT_CODE ) AS "report", SUM(COUNT(r.REPORT_DEPT_CODE)) OVER (PARTITION BY f.FAULT_CODE) AS "reportCount" FROM FAULT_TYPE f LEFT JOIN FAULT_REPORT r ON f.FAULT_CODE = r.FAULT_CODE GROUP BY f.PAR_FAULT_CODE, f.FAULT_NAME, COALESCE( r.REPORT_DEPT_CODE, 'N/A' ), f.FAULT_CODE ORDER BY f.PAR_FAULT_CODE, f.FAULT_NAME在fauleName加一个标题为合计字段 并且根据reportDeptCode分组算出对应的reportCount

2023-06-10 上传
COUNT(r.REPORT_DEPT_CODE) AS "report", SUM(COUNT(r.REPORT_DEPT_CODE)) OVER (PARTITION BY f.FAULT_CODE) AS "reportCount" FROM FAULT_TYPE f LEFT JOIN FAULT_REPORT r ON f.FAULT_CODE = r.FAULT_CODE ...
jack_st
  • 粉丝: 16
  • 资源: 13
上传资源 快速赚钱

最新资源