Stored procedure with error handling live template for Intellij Datagrip

stored_procedure_live_template

use $database$

DELIMITER $$
drop procedure if exists $procedureName$ $$
create procedure $procedureName$()
begin
  declare exit handler for sqlexception
    begin
      get diagnostics condition 1 @sqlstate = returned_sqlstate , @errno = mysql_errno , @text = message_text ;
      set @full_error = concat('ERROR ', @errno, @`sqlstate`, @text);
      select @full_error;
    end;

  start transaction ;
    $END$
    
    select concat('yay') as success;
  commit;
end$$

/* Finally, reset the delimiter to the default ; */
DELIMITER ;

call $procedureName$();