Shell Programming and Scripting

create table emp
( empno integer,
empname char(50))
primary index(empno);

rename table emp to emp_rename;

insert into emp sel * from emp_rename;
drop table emp_rename;

rename table emp to emp_rename;
create table emp
( empno integer,
empname char(50))
primary index(empno);
insert into emp sel * from emp_rename;
drop table emp_rename;

awk '/^create/;$/ ddlfile.txt

awk '
/create table/ {tn=$NF; print "rename table " tn " to " tn "_rename;"}
1
END {
   if (tn) {
      print "insert into " tn " sel * from " tn "_rename;"
      print "drop table " tn "_rename;"
   }
}
' infile

$ cat 1.sql
-- sample header
create table emp
( empno integer,
empname char(50))
primary index(empno);
insert into emp values (1,'Stones');--sample insertion
-- sample comment

$ ./sqlmode.sh 1.sql
-- sample header
rename table emp to emp_rename;
 create table emp ( empno integer, empname char(50)) primary index(empno);
insert into emp sel * from emp_rename;
drop table emp_rename;
insert into emp values (1,'Stones');--sample insertion
-- sample comment

$ cat sqlmode.sh
# process sql files
awk '/create table emp/,/primary index/{
query = query " " $0
next
}
query > "" {
print "rename table emp to emp_rename;"
print query
print "insert into emp sel * from emp_rename;"
print "drop table emp_rename;"
query = ""
}
1' $1
#