#! /bin/sh
echo "Demo for database write access"
rm input.sql
touch input.sql
sleep 3
clear

# Entry

while true
do
echo -n "Text entry: ";read text
echo -n "Numeric entry: ";read number
echo -n "Save (s) End (e) ";read we
if [ "$we" = "s" ];
   then
   echo "Insert into demo values ('$text',$number);" >> input.sql
elif [ "$we" = "e" ];
   then
   # Write to database
   psql -d harald -f input.sql
   exit
fi
done