DELIMITER $$
CREATE PROCEDURE `IMPORT_GOODS`(IN `P_ID_GOODS` BIGINT, IN `P_NAME` VARCHAR(256), IN `P_ID_PRODUCER` BIGINT, OUT `P_RES` INT)

BEGIN  
	DECLARE P_ROW_EXISTS INT;
				
	DECLARE EXIT HANDLER FOR SQLEXCEPTION SET P_RES = 0;
	DECLARE EXIT HANDLER FOR SQLSTATE '02000' SET P_RES = 0;
	DECLARE EXIT HANDLER FOR SQLSTATE '23000' SET P_RES = 0;
	DECLARE EXIT HANDLER FOR 1452 SET P_RES = 0;  

	SET P_ROW_EXISTS = (SELECT COUNT(*) FROM goods WHERE 1 = 1 AND id_goods = P_ID_GOODS);
   	
	IF P_ROW_EXISTS = 1 THEN
		BEGIN 
            UPDATE goods
			SET name = P_NAME,
				id_producer = P_ID_PRODUCER,
			WHERE 
				id_goods = P_ID_GOODS;
            SET P_RES = 1;    
		END;
	
	ELSE
		BEGIN 
			INSERT INTO goods (id_goods, name, id_producer)
			VALUES (
				P_ID_GOODS,
				P_NAME,
				P_ID_PRODUCER);
			SET P_RES = 2; 
		END;
	END IF;
END$$

DELIMITER ;

 #1452 - Cannot add or update a child row: a foreign key constraint fails (`goods`, CONSTRAINT `goods_producer_r_1` FOREIGN KEY (`id_producer`) REFERENCES `producer` (`id_producer`)).