O
==== github.com/progorker =_============ _ __ _ _ ___ __ _ ___ _ _| |_____ _ _ | '_ \ '_/ _ \/ _` / _ \ '_| / / -_) '_| | .__/_| \___/\__, \___/_| |_\_\___|_| =|_|===========|___/====================== API References of myTestorProxy ----- oOo ----- [procedure] api_testor_not_same ========================================== -------|__/------------------------- SYNTAX ------------------------------------ procedure mytestorproxy.api_testor_not_same ( 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 varchar(8192), in p_value varchar(8192) ) -------|__/------------------------- 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 | +------------+-------------+ | 12 | 1 | +------------+-------------+ ---------------------------- $) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 12; call mytestorproxy.api_testor_not_same( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'same.1', 'Hello world!', 'Hello world!' ); select @v_test_id, @v_suite_id, @v_case_id; ---------------------------- +------------+-------------+------------+ | @v_test_id | @v_suite_id | @v_case_id | +------------+-------------+------------+ | 21 | 1 | 12 | +------------+-------------+------------+ ---------------------------- $) set @v_test_id = -1; set @v_suite_id = 1; set @v_case_id = 12; call mytestorproxy.api_testor_not_same( '8003c6c90940e847a8e01897b4a93e4d', @v_test_id, @v_suite_id, @v_case_id, 'same.2', 'Hello world!', 'Hello worldABC!' ); select @v_test_id, @v_suite_id, @v_case_id; ---------------------------- +------------+-------------+------------+ | @v_test_id | @v_suite_id | @v_case_id | +------------+-------------+------------+ | 22 | 1 | 12 | +------------+-------------+------------+ ---------------------------- $) call mytestorproxy.api_testor_finish( '8003c6c90940e847a8e01897b4a93e4d', 1 ); ---------------------------- +-------------+--------+---------------------------------------------------------------------------------+ | case | test | message | +-------------+--------+---------------------------------------------------------------------------------+ | table-users | same.1 | [same.1] test (not_same) is failed. Operand: Hello world! Value: Hello world! | +-------------+--------+---------------------------------------------------------------------------------+ 1 row in set (0.33 sec) +---------+--------+--------+----+---------------+--------------+------------+------------+ | version | status | code | id | success_count | failed_count | test_count | case_count | +---------+--------+--------+----+---------------+--------------+------------+------------+ | 26 | RED | sterry | 1 | 1 | 1 | 2 | 1 | +---------+--------+--------+----+---------------+--------------+------------+------------+ 1 row in set (0.33 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.33 sec) ---------------------------- $) call mytestorproxy.api_testor_success( '8003c6c90940e847a8e01897b4a93e4d', 1 ); ---------------------------- +-------------+--------+-------------------------------------------------------------------------------------+ | case | test | message | +-------------+--------+-------------------------------------------------------------------------------------+ | table-users | same.2 | [same.2] test (not_same) is success. Operand: Hello world! Value: Hello worldABC! | +-------------+--------+-------------------------------------------------------------------------------------+ ----------------------------