Hur jag löste inmatning till mysql

[gflygt]

Om nån kan ha glädje av mitt lilla script så kommer här ett försök. Det har ingen felhantering ännu, men det får jag fixa sen

Kod: Markera allt

#!/bin/bash
# collect.sh Script to collect data from 1-wire sensors
# Created 29 July 2009 by Gunnar Flygt
# The sensors have soft links in the working directory
#

mysql="/usr/bin/mysql -uXXXX -pXXXX weathersensors"
GREP="/bin/grep"
TR="/usr/bin/tr"

cd /home/gunnar/weatherdata

nr="1"

# This is the collector procedure
while [ $nr -le 4 ];
do
  # Get the sensor ID for storing in database
  sensid=`ls -l sensor$nr | awk '{ print $11 }' \
	| awk 'BEGIN { FS = "/" } ; { print $5 }'`

  # Get the temperature value strip whitespace
  temp=`$GREP . sensor$nr | $TR -d [:space:]`

  # define INSERT statement
  insert="INSERT INTO measures VALUES('${sensid}',${temp},CURRENT_TIMESTAMP)"

  # pollute database
  `echo ${insert} | ${mysql}`

  nr=$(( $nr + 1 ))
done