Debian Codegraph @

mysql-test/suite/x/t/macros/assert_status_variable.macro

raw
1 # * Wait_for_status_variable
2 # * Assert_status_variable
3 # * Assert_received_notices
4 # * Assert_set_like_status_variable
5 # * Assert_client_message_count
6
7 -->macro Wait_for_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
8 quiet;
9 -->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
10 wait_for %EXPECTED_VALUE%
11 SELECT VARIABLE_VALUE FROM performance_schema.session_status WHERE VARIABLE_NAME LIKE '%VARIABLE_NAME%';
12 noquiet;
13 -->endmacro
14
15 -->macro Wait_for_global_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
16 quiet;
17 -->echo Verify [Global status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
18 wait_for %EXPECTED_VALUE%
19 SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%VARIABLE_NAME%';
20 noquiet;
21 -->endmacro
22
23
24 -->macro Assert_global_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
25 -->stmtsql SHOW GLOBAL STATUS LIKE '%VARIABLE_NAME%';
26 -->recvtovar %VARIABLE_VALUE% Value
27 -->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
28 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
29 -->endmacro
30
31
32 -->macro Assert_status_variable %VARIABLE_NAME% %EXPECTED_VALUE%
33 -->stmtsql SHOW STATUS LIKE '%VARIABLE_NAME%';
34 -->recvtovar %VARIABLE_VALUE% Value
35 -->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
36 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
37 -->endmacro
38
39 -->macro Assert_set_like_status_variable %VARIABLE_NAME% %DELIMITER% %EXPECTED_VALUE%
40 quiet;
41 -->stmtsql select FIND_IN_SET("%EXPECTED_VALUE%", REPLACE(VARIABLE_VALUE,"%DELIMITER%",","))>0 as Value from performance_schema.session_status where VARIABLE_NAME like '%VARIABLE_NAME%';
42 -->recvtovar %RESULT% Value
43 -->echo Verify [Status variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
44 -->assert_eq 1 %RESULT%
45 noquiet;
46 -->endmacro
47
48 -->macro Assert_session_variable %VARIABLE_NAME% %EXPECTED_VALUE%
49 -->stmtsql SHOW SESSION VARIABLES LIKE '%VARIABLE_NAME%';
50 -->recvtovar %VARIABLE_VALUE% Value
51 -->echo Verify [Session variable "%VARIABLE_NAME%" needs to have a value of %EXPECTED_VALUE%]
52 -->assert_eq %EXPECTED_VALUE% %VARIABLE_VALUE%
53 -->endmacro
54
55
56 -->macro Assert_received_notices
57 -->received Mysqlx.Notice.Warning %MYSQLXTEST_NO_OF_WARNINGS%
58 -->received Mysqlx.Notice.GroupReplicationStateChanged %MYSQLXTEST_NO_OF_GLOBAL%
59 -->received Mysqlx.Notice.ServerHello %MYSQLXTEST_NO_OF_SERVER_HELLOS%
60 -->varlet %ALL_GLOBALS% %MYSQLXTEST_NO_OF_SERVER_HELLOS%
61 -->varinc %ALL_GLOBALS% %MYSQLXTEST_NO_OF_GLOBAL%
62 -->callmacro Assert_status_variable Mysqlx_notice_global_sent %ALL_GLOBALS%
63 -->callmacro Assert_status_variable Mysqlx_notice_warning_sent %MYSQLXTEST_NO_OF_WARNINGS%
64
65 -->received Mysqlx.Notice.Frame %MYSQLXTEST_NO_OF_OTHER%
66 -->varinc %MYSQLXTEST_NO_OF_OTHER% -%MYSQLXTEST_NO_OF_WARNINGS%
67 -->varinc %MYSQLXTEST_NO_OF_OTHER% -%ALL_GLOBALS%
68 -->callmacro Assert_status_variable Mysqlx_notice_other_sent %MYSQLXTEST_NO_OF_OTHER%
69 -->endmacro
70
71
72 -->macro Assert_client_message_count %NAME% %OP% %COUNT%
73 noquery_result;
74 echo Verify [Client handled %NAME% message count is "%OP%" %COUNT%];
75 -->received %NAME% %MYSQLXTEST_NO_OF_MESSAGES%
76 -->assert %MYSQLXTEST_NO_OF_MESSAGES% %OP% %COUNT%
77 query_result;
78 -->endmacro