====
github.com/progorker =_============
_ __ _ _ ___ __ _ ___ _ _| |_____ _ _
| '_ \ '_/ _ \/ _` / _ \ '_| / / -_) '_|
| .__/_| \___/\__, \___/_| |_\_\___|_|
=|_|===========|___/======================
API References of myTestorProxy
----- oOo -----
[procedure] api_testor_equals
==========================================
-------|__/-------------------------
SYNTAX
------------------------------------
procedure mytestorproxy.api_testor_equals (
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 mytestorproxy.api_testor_login( @v_token, 'mytestor', 'rzutomqahegpnyx' ); select @v_token;
----------------------------
+----------------------------------+
| @v_token |
+----------------------------------+
| 8003c6c90940e847a8e01897b4a93e4d |
+----------------------------------+
----------------------------
$) call mytestorproxy.api_testor_clean( '8003c6c90940e847a8e01897b4a93e4d', 1 );
$) set @v_case_id = -1; set @v_suite_id = -1; call mytestorproxy.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 |
+------------+-------------+
| 5 | 1 |
+------------+-------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 5; call mytestorproxy.api_testor_equals( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'equals.1', 2.5, 2.5 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 7 | 1 | 5 |
+------------+-------------+------------+
----------------------------
$) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 5; call mytestorproxy.api_testor_equals( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'equals.2', 2.5, 3.5 ); select @v_test_id, @v_suite_id, @v_case_id;
----------------------------
+------------+-------------+------------+
| @v_test_id | @v_suite_id | @v_case_id |
+------------+-------------+------------+
| 8 | 1 | 5 |
+------------+-------------+------------+
----------------------------
$) call mytestorproxy.api_testor_finish( '8003c6c90940e847a8e01897b4a93e4d', 1 );
----------------------------
+-------------+----------+---------------------------------------------------------------+
| case | test | message |
+-------------+----------+---------------------------------------------------------------+
| table-users | equals.2 | [equals.2] test (equals) is failed.
Operand: 2.5
Value: 3.5
|
+-------------+----------+---------------------------------------------------------------+
1 row in set (0.25 sec)
+---------+--------+--------+----+---------------+--------------+------------+------------+
| version | status | code | id | success_count | failed_count | test_count | case_count |
+---------+--------+--------+----+---------------+--------------+------------+------------+
| 19 | RED | sterry | 1 | 1 | 1 | 2 | 1 |
+---------+--------+--------+----+---------------+--------------+------------+------------+
1 row in set (0.25 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.25 sec)
----------------------------
$) call mytestorproxy.api_testor_success( '8003c6c90940e847a8e01897b4a93e4d', 1 );
----------------------------
+-------------+----------+----------------------------------------------------------------+
| case | test | message |
+-------------+----------+----------------------------------------------------------------+
| table-users | equals.1 | [equals.1] test (equals) is success.
Operand: 2.5
Value: 2.5
|
+-------------+----------+----------------------------------------------------------------+
----------------------------