#!/bin/sh
# 
# mysql_tc335_insert.sh table tv_sec cdat sdat setpt heater range 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.
#    $p         - P in PID.
#    $i         - I in PID.
#    $d         - D in PID.
#    $id_prefix - Prefix for SensorID, ie, bd, gd, or spex
#
#  examples:
#      mysql_tc335_insert.sh Data 1241126275 30.0 72.0 30.0 25.0 2 500 200 100 bd
#
#      csh> mysql_tc335_insert.sh Data `date +%s` 30.0 72.0 30.0 25.0  2 500 200 100 bd

if [ $# -ne 11 ]
then
   echo " usage: $0 table tv_sec cdat sdat setpt heater range 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
p=$8
i=$9
d=${10}
id1=${11}"_cdat"
id2=${11}"_sdat"
id3=${11}"_setpt"
id4=${11}"_heater"
id5=${11}"_range"
id7=${11}"_p"
id8=${11}"_i"
id9=${11}"_d"

#
mysql --host=irtfweb.ifa.hawaii.edu --user=spex --password='XXXXX' -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( '$id7', $tv_sec, $p );
INSERT INTO $table VALUES( '$id8', $tv_sec, $i );
INSERT INTO $table VALUES( '$id9', $tv_sec, $d );
\q
STOP