Debian Codegraph @

mysql-test/suite/x/t/macros/test_multiple_resultsets_sql_prepare.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 [Prepare and execute %PROC_NAME%];
31 PREPARE stmt FROM 'CALL xtest.%PROC_NAME%';
32 stmtsql EXECUTE stmt;
33 noquiet;
34 query_result;
35 %VAR_ARGS%
36 -->recvresult
37 quiet;
38 noquery_result;
39 DEALLOCATE PREPARE stmt;
40 noquiet;
41 query_result;
42 -->endmacro
43
44
45 -->macro_varg Test_prepare_and_execute_proc_arg1 %PROC_NAME% %OUT_PARAM1%
46 quiet;
47 noquery_result;
48 echo [Prepare and execute %PROC_NAME%];
49 PREPARE stmt FROM 'CALL xtest.%PROC_NAME%';
50 stmtsql EXECUTE stmt USING %OUT_PARAM1%;
51 noquiet;
52 query_result;
53 %VAR_ARGS%
54 -->recvresult
55 quiet;
56 noquery_result;
57 DEALLOCATE PREPARE stmt;
58 noquiet;
59 query_result;
60 -->endmacro
61
62
63 -->macro_varg Test_prepare_and_execute_proc_arg2 %PROC_NAME% %OUT_PARAM1% %OUT_PARAM2%
64 quiet;
65 noquery_result;
66 echo [Prepare and execute %PROC_NAME%];
67 PREPARE stmt FROM 'CALL xtest.%PROC_NAME%';
68 stmtsql EXECUTE stmt USING %OUT_PARAM1%, %OUT_PARAM2%;
69 noquiet;
70 query_result;
71 %VAR_ARGS%
72 -->recvresult
73 quiet;
74 noquery_result;
75 DEALLOCATE PREPARE stmt;
76 noquiet;
77 query_result;
78 -->endmacro