====
github.com/progorker =_============
_ __ _ _ ___ __ _ ___ _ _| |_____ _ _
| '_ \ '_/ _ \/ _` / _ \ '_| / / -_) '_|
| .__/_| \___/\__, \___/_| |_\_\___|_|
=|_|===========|___/======================
API References of myTestor
----- oOo -----
[procedure] api_testor_greater_than
==========================================
-------|__/-------------------------
SYNTAX
------------------------------------
procedure api_testor_greater_than (
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_operand double,
in p_value double
)
-------|__/-------------------------
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 |
+------------+-------------+
| 7 | 1 |
+------------+-------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 7; call api_testor_greater_than( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'greater.1', 3, 2.5 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 11 | 1 | 7 |
+------------+-------------+------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 7; call api_testor_greater_than( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'greater.2', 3, 3.5 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 12 | 1 | 7 |
+------------+-------------+------------+
----------------------------
$) call api_testor_finish( '8003c6c90940e847a8e01897b4a93e4d', 1 );
----------------------------
+-------------+-----------+--------------------------------------------------------------------+
| case | test | message |
+-------------+-----------+--------------------------------------------------------------------+
| table-users | greater.2 | [greater.2] test (greater_than) is failed.
Operand: 3
Value: 3.5
|
+-------------+-----------+--------------------------------------------------------------------+
1 row in set (0.27 sec)
+---------+--------+--------+----+---------------+--------------+------------+------------+
| version | status | code | id | success_count | failed_count | test_count | case_count |
+---------+--------+--------+----+---------------+--------------+------------+------------+
| 21 | 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 (greater_than) is success.
Operand: 3
Value: 2.5
|
+-------------+-----------+---------------------------------------------------------------------+
----------------------------