Skip to content

Latest commit

 

History

History
123 lines (92 loc) · 2.54 KB

devLog_README.md

File metadata and controls

123 lines (92 loc) · 2.54 KB
Raw

devLog/devReset

###Description Below two procedures/functions are useful in data debuging.

Collecting data is based on concating all informations you need with separator.

##Specification

PROCEDURE devLog(concat_data TEXT)

FUNCTION `devLog`(concat_data TEXT) -- only adapter for procedure devLog
RETURNS TEXT -- RETURN concat_data;

PROCEDURE `devReset`()

FUNCTION `devReset`() -- only adapter for procedure devReset
RETURNS TEXT -- RETURN '';

##Example usage:

#####Usage in queries, subqueries

SELECT devReset();

CALL devLog('start debug1');

SELECT 
	T.id,T.column_1 
FROM (
	SELECT 
		id,column_1,devLog(CONCAT_WS(' | ',id,column_1,id*column_1)) AS debug 
	FROM 
		simple_table 
	WHERE 
		`id` BETWEEN 100 AND 105
) AS T;

SELECT * FROM devLog;

###Result

"id" "concat_data" "date"
"1" "start debug1" "2015-06-19 08:40:20"
"2" "100 | 647075 | 64707500" "2015-06-19 08:40:29"
"3" "101 | 1141814 | 115323214" "2015-06-19 08:40:29"
"4" "102 | 1141832 | 116466864" "2015-06-19 08:40:29"
"5" "103 | 1142609 | 117688727" "2015-06-19 08:40:29"
"6" "104 | 1141848 | 118752192" "2015-06-19 08:40:29"
"7" "105 | 1142755 | 119989275" "2015-06-19 08:40:29"

#####Usage in procedures

SELECT devReset();
CALL devLog('start debug2');

DELIMITER $$
CREATE PROCEDURE sample_proc()
BEGIN
	DECLARE _i INT;
  SET _i = 0;

  WHILE _i <  5 DO   
	CALL devLog(CONCAT_WS(' | ',_i,POW(_i,2)));
	SET _i = _i + 1;    
  END WHILE;

END$$
DELIMITER ;

CALL sample_proc();

DROP PROCEDURE sample_proc;

SELECT * FROM devLog;
"id" "concat_data" "date"
"1" "start debug2" "2015-06-19 06:54:44"
"2" "0 | 0" "2015-06-19 06:54:49"
"3" "1 | 1" "2015-06-19 06:54:49"
"4" "2 | 4" "2015-06-19 06:54:49"
"5" "3 | 9" "2015-06-19 06:54:49"
"6" "4 | 16" "2015-06-19 06:54:49"

#####Using in functions

SELECT devReset();
CALL devLog('start debug3');

DELIMITER $$

CREATE
    FUNCTION `sample_func`(input VARCHAR(20))
    RETURNS VARCHAR(20)
    DETERMINISTIC
    BEGIN
	DECLARE _output VARCHAR(32);
	SET _output := MD5(input);
	CALL devLog(CONCAT_WS(' | ','input: ',input,'_output: ',_output));
	RETURN _output;	
    END$$
DELIMITER ;

SELECT sample_func('example');

DROP FUNCTION sample_func;

SELECT * FROM devLog;
"id" "concat_data" "date"
"1" "input: | example | _output: | 1a79a4d60de6718e8e5b326e338ae533" "2015-06-19 07:17:56"

Further usage depends on Your creativity...