Shell Programming and Scripting

n=`grep -c $proc_name1 file`
n=$(($n - 1))

awk 'toupper($1)=="DELIMITER" && f{f=0;next} $3 ~ v && ++c==n{f=1}!f' n=$n v="$proc_name1" diff > diff_temp

mv diff_temp diff

SqlIn=${1:-./vivek.sql}
SqlWrk=${SqlIn}.wrk

awk -F'[[:space:](]+' '
    /CREATE[[:space:]]+PROCEDURE[[:space:]]+/ {
        Name = $3;
        if (! (Name in Names)) Procs[++ProcCount] = Name;
        Names[Name]++
    }
    Name {
        Def = Def $0 "\n";
    }
    tolower($1)=="delimiter" {
        ProcDef[Name] = Def;
        Name = Def = "";
        next;
    }
    END {
        for (i=1; i<=ProcCount; i++) printf "%s", ProcDef[Procs[i]];
    }
' ${SqlIn} > ${SqlWrk} && mv ${SqlWrk} ${SqlIn} || rm -f ${SqlWrk}

CREATE PROCEDURE after100DeleteTgr(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE after100DeleteTgr(id int)
BEGIN
        insert into DeleteEvent(entityName, entityId) values ('PersonalContactNote', id) ;
END
$$
Delimiter ;
CREATE PROCEDURE otherProc(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE after100DeleteTgr(id int)
BEGIN
        insert into DeleteEvent(entityName, entityId, entityFlag) values ('PersonalContactNote', id, 'confirmed') ;
END
$$
Delimiter ;

CREATE PROCEDURE after100DeleteTgr(id int)
BEGIN
        insert into DeleteEvent(entityName, entityId, entityFlag) values ('PersonalContactNote', id, 'confirmed') ;
END
$$
Delimiter ;
CREATE PROCEDURE otherProc(id int)
BEGIN
END
$$
Delimiter ;