CakePHP 3 MySQL – funkcje składowane

Utworzenie funkcji składowanej w MySQL

DELIMITER $$
CREATE FUNCTION getLastId(p_project_id INT)
RETURNS INT
BEGIN
    RETURN ( SELECT id  FROM events
      WHERE project_id = p_project_id
      AND start_date < CURRENT_DATE
      AND report IS NOT NULL 
      AND report <> ''
      ORDER BY start_date DESC
      LIMIT 1 );
END $$
DELIMITER ;

Druga funkcja

DELIMITER $$
CREATE FUNCTION getNextId(p_project_id INT)
RETURNS INT
BEGIN
    RETURN (SELECT id  FROM events
    WHERE project_id = p_project_id
    AND start_date > CURRENT_DATE
    ORDER BY start_date ASC
    LIMIT 1);
END $$
DELIMITER ;

# SHOW FUNCTION STATUS WHERE Db='myDababaseName' \G