Shell Programming and Scripting

cat 11.sql
drop procedure if exists hoop1 ;
Delimiter $$
CREATE PROCEDURE hoop1(id int)
BEGIN
END
$$
Delimiter ;
.
.
.
.
drop procedure if exists hoop2;
Delimiter $$
CREATE PROCEDURE hoop2(id int)
BEGIN
END
$$
delimiter ;
.
.
DROP VIEW IF EXISTS view1;
 CREATE VIEW view1
 AS
 SELECT blah blah  FROM blah etc etc
 WHERE blah blah
 GROUP BY  id;
.
.
.
DROP VIEW IF EXISTS view2;
 CREATE VIEW view2
 AS
 SELECT blah blah  FROM blah etc etc
 WHERE blah blah
 GROUP BY  id;
.
.
.
drop procedure if exists hoop3;
Delimiter $$
CREATE PROCEDURE hoop2(id int)
BEGIN
END
$$
Delimiter ;

perl -lne '(/^\s*CREATE\s+PROCEDURE/i .. /^\s*\)\s+Delimiter/i) && print;' "11.sql" > onlyproc1.sql
 
perl -lne '(/^\s*CREATE\s+VIEW/i .. /^\s*\)\s+;/i) && print;' "11.sql" > onlyviews1.sql

$ nawk '/CREATE PROCEDURE/,/[dD]elimiter/' infile > create_procedure_outfile

$ nawk '/CREATE VIEW /,/;/' infile > create_view_outfile

echo "`sed -n "/$firstword/,/;/ w viewextract.sql" < onlyviews1.sql`"

 echo "`sed -n "/$firstword/,/[dD]elimiter/ w extractproc.sql" < onlyproc1.sql`"

cat onlyproc1.sql
CREATE PROCEDURE ABC(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE xyz(id int)
BEGIN
END
$$
Delimiter ;
CREATE PROCEDURE ABC(id int)
BEGIN
END
.
.
.etc

firstword="CREATE PROCEDURE ABC"
echo "`sed -n "/$firstword/,/[dD]elimiter/ w extractproc.sql" < onlyproc1.sql`"