Python Server端性能测试 - Mock环境搭建

最新推荐文章于 2024-05-06 15:09:28 发布

原创

最新推荐文章于 2024-05-06 15:09:28 发布 · 287 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#automation test #tool #python

这篇博客探讨了如何进行Python服务器端的性能测试，重点在于如何搭建Mock环境。内容包括模拟删除用户（id>6000）和从groups表中选择id大于27的记录的SQL操作，以及两个存储过程`sp_deleteDevices`和`sp_updateDevices`的详细步骤，这些存储过程用于批量处理和更新devices表中的数据。

1, create a stored procedure in mysql;

   1, copy sp.sql to /root/ on dev01o

   2, log on mysql

   3, source /root/sp.sql

2,   delete devices where id>24000;

3, delete users where id >6000;

4, execute sql: call sp_deleteDevices;

5, export device data:

1: create an view in mysql
create view view_devices as select `d`.`Id` AS `Id`,`d`.`Udid` AS `Udid`,`d`.`SerialNumber` AS `SerialNumber`,`d`.`MacAddress` AS `MacAddress`,`d`.`Imei` AS `Imei`,`d`.`AssetNumber` AS `AssetNumber`,`d`.`DeviceFriendlyName` AS `DeviceFriendlyName`,`g`.`Name` AS `LocationGroupName`,`l`.`DisplayName` AS `GroupLocation`,`u`.`UserName` AS `UserName`,`u`.`Email` AS `Email`,`d`.`Ownership` AS `Ownership`,`p`.`Platform` AS `Platform`,`m`.`ModelName` AS `ModelName`,`d`.`OperatingSystem` AS `OperatingSystem`