USE fetchmetrics;

DROP PROCEDURE IF EXISTS fetchmetrics.p_dog_clear_calc_assessment;
DROP PROCEDURE IF EXISTS fetchmetrics.p_assessment_clear_calc_assessment;

DELIMITER //
CREATE PROCEDURE fetchmetrics.p_dog_clear_calc_assessment (
	  IN a_guid BINARY(36)
    , IN a_debug BIT
)
BEGIN
	DECLARE v_time_start TIMESTAMP(6);
    SET v_time_start := CURRENT_TIMESTAMP(6);
    
    CALL fetchmetrics.p_core_validate_guid ( a_guid );
    
	START TRANSACTION;
		
		DELETE ASSESSMENTS_T
        FROM fetchmetrics.DOG_Assessment_Temp ASSESSMENTS_T
		WHERE ASSESSMENTS_T.GUID = a_guid
		;
		
	COMMIT;
    
    IF a_debug = 1 THEN
		CALL fetchmetrics.p_debug_timing_reporting( v_time_start );
    END IF;
END //
DELIMITER ;

/*

CALL fetchmetrics.p_dog_clear_calc_assessment (
	'crips                               ' -- a_guid
    , 1 -- debug
);

SELECT *
FROM fetchmetrics.DOG_Calc_User_Access_Temp
WHERE GUID = 'chips                               '
;

*/