====
github.com/progorker =_============
_ __ _ _ ___ __ _ ___ _ _| |_____ _ _
| '_ \ '_/ _ \/ _` / _ \ '_| / / -_) '_|
| .__/_| \___/\__, \___/_| |_\_\___|_|
=|_|===========|___/======================
API References of myTestor
----- oOo -----
[procedure] api_testor_finish
==========================================
-------|__/-------------------------
SYNTAX
------------------------------------
procedure api_testor_finish (
in p_token varchar(36),
in p_suite_id bigint
)
-------|__/-------------------------
USAGE
------------------------------------
$) set @v_token = '_'; call api_testor_login( @v_token, 'mytestor', 'rzutomqahegpnyx' ); select @v_token;
----------------------------
+----------------------------------+
| @v_token |
+----------------------------------+
| a0f2733d08f13423f076732170be6b92 |
+----------------------------------+
----------------------------
$) set @v_case_id = -1; set @v_suite_id = -1; call api_testor_suite_case( 'a0f2733d08f13423f076732170be6b92', @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_test( 'a0f2733d08f13423f076732170be6b92', @v_test_id, @v_suite_id, @v_case_id, 'greater.1', 2 > 1, '[greater_than] comparation is success' ); 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_test( 'a0f2733d08f13423f076732170be6b92', @v_test_id, @v_suite_id, @v_case_id, 'greater.2', 2 <= 1, '[greater_than] comparation is failed' ); 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( 'a0f2733d08f13423f076732170be6b92', 1 );
----------------------------
+-------------+-----------+--------------------------------------+
| case | test | message |
+-------------+-----------+--------------------------------------+
| table-users | greater.2 | [greater_than] comparation is failed |
+-------------+-----------+--------------------------------------+
1 row in set (0.34 sec)
+---------+--------+--------+----+---------------+--------------+------------+------------+
| version | status | code | id | success_count | failed_count | test_count | case_count |
+---------+--------+--------+----+---------------+--------------+------------+------------+
| 1 | RED | sterry | 1 | 1 | 1 | 2 | 1 |
+---------+--------+--------+----+---------------+--------------+------------+------------+
1 row in set (0.35 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.35 sec)
----------------------------