Shell和Python脚本测试数据库读写速度

#!/bin/bash


START_TIME=`date +%s`
curl  -k -X POST -d '{"attrs":["cn"],"filter":"(&(objectClass=groupOfNames)(groupName=autotest))" }'   https://cn=mailcontrol%20\(admin\),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg@wrest:8085/rs/v-1/search
END_TIME=`date +%s`
COST1=$((END_TIME-START_TIME))


START_TIME=`date +%s`
curl  -k -X POST -d '{"filter":"(&(objectClass=person)(mail=test_enduser_68@websense.com))" }'   https://cn=mailcontrol%20\(admin\),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg@wrest:8085/rs/v-1/search
END_TIME=`date +%s`
COST2=$((END_TIME-START_TIME))


START_TIME=`date +%s`
curl -k -X GET https://cn=mailcontrol%20\(admin\),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg@wrest:8085/rs/v-1/ou-devices/udid-4B6D5E40DFB22BD57EC4AF54DA1F297A3221389B2
END_TIME=`date +%s`
COST3=$((END_TIME-START_TIME))


START_TIME=`date +%s`
curl -k --user "cn=mdm-service (admin),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg" https://cog01o:8085/rs/v-1/search -X POST -d '{"base":"account=87","filter":"(&(objectClass=hostedUser)(mail=test_enduser_2@websense.com))"}'
END_TIME=`date +%s`
COST4=$((END_TIME-START_TIME))


echo "Time cost to query the group in RS cost: $COST1 seconds!"
echo "Time cost to query the enduser in RS cost: $COST2 seconds!"
echo "Time cost to query the device info. in RS cost: $COST3 seconds!"

echo "Time cost to query the PAC URL in RS cost: $COST4 seconds!"

#!/bin/bash


START_TIME1=`date +%s`
#START_TIME1=`date +%N`
#echo $START_TIME1
curl -k -X POST https://cn=mailcontrol%20\(admin\),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg@wrest:8085/rs/v-1/bulk -d '[{"method":"modify","dn":"udid=4B6D5E40DFB22BD57EC4AF54DA1F297A3235436B14049,ou=devices,dc=blackspider,dc=com","params":[{"values":0,"attribute":"mdmDeviceId","type":"replace"}]}]'
END_TIME1=`date +%s`
#END_TIME1=`date +%N`
#echo $END_TIME1
COST1=$((END_TIME1-START_TIME1))


START_TIME2=`date +%s`
#START_TIME2=`date +%N`
#echo $START_TIME2
curl  -k -X POST https://cn=mailcontrol%20\(admin\),account=1,dc=blackspider,dc=com:7Nz+BXcOXW3ZTXgZptPmRg@wrest:8085/rs/v-1/ou-devices/udid-4B6D5E40DFB22BD57EC4AF54DA1F297A3235436B14049 -d '{"method":"modify","params":[{"values":0,"attribute":"mdmDeviceId","type":"replace"}]}'
END_TIME2=`date +%s`
#END_TIME2=`date +%N`
#echo $END_TIME2
COST2=$((END_TIME2-START_TIME2))


echo "Time cost to update device info. in RS with bulk cost: $COST1 seconds!"
echo "Time cost to update device info. in RS cost with NON-bulk: $COST2 seconds!"

-------------------------------------------------------------------------------------------------------------------------------------------------

import os
import json
import sys
import time


sys.path.append("/opt/mdmi/modules")
from hosteddb.hosted_device import HostedDevice


class testRSvlv():


def get_devices(self):
'''
get devices from RS, return all the devices for vlv query time cost
'''
device = HostedDevice()
rtn = 1
page_num = 0
page_size = 500
while rtn > 0:
starttime = time.time()
result = device.do_get_many(page_num, page_size, 'devicePlatform')
endtime = time.time()
sec_cost = endtime - starttime
val = json.loads(result.content)
rtn = len(val)
print "vlv query device info. from RS,  page index: %d, %d devices, time cost is %d seconds" % (page_num, rtn, sec_cost)
page_num += 1


if __name__ == '__main__':
vlv = testRSvlv()
vlv.get_devices()