====
github.com/progorker =_============
_ __ _ _ ___ __ _ ___ _ _| |_____ _ _
| '_ \ '_/ _ \/ _` / _ \ '_| / / -_) '_|
| .__/_| \___/\__, \___/_| |_\_\___|_|
=|_|===========|___/======================
API References of myTestor
----- oOo -----
[procedure] api_testor_true
==========================================
-------|__/-------------------------
SYNTAX
------------------------------------
procedure api_testor_true (
in p_token varchar(36),
out p_id bigint,
in p_suite_id bigint,
in p_case_id bigint,
in p_code varchar(640),
in p_condition int
)
-------|__/-------------------------
USAGE
------------------------------------
$) set @v_token = '_'; call api_testor_login( @v_token, 'mytestor', 'rzutomqahegpnyx' ); select @v_token;
----------------------------
+----------------------------------+
| @v_token |
+----------------------------------+
| 8003c6c90940e847a8e01897b4a93e4d |
+----------------------------------+
----------------------------
$) call api_testor_clean( '8003c6c90940e847a8e01897b4a93e4d', 1 );
$) set @v_case_id = -1; set @v_suite_id = -1; call api_testor_suite_case( '8003c6c90940e847a8e01897b4a93e4d', @v_suite_id, @v_case_id, 'sterry', 'table-users' ); select @v_case_id, @v_suite_id;
----------------------------
+------------+-------------+
| @v_case_id | @v_suite_id |
+------------+-------------+
| 2 | 1 |
+------------+-------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 2; call api_testor_true( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'greater.1', 2 > 1 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 2 | 1 | 2 |
+------------+-------------+------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 2; call api_testor_true( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'greater.2', 2 <= 1 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 3 | 1 | 2 |
+------------+-------------+------------+
----------------------------
$) call api_testor_finish( '8003c6c90940e847a8e01897b4a93e4d', 1 );
----------------------------
+-------------+-----------+------------------------------------------------------------------+
| case | test | message |
+-------------+-----------+------------------------------------------------------------------+
| table-users | greater.2 | [greater.2] test (true) is failed.
Condition: 0
Expected: true
|
+-------------+-----------+------------------------------------------------------------------+
1 row in set (0.27 sec)
+---------+--------+--------+----+---------------+--------------+------------+------------+
| version | status | code | id | success_count | failed_count | test_count | case_count |
+---------+--------+--------+----+---------------+--------------+------------+------------+
| 16 | RED | sterry | 1 | 1 | 1 | 2 | 1 |
+---------+--------+--------+----+---------------+--------------+------------+------------+
1 row in set (0.27 sec)
+------------------------------------------+-----------------------------------------------+
| To re-print: | To get source file of [a] test case: |
+------------------------------------------+-----------------------------------------------+
| $) call api_testor_result('_token_', 1); | $) call api_testor_source('_token_', 1, 'a'); |
+------------------------------------------+-----------------------------------------------+
1 row in set (0.27 sec)
----------------------------
$) call api_testor_success( '8003c6c90940e847a8e01897b4a93e4d', 1 );
----------------------------
+-------------+-----------+-------------------------------------------------------------------+
| case | test | message |
+-------------+-----------+-------------------------------------------------------------------+
| table-users | greater.1 | [greater.1] test (true) is success.
Condition: 1
Expected: true
|
+-------------+-----------+-------------------------------------------------------------------+
----------------------------