js2sql

#!/bin/bash

. config

VER="strings_$VERSION"
cd root_$VERSION

echo "begin;" > ../jsstrings_$VERSION.sql.temp

while read orig
do
    if [[ "$orig" =~  mesquite|pillow ]]
    then
	echo $orig
	find $orig -name '*.js' | xargs -if awk -v name=f 'BEGIN {FS="^[^\"'"'"']*[\"'"'"']|[\"'"'"'][^\"'"'"']*$"} $2 != "" {print name "\t" $2}' f | sort -u  | \
        sed "s/'/''/g;s|\\\\|\\\\\\\\|g" | \
	(
    	    printf -v IFS "\t"
	    while read file src
    	    do
        	export src
            echo "INSERT INTO trans VALUES('$src','','$file','$VER');" >> ../jsstrings_$VERSION.sql.temp
                    echo "             === insert into trans values ('$src','', '$file', '$VER');" >&2
    	    done
	)
    fi
done < <(find . -type d -path '*/locales/en-GB')
echo "commit;" >> ../jsstrings_$VERSION.sql.temp
native2ascii -reverse ../jsstrings_$VERSION.sql.temp ../jsstrings_$VERSION.sql
rm -f ../jsstrings_$VERSION.sql.temp