|
|
awk field separator or print command
04-10-2009
####################################################################
##
## Author : Built with help from Unix.com Forums
## Date : March 20, 2009
## Description : Takes a filename as input and extracts all the SQL queries present.
##
####################################################################
#!/bin/sh
# Check for filename
if [ ! $# = 1 ]; then
echo "USAGE:"
echo "./getSQL <file_name>\nOR\nsh getSQL <file_name>"
echo "The <file_name> must be fully qualified, absolutely or relatively,\nwith the location of the file if not in the same folder as shell"
exit 0
fi
srcFile=$1
# Check if file exists and has some content
if [ ! -s ${srcFile} ]; then
echo "The file \"${srcFile}\" does not exist or is empty."
exit 0
fi
# Parse Filename to remove extension
# Choose a fileName type
#destFile=${srcFile%\.*} # Does not append file extension to name
destFile=`echo ${srcFile} | sed 's/\.//g'` # Appends file extension to name
destFile="${destFile}_sql.txt"
# File has been specified and has content, begin search
# We are assuming that every SQL query is preceded by "SQL_SUCCESS(0)".
# Search each line with SQL_SUCCESS(0) and get evrything after the first ")".
#result=`grep "SQL_SUCCESS(0)" ${srcFile} | cut -d ')' -f2- | sed -n -e 's/^\ *//g' -e '/^[^0-9]/p'`
grep "SQL_SUCCESS(0)" ${srcFile} | cut -d ')' -f2- | sed -n -e 's/^\ *//g' -e '/^[^0-9]/p' > "${destFile}"
# Check length of result, give message and exit if 0, else save to file
#if [ ${#result} = 0 ]; then
# echo "No SQL queries found."
# exit 0
#else
# echo ${result} > "${destFile}_sql.txt"#
#fi
# Get queries
# Insert a linefeed after every line for clarity
sed '/\.*/G' ${destFile} > hTmp.txt
# Move output to required file
mv hTmp.txt ${destFile}
echo "Saved to ${destFile}"
######################################################################
## End of GET SQL Script
######################################################################
.|
|