《Loadrunner测试数据库性能,测试SQL语句性能的脚本例子》由会员分享,可在线阅读,更多相关《Loadrunner测试数据库性能,测试SQL语句性能的脚本例子(8页珍藏版)》请在金锄头文库上搜索。
1、Loadrunner 测试数据库性能,测试 SQL 语句性能的脚本例子 此代码为Loadrunner 8 通过C API类型的Vuser测试MySQ性能,或者测试 sql 语句性能的脚本。这东西很少有人用,网上资料很少,一般测试 B/S 的很多。view plaincopy to clipboardprint?/* 需要的表结构如下CREATE TABLE test_data (order_id BIGINT UNSIGNED NOT NULL COMMENT Order numbers. Must be unique.,status BOOL NOT NULL DEFAULT 0 COMME
2、NT Whether data has been used or not. A value of 0 means FALSE.,date_used DATETIME NULL COMMENT Date/time that the data was used., UNIQUE (order_id) ENGINE = innodb COMMENT = LoadRunner test data;*/Action()数据库连接查询结果集 MYSQL_RES查询的数据衕int rc;int db_connection; / int query_result; / char* result_row; /
3、char *server = localhost; char *user = root;char *password = 123456;char *database = test; int port = 3306;int unix_socket = NULL;int flags = 0;/ 找到 libmysql.dll 的所在位置 .rc = lr_load_dll(C:Program FilesMySQLMySQL Server5.1binlibmysql.dll);if (rc != 0) lr_error_message(Could not load libmysql.dll); lr
4、_abort();/创建MySQ对象 db_connection = mysql_init(NULL); if (db_connection = NULL) lr_error_message(Insufficient memory); lr_abort();/连接到MySQ数据库rc = mysql_real_connect(db_connection, server, user, password, database, port, unix_socket, flags);if (rc = NULL) lr_error_message(%s, mysql_error(db_connection
5、); mysql_close(db_connection);lr_abort();/ 向数据库插入数据/ 此处的 ORDER_ID 是一个参数,简单测试时可以用一个常数代替 lr_save_string (lr_eval_string(INSERTINTO test_data (order_id) VALUES(ORDER_ID),paramInsertQuery);rc = mysql_query(db_connection, lr_eval_string(paramInsertQuery);if (rc != 0) lr_error_message(%s, mysql_error(db_c
6、onnection); mysql_close(db_connection);lr_abort();/ 从数据库读取一个数据并显示rc = mysql_query(db_connection, SELECT order_id FROM test_data WHERE status IS FALSE LIMIT 1);if (rc != 0) lr_error_message(%s, mysql_error(db_connection); mysql_close(db_connection);lr_abort(); query_result = mysql_use_result(db_conne
7、ction); if (query_result = NULL) lr_error_message(%s, mysql_error(db_connection); mysql_free_result(query_result);mysql_close(db_connection);lr_abort();/ 如果结果集包含多行数据,需要多次调用 mysql_fetch_row 直到返回 NULLresult_row = (char *)mysql_fetch_row(query_result);if (result_row = NULL) lr_error_message(Did not exp
8、ect the result set to be empty); mysql_free_result(query_result);mysql_close(db_connection);lr_abort();/ 保存参数,用于删除这行数据 lr_save_string(result_row0, paramOrderID); lr_output_message(Order ID is: %s, lr_eval_string(paramOrderID); mysql_free_result(query_result);/ 在事务里更新一行数据,需要用 InnoDB 引擎 rc = mysql_que
9、ry(db_connection, BEGIN); / 启动事务 if (rc != 0) lr_error_message(%s, mysql_error(db_connection); mysql_close(db_connection);lr_abort();/使用FOR UPDATE锁住要更新的数据行rc = mysql_query(db_connection, SELECT order_id FROM test_data WHERE status IS FALSE LIMIT 1 FOR UPDATE);if (rc != 0) lr_error_message(%s, mysql_
10、error(db_connection); mysql_close(db_connection);lr_abort();query_result = mysql_use_result(db_connection);if (query_result = NULL) lr_error_message(%s, mysql_error(db_connection); mysql_free_result(query_result);mysql_close(db_connection);lr_abort();result_row = (char *)mysql_fetch_row(query_result
11、);if (result_row = NULL) lr_error_message( 没有查询到结果 ); mysql_free_result(query_result);mysql_close(db_connection);lr_abort(); lr_save_string(result_row0, paramOrderID); lr_output_message(Order ID is: %s,lr_eval_string(paramOrderID); mysql_free_result(query_result);lr_save_string(lr_eval_string(UPDATE
12、 test_data SET status=TRUE, date_used=NOW() WHERE order_id=paramOrderID),paramUpdateQuery);rc = mysql_query(db_connection, lr_eval_string(paramUpdateQuery);if (rc != 0) lr_error_message(%s, mysql_error(db_connection); mysql_close(db_connection);lr_abort();rc = mysql_query(db_connection, COMMIT); /提交
13、事务if (rc != 0) lr_error_message(%s, mysql_error(db_connection); mysql_close(db_connection);lr_abort();/ 再次查找数据,应该为空了,因为前面的事务更新了标志rc = mysql_query(db_connection, SELECT order_id FROM test_data WHERE status IS FALSE LIMIT 1);if (rc != 0) lr_error_message(%s, mysql_error(db_connection); mysql_close(db_
14、connection);lr_abort();query_result = mysql_use_result(db_connection);if (query_result = NULL) lr_error_message(%s, mysql_error(db_connection); mysql_free_result(query_result);mysql_close(db_connection);lr_abort();result_row = (char *)mysql_fetch_row(query_result);if (result_row = NULL) lr_output_me
15、ssage(Result set is empty as expected); mysql_free_result(query_result); else lr_error_message(Did not expect the result set to contain any rows);mysql_free_result(query_result); mysql_close(db_connection);lr_abort();/ 删除数据lr_save_string(lr_eval_string(DELETE FROM test_data WHERE order_id = paramOrderID),paramDeleteQuery);rc = mysql_query(db