jasonm23/Todays bash one liner.sh

## Todays bash one liner.sh
grep '<eventImage' config_en.xml | sed  -e 's/[^\=]*\="\([0-9]*\)" value\="\([^.]*\)\.png"\/>/\1 \2/' | cat -n | wra b c; do echo "INSERT INTO event_type_numbers VALUES($a, '$b', '$(ds)', '$(ds)', 1, $(grep $c types.txt | sed 's/\([0-9]*\).*/\1/'));"; done

# find <eventImage nodes and grab their name value pairs, add line numbers, while read and split into a, b, c, (alias wra) then create a sql insert, $(ds) is a datestamp alias, then define the last column by searching for the image name in a list called types, and insert the associated ID num. and done.
	grep '<eventImage' config_en.xml \| sed -e 's/[^\=]\="\([0-9]\)" value\="\([^.]\)\.png"\/>/\1 \2/' \| cat -n \| wra b c; do echo "INSERT INTO event_type_numbers VALUES($a, '$b', '$(ds)', '$(ds)', 1, $(grep $c types.txt \| sed 's/\([0-9]\).*/\1/'));"; done

	# find <eventImage nodes and grab their name value pairs, add line numbers, while read and split into a, b, c, (alias wra) then create a sql insert, $(ds) is a datestamp alias, then define the last column by searching for the image name in a list called types, and insert the associated ID num. and done.