database Analises

DATA RETRIEVED USING THE ABOVE BASH ON LINUX<br>#!/bin/bash# Data Slam Script v0.1# User define Function (UDF)LogLine(){ echo -E "`date +%s`,${line}" sqlite3 arduino.db3 "insert into arduino_data(time_stamp,wind,bending,growing) values (`date +%s`,${line})"}### Main script stars here #### Store file nameFILE=""<br># Make sure we get file name as command line argument# Else read it from standard input devicestty -F /dev/ttyUSB0 cs8 9600 ignbrk -brkint -icrnl -imaxbel -opost -onlcr -isig -icanon -iexten -echo -echoe -echok -echoctl -echoke noflsh -ixon -crtsctsif [ "$1" == "" ]; then FILE="/dev/ttyACM0"else FILE="$1" # make sure file (serial device) exist and is readable if [ ! -f $FILE ]; then echo "$FILE : does not exists" exit 1 elif [ ! -r $FILE ]; then echo "$FILE: can not read" exit 2 fifi# Create Database if it does not exist<br>if [ ! -f "arduino.db3" ]; then echo "Creating database" sqlite3 arduino.db3 "CREATE TABLE arduino_data (time_stamp integer, wind integer ,bending integer, growing integer);"fiexec 3exec 0while truedo<br> # use $line variable to process line in processLine() function while read -r line do LogLine $line done sleep 1 # This delay can be changed to match the delay of the Arduinodoneexec 0exit 0