Debian Codegraph @

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

raw
1 ## Following macros are defined in this file:
2 #
3 # * Test_assert_user_variable
4 # * Test_reset_variables
5 # * Test_prepare_and_execute_proc_arg0
6 # * Test_prepare_and_execute_proc_arg1
7 # * Test_prepare_and_execute_proc_arg2
8 #
9
10
11 -->macro Test_assert_user_variable %VAR_NAME% %VALUE%
12 callmacro Assert_user_variable %VAR_NAME% %VALUE%;
13 -->endmacro
14
15
16 -->macro Test_reset_variables
17 noquery_result;
18 echo [Reseting test variables];
19 SET @res=-1;
20 SET @min_val=-1;
21 SET @max_val=-1;
22 SET @in_val=5;
23 query_result;
24 -->endmacro
25
26
27 -->macro_varg Test_prepare_and_execute_proc_arg0 %PROC_NAME%
28 quiet;
29 noquery_result;
30 echo [Execute %PROC_NAME%];
31 stmtsql CALL %PROC_NAME%;
32 noquiet;
33 query_result;
34 %VAR_ARGS%
35 -->recvresult
36 -->endmacro
37
38
39 -->macro_varg Test_prepare_and_execute_proc_arg1 %PROC_NAME% %OUT_PARAM1%
40 quiet;
41 noquery_result;
42 varlet %NAME% %PROC_NAME%;
43 varreplace %NAME% ? %OUT_PARAM1%;
44 echo [Execute %NAME%];
45 stmtsql CALL %NAME%;
46 noquiet;
47 query_result;
48 %VAR_ARGS%
49 -->recvresult
50 -->endmacro
51
52
53 -->macro_varg Test_prepare_and_execute_proc_arg2 %PROC_NAME% %OUT_PARAM1% %OUT_PARAM2%
54 quiet;
55 noquery_result;
56 varlet %NAME% %PROC_NAME%;
57 varreplace %NAME% ? %OUT_PARAM1%;
58 varreplace %NAME% ? %OUT_PARAM2%;
59 stmtsql CALL %NAME%;
60 echo [Execute %NAME%];
61 noquiet;
62 query_result;
63 %VAR_ARGS%
64 -->recvresult
65 -->endmacro