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;
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`
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;
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`

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

被折叠的 条评论
为什么被折叠?



