#!/bin/sh

for FILE in /data/backup/tmp/*.sql
do 
    VALUES=`grep opl_preference $FILE | grep defaultSearchPage | sed -re "s/^.+defaultSearchPage/\('defaultSearchPage/" -e 's/\),\(.+$/\)/'`
    VAR=`echo $VALUES | cut -d\' -f2`
    VALUE=`echo $VALUES | cut -d\' -f4`
    echo use `basename $FILE .sql`\; update opl_preference set val=\'$VALUE\' where var=\'$VAR\'\;
done

exit 0