#!/bin/sh
# 
# mysql_tc330_insert.sh table tv_sec cchn schn cdat sdat setpt range tune p i d id_prefix
#
#  Insert a new reccord into $table
#    $table     - the table to use, ie Data
#    $tv_sec    - time in unix seconds.
#    $cdat      - temperature of the control channel, kelvin.
#    $sdat      - temperature of the sample  channel, kelvin.
#    $setpt     - setpoint temperature, kelvin.
#    $heater    - heater output, percent, 0-100.
#    $range     - 0, 1, 2, 3 is off, low, med, high.
#    $tune      - auto tine status: 0=manual 1=P 2=PI 3=PID
#    $p         - P in PID.
#    $i         - I in PID.
#    $d         - D in PID.
#    $id_prefix - Prefix for SensorID, ie, bd, gd, or spex
#
#  examples:
#      mysql_tc330_insert.sh Data 1241126275 30.0 72.0 30.0 25.0 2 3 500 200 100 bd
#
#      csh> mysql_tc330_insert.sh Data `date +%s` 30.0 72.0 30.0 25.0  2 3 500 200 100 bd

if [ $# -ne 12 ]
then
   echo " usage: $0 table tv_sec cdat sdat setpt heater range tune p i d bd"
	exit 1
fi
# 
narg=$#
dbname=spex
table=$1
tv_sec=$2
cdat=$3
sdat=$4
setpt=$5
heater=$6
range=$7
tune=$8
p=$9
i=${10}
d=${11}
id1=${12}"_cdat"
id2=${12}"_sdat"
id3=${12}"_setpt"
id4=${12}"_heater"
id5=${12}"_range"
id6=${12}"_tune"
id7=${12}"_p"
id8=${12}"_i"
id9=${12}"_d"

#echo "USE $dbname;"
#echo "INSERT INTO $table VALUES( '$dog"_cdat"', $tv_sec, $cdat );"
#echo "INSERT INTO $table VALUES( '$dog"_sdat"', $tv_sec, $sdat );"
#echo "INSERT INTO $table VALUES( '$dog"_setpt"', $tv_sec, $setpt );"
#echo "INSERT INTO $table VALUES( '$dog"_heater"', $tv_sec, $heater );"
#echo "INSERT INTO $table VALUES( '$dog"_range"', $tv_sec, $range );"
#echo "INSERT INTO $table VALUES( '$dog"_tune"', $tv_sec, $tune);"
#echo "INSERT INTO $table VALUES( '$dog"_p"', $tv_sec, $p );"
#echo "INSERT INTO $table VALUES( '$dog"_i"', $tv_sec, $i );"
#echo "INSERT INTO $table VALUES( '$dog"_d"', $tv_sec, $d );"
#exit
#
mysql --host=irtfweb.ifa.hawaii.edu --user=spex --password='XXXX' -t <<STOP
USE $dbname;

INSERT INTO $table VALUES( '$id1', $tv_sec, $cdat );
INSERT INTO $table VALUES( '$id2', $tv_sec, $sdat );
INSERT INTO $table VALUES( '$id3', $tv_sec, $setpt );
INSERT INTO $table VALUES( '$id4', $tv_sec, $heater );
INSERT INTO $table VALUES( '$id5', $tv_sec, $range );
INSERT INTO $table VALUES( '$id6', $tv_sec, $tune);
INSERT INTO $table VALUES( '$id7', $tv_sec, $p );
INSERT INTO $table VALUES( '$id8', $tv_sec, $i );
INSERT INTO $table VALUES( '$id9', $tv_sec, $d );
\q
STOP