PiPlanter | Second round of data collection

May 25, 2013 / 9 Comments

So as I said in one of my previous posts, I am going to be collecting a lot of data over the next few weeks while the tomato plants grow. I will be doing this to determine when soil is “dry” and how temperature and light effect that process. For the last week I have been collecting data in the configuration seen in my last post and here is the graph it produced you can click to see the full image:

This graph proves a few things. The first thing is that the relative moisture sensor works. As one can intuitively understand, if you don’t add more water into the system, nature will remove water via evaporation. The overall trend of the blue line (the rel mst sensor) is downward, backing up this point.

The problem with this setup was that I was spitting the voltage across the two probes constantly, which along with the water caused the nails to rapidly oxidize, which is something I would like to avoid in the long term. This also may have seriously corrupted the data so besides general trends, this whole set is unusable.

This isn’t necessarily a bad thing though, as I wanted to conduct a second trial with more probes and more dirt.

I decided to go with 4 probes, and here are a few pictures of the assembly process. Assembly process is the same, I just did it at my school:

I cut it into 3cm sections and then drilled holes on the midpoints of the 2nd and 3rd cm as seen in a photo below.

Here are the holes drilled for the nails

Here are the nails inserted into all 4

Here is the wire wrapped around the nail

Once solder is applied, the connection is very strong and conductive

Here’s the gluing process

Here are all of the sensors assembled. I attached headers to the other ends as seen in the last post.

Since i’m using 4 sensors now, and to get around the oxidation problem, I added a NPN transistor to cut the ground current when the sensor isn’t being used so it only turns on when it’s getting polled. Here is the new python code:

#Timing setup
from datetime import datetime
from apscheduler.scheduler import Scheduler
import time
import datetime
import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines
logging.basicConfig()

#GPIO setup
import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc
GPIO.setup(pin, GPIO.OUT)

NPNtrans = 3 #the pin for the npn transistor
GPIO.setup(NPNtrans, GPIO.OUT)

sampleLED = 5 #the indicator LED
GPIO.setup(sampleLED, GPIO.OUT)

#the adc's SPI setup
import spidev
spi = spidev.SpiDev()
spi.open(0, 0)

import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()

#fuction that can read the adc
def readadc(adcnum):
# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)
    if adcnum > 7 or adcnum < 0:
        return -1
    r = spi.xfer2([1, 8 + adcnum << 4, 0])
    adcout = ((r[1] & 3) << 8) + r[2]
    return adcout

def slowSample():

	GPIO.output(NPNtrans, True)
	GPIO.output(sampleLED, True)

	sampleTime =time.ctime()

	mst1 = readadc(0)
	mst2 = readadc(1)
	mst3 = readadc(2)
	mst4 = readadc(3)

	pot1 = readadc(4)

	ldr1 = readadc(5)

	millivolts = readadc(6)*(3300.0/1024.0)
	temp_c = ((millivolts - 100.0)/10)-40.0
	tmp1 = (temp_c * 9.0 / 5.0) + 32

	print sampleTime,"|","MST1:",mst1,"MST2:",mst2,"MST3:",mst3,"MST4:",mst4,"Pot1:",pot1,"LDR1:",ldr1,"TMP1:",tmp1 #prints the debug info

	cursor.execute("INSERT INTO piplanter_table_13(Time,mst1_V,mst2_V,mst3_V,mst4_V,pot1_V,ldr1_V,tmp1_F) VALUES(%s,%s,%s,%s,%s,%s,%s,%s)",(sampleTime,mst1,mst2,mst3,mst4,pot1,ldr1,tmp1))
	con.commit() #this is important for live updating

	time.sleep(.1)
	GPIO.output(sampleLED, False)
	GPIO.output(NPNtrans, False)

slowSample()

if __name__ == '__main__':
	#the following 3 lines start up the interval job and keep it going
    scheduler = Scheduler(standalone=True)
    scheduler.add_interval_job(slowSample, hours=1)
    scheduler.start()

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines

logging.basicConfig()

#GPIO setup

import RPi.GPIO as GPIO

GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc

GPIO.setup(pin, GPIO.OUT)

NPNtrans = 3 #the pin for the npn transistor

GPIO.setup(NPNtrans, GPIO.OUT)

sampleLED = 5 #the indicator LED

GPIO.setup(sampleLED, GPIO.OUT)

#the adc's SPI setup

import spidev

spi = spidev.SpiDev()

spi.open(0, 0)

import MySQLdb

con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');

cursor = con.cursor()

#fuction that can read the adc

def readadc(adcnum):

# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)

if adcnum > 7 or adcnum < 0:

return -1

r = spi.xfer2([1, 8 + adcnum << 4, 0])

adcout = ((r[1] & 3) << 8) + r[2]

return adcout

def slowSample():

GPIO.output(NPNtrans, True)

GPIO.output(sampleLED, True)

sampleTime =time.ctime()

mst1 = readadc(0)

mst2 = readadc(1)

mst3 = readadc(2)

mst4 = readadc(3)

pot1 = readadc(4)

ldr1 = readadc(5)

millivolts = readadc(6)*(3300.0/1024.0)

temp_c = ((millivolts - 100.0)/10)-40.0

tmp1 = (temp_c * 9.0 / 5.0) + 32

print sampleTime,"|","MST1:",mst1,"MST2:",mst2,"MST3:",mst3,"MST4:",mst4,"Pot1:",pot1,"LDR1:",ldr1,"TMP1:",tmp1 #prints the debug info

cursor.execute("INSERT INTO piplanter_table_13(Time,mst1_V,mst2_V,mst3_V,mst4_V,pot1_V,ldr1_V,tmp1_F) VALUES(%s,%s,%s,%s,%s,%s,%s,%s)",(sampleTime,mst1,mst2,mst3,mst4,pot1,ldr1,tmp1))

con.commit() #this is important for live updating

time.sleep(.1)

GPIO.output(sampleLED, False)

GPIO.output(NPNtrans, False)

slowSample()

if __name__ == '__main__':

#the following 3 lines start up the interval job and keep it going

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(slowSample, hours=1)

scheduler.start()

It’s pretty much the same thing.

The graph is also very similar, but I won’t post that code as it’s not different enough.

Here are pictures of setting up the whole system:

I used the same soil as seen in the previous post, and added 125mL of water to each sample.

Here’s a video of me explaining the whole process:

Once enough data is collected I’ll post a graph of it here.

Hey! This post was written a long time ago, but I'm leaving it up on the off-chance it may help someone. Proceed with caution. It may not be a good idea to blindly integrate this code or work into your project, but instead use it as a starting point.

PiPlanter | Planting Seeds!

May 12, 2013 / Leave a comment

This is a short post illustrating the process of planting the seeds.

Here is the “grid” of dirt I am using. I got it from walmart or something like that and essentially it is a grid of dehydrated dirt pucks that are good for planting seeds.

I am using Rio Grand and Homestead seeds. I am going with a shotgun approach and planting a lot of the seeds.

Here is the grid with around a gallon of water added.

Here are all 72 pucks water and populated. With well over 100 seeds planted.

PiPlanter | Moisture detector and a few other updates

May 12, 2013 / 5 Comments

Long time viewers will remember when this idea was conceived two Novembers ago, but essentially it’s a way to detect the relative moisture of a substance.

The principal is the same as in the above post, but this time, I made it bigger and attached it to a Raspberry Pi. The reason this is essential, is because I recently purchased a 12v DC pump capable of moving water. I will be able to sense the relative moisture in the plant, and then the plant will be able to water “itself”.

That will be done in python with the same basic technique I’ve been using all along, but in addition to gathering data about the plant every hour or so, it will be able to see if the plant needs water (by checking hopefully an array of moisture sensors) and then turning on the pump and watering it. I will also eventually integrate twitter and a webcam, but those cosmetic editions come once I know the system works.

To test it, I’ve added another set of data to the graph as seen in the last post and created a testing environment in my windowsill.

Basically I’ve put some dirt and 100mL of water into a container and inserted the sensor and am monitoring the moisture level over the next n hours, here are some pictures:

This is how the sensor sits in the container

Just to get an idea of the data, here is the sensor inserted into the wet dirt

Just to get an idea of the data, here is the sensor inserted into the dry dirt

And here is a graph of some of the data:

I will make another post later today illustrating the process of plating the seeds.

PiPlanter | Graphing timed mysql data with pchart

May 9, 2013 / Leave a comment

Time to get this data we’re harvesting graphed. In a couple past posts, I’ve used pChart to graph random data but now since data is getting dumped into a mysql chart, it would make sense to try and graph that data.

To install pChart on my system (same installs as listed in this post) to do that do the following:

First, get the php5-gd package by running:

sudo apt-get install php5-gd

1	sudo apt-get install php5-gd

Then download, rename and move the pChart files to the proper directory:

sudo mkdir /srv/www/lib/
sudo wget http://www.pchart.net/release/pChart2.1.3.tar.gz
sudo tar -xzvf pChart2.1.3.tar.gz
sudo mv pChart2.1.3 pChart

sudo mkdir /srv/www/lib/

sudo wget http://www.pchart.net/release/pChart2.1.3.tar.gz

sudo tar -xzvf pChart2.1.3.tar.gz

sudo mv pChart2.1.3 pChart

Now pChart is ready to be used.

I used a lot of the info found here:

http://wiki.pchart.net/doc.mysql.integration.html

http://wiki.pchart.net/doc.doc.draw.scale.html

The code is pretty well commented so I’m not really going to get into describing it, but essentially, the following php will retrieve data from a mysql table (which is being populated by a python script seen in this post) and after leaving it on in my room for like 3 days, render this graph:

Here’s that php script:

<?php

/* Include all the classes */ 
include("/srv/www/lib/pChart/class/pData.class.php");
include("/srv/www/lib/pChart/class/pDraw.class.php");
include("/srv/www/lib/pChart/class/pImage.class.php");

/* Create your dataset object */ 
$myData = new pData(); 

$db = mysql_connect("localhost", "piplanter_user", "piplanter_pass"); //location of server, db username, db pass
mysql_select_db("piplanter", $db);

$Requete = "SELECT * FROM `piplanter_table_05`"; //table name
$Result = mysql_query($Requete, $db);

/*This fetches the data from the mysql database, and adds it to pchart as points*/
while($row = mysql_fetch_array($Result))
{
	//$Sample_Number = $row["Sample_Number"]; //Not using this data
	//$myData->addPoints($Sample_Number,"Sample_Number");
	
	$Time = $row["Time"];
	$myData->addPoints($Time,"Time");
	
	$Temp_F = $row["Temp_F"];
	$myData->addPoints($Temp_F,"Temp_F");
	
	$LDR_V = $row["LDR_V"];
	$myData->addPoints($LDR_V,"LDR_V");
}

$myData-> setSerieOnAxis("Temp_F", 0); //assigns the data to the frist axis
$myData-> setAxisName(0, "Temperature"); //adds the label to the first axis

$myData-> setSerieOnAxis("LDR_V", 1);
$myData-> setAxisName(1, "LDR");

$myData-> setAxisPosition(1,AXIS_POSITION_LEFT); //moves the second axis to the far left

$myData->setAbscissa("Time"); //sets the time data set as the x axis label


$myPicture = new pImage(1100,300,$myData); /* Create a pChart object and associate your dataset */ 

$myPicture->setFontProperties(array("FontName"=>"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=>6)); /* Choose a nice font */

$myPicture->setGraphArea(80,40,1000,200); /* Define the boundaries of the graph area */

$Settings = array("R"=>250, "G"=>250, "B"=>250, "Dash"=>1, "DashR"=>0, "DashG"=>0, "DashB"=>0);

$myPicture->drawScale(array("LabelRotation"=>320)); /* Draw the scale, keep everything automatic */ 

/*The combination makes a cool looking graph*/
$myPicture->drawPlotChart();
$myPicture->drawLineChart();


$myPicture->drawLegend(90,20); //adds the legend

$myPicture->autoOutput(); /* Build the PNG file and send it to the web browser */ 

?>

<?php

/* Include all the classes */

include("/srv/www/lib/pChart/class/pData.class.php");

include("/srv/www/lib/pChart/class/pDraw.class.php");

include("/srv/www/lib/pChart/class/pImage.class.php");

/* Create your dataset object */

$myData = new pData();

$db = mysql_connect("localhost", "piplanter_user", "piplanter_pass"); //location of server, db username, db pass

mysql_select_db("piplanter", $db);

$Requete = "SELECT * FROM `piplanter_table_05`"; //table name

$Result = mysql_query($Requete, $db);

/*This fetches the data from the mysql database, and adds it to pchart as points*/

while($row = mysql_fetch_array($Result))

{

//$Sample_Number = $row["Sample_Number"]; //Not using this data

//$myData->addPoints($Sample_Number,"Sample_Number");

$Time = $row["Time"];

$myData->addPoints($Time,"Time");

$Temp_F = $row["Temp_F"];

$myData->addPoints($Temp_F,"Temp_F");

$LDR_V = $row["LDR_V"];

$myData->addPoints($LDR_V,"LDR_V");

}

$myData-> setSerieOnAxis("Temp_F", 0); //assigns the data to the frist axis

$myData-> setAxisName(0, "Temperature"); //adds the label to the first axis

$myData-> setSerieOnAxis("LDR_V", 1);

$myData-> setAxisName(1, "LDR");

$myData-> setAxisPosition(1,AXIS_POSITION_LEFT); //moves the second axis to the far left

$myData->setAbscissa("Time"); //sets the time data set as the x axis label

$myPicture = new pImage(1100,300,$myData); /* Create a pChart object and associate your dataset */

$myPicture->setFontProperties(array("FontName"=>"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=>6)); /* Choose a nice font */

$myPicture->setGraphArea(80,40,1000,200); /* Define the boundaries of the graph area */

$Settings = array("R"=>250, "G"=>250, "B"=>250, "Dash"=>1, "DashR"=>0, "DashG"=>0, "DashB"=>0);

$myPicture->drawScale(array("LabelRotation"=>320)); /* Draw the scale, keep everything automatic */

/*The combination makes a cool looking graph*/

$myPicture->drawPlotChart();

$myPicture->drawLineChart();

$myPicture->drawLegend(90,20); //adds the legend

$myPicture->autoOutput(); /* Build the PNG file and send it to the web browser */

PiPlanter | Basic package setup and bringing everything together

May 5, 2013 / 1 Comment

I’m in a hotel trying to occupy myself with something interesting so I’ve decided to work on this. I had to re-image the SD card I’ve been developing this project on, but I saved to code so there’s no problem there. Now I need to re-install all the basic packages.

First I need to get the components of a LAMP server with the following commands:

sudo apt-get install apache2
sudo apt-get install mysql-server
sudo apt-get install php5
sudo apt-get install php5-server
sudo apt-get install php5-mysql

sudo apt-get install apache2

sudo apt-get install mysql-server

sudo apt-get install php5

sudo apt-get install php5-server

sudo apt-get install php5-mysql

Once you get the mysql server setup, you’ll need to create a database and tables in mysql.

To create the database you’ll be using run the following command:

CREATE DATABASE piplanter;

1	CREATE DATABASE piplanter;

And then grant the proper privileges to use later with the command:

mysql> mysql> GRANT ALL PRIVILEGES ON piplanter.* TO 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;

1 2	mysql> mysql> GRANT ALL PRIVILEGES ON piplanter.* TO 'user'@'localhost' IDENTIFIED BY 'pass'; FLUSH PRIVILEGES;

Then we can enter the database and create a table:

USE piplanter;
CREATE TABLE piplanter_table_01(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Temp_F VARCHAR(100), LDR_V VARCHAR(100) );

1 2	USE piplanter; CREATE TABLE piplanter_table_01(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Temp_F VARCHAR(100), LDR_V VARCHAR(100) );

Now we need to set up the specific libraries for python the first of which being spidev, the spi tool for the raspberry pi which we can grab from git using the following commands:

sudo apt-get install git
git clone git://github.com/doceme/py-spidev
cd py-spidev/
sudo apt-get install python-dev
sudo python setup.py install

sudo apt-get install git

git clone git://github.com/doceme/py-spidev

cd py-spidev/

sudo apt-get install python-dev

sudo python setup.py install

You also need to (copied from http://scruss.com/blog/2013/01/19/the-quite-rubbish-clock/):

As root, edit the kernel module blacklist file:

sudo vi /etc/modprobe.d/raspi-blacklist.conf

1	sudo vi /etc/modprobe.d/raspi-blacklist.conf

Comment out the spi-bcm2708 line so it looks like this:

#blacklist spi-bcm2708

1	#blacklist spi-bcm2708

Save the file so that the module will load on future reboots. To enable the module now, enter:

sudo modprobe spi-bcm2708

1	sudo modprobe spi-bcm2708

We will also need WiringPi:

sudo apt-get install python-imaging python-imaging-tk python-pip python-dev git
sudo pip install spidev
sudo pip install wiringpi

sudo apt-get install python-imaging python-imaging-tk python-pip python-dev git

sudo pip install spidev

sudo pip install wiringpi

Then you need to get APscheduler, the timing program used to execute the incremental timing with the following commands:

wget https://pypi.python.org/packages/source/A/APScheduler/APScheduler-2.1.0.tar.gz
sudo tar -xzvf APScheduler-2.1.0.tar.gz
python setup.py install

wget https://pypi.python.org/packages/source/A/APScheduler/APScheduler-2.1.0.tar.gz

sudo tar -xzvf APScheduler-2.1.0.tar.gz

python setup.py install

You will need mysqldb to interface python and mysql:

sudo apt-get install python-mysqldb

1	sudo apt-get install python-mysqldb

Once you reboot, the following program should work:

#Timing setup
from datetime import datetime
from apscheduler.scheduler import Scheduler
import time
import datetime
import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines
logging.basicConfig()

#GPIO setup
import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc
GPIO.setup(pin, GPIO.OUT)
led1 = 11 #pin for the short indicator led
GPIO.setup(led1, GPIO.OUT)
led2 = 13 #pin for other long indicator led
GPIO.setup(led2, GPIO.OUT)

#the adc's SPI setup
import spidev
spi = spidev.SpiDev()
spi.open(0, 0)

import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()

#fuction that can read the adc
def readadc(adcnum): 
# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)
    if adcnum > 7 or adcnum < 0:
        return -1
    r = spi.xfer2([1, 8 + adcnum << 4, 0])
    adcout = ((r[1] & 3) << 8) + r[2]
    return adcout
    
def rapidSample():	
	sampleTime = time.ctime()
	sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F
	sampleLght1 = readadc(1)
	samplePot1 = readadc(2)
	
	GPIO.output(led1, True) #turns the led on
	time.sleep(.1) #sleeps a little bit so you can see the LED on
	print "Job 1", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info
	
	cursor.execute("INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))
	con.commit() #this is important for live updating
	
	time.sleep(.1)
	GPIO.output(led1, False) #turns the led off
	
def slowSample():
	sampleTime = time.ctime()
	sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F
	sampleLght1 = readadc(1)
	samplePot1 = readadc(2)
	
	GPIO.output(led2, True) #turns the led on
	time.sleep(5)
	
	print "Job 2", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info
	cursor.execute("INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))
	con.commit() #this is important for live updating
	
	time.sleep(5)
	GPIO.output(led2, False) #turns the led on
	
	
if __name__ == '__main__':
	#the following 3 lines start up the interval job and keep it going
    scheduler = Scheduler(standalone=True)
    scheduler.add_interval_job(rapidSample, minutes=1)
    scheduler.add_interval_job(slowSample, hours=1)
    scheduler.start()

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines

logging.basicConfig()

#GPIO setup

import RPi.GPIO as GPIO

GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc

GPIO.setup(pin, GPIO.OUT)

led1 = 11 #pin for the short indicator led

GPIO.setup(led1, GPIO.OUT)

led2 = 13 #pin for other long indicator led

GPIO.setup(led2, GPIO.OUT)

#the adc's SPI setup

import spidev

spi = spidev.SpiDev()

spi.open(0, 0)

import MySQLdb

con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');

cursor = con.cursor()

#fuction that can read the adc

def readadc(adcnum):

# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)

if adcnum > 7 or adcnum < 0:

return -1

r = spi.xfer2([1, 8 + adcnum << 4, 0])

adcout = ((r[1] & 3) << 8) + r[2]

return adcout

def rapidSample():

sampleTime = time.ctime()

sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F

sampleLght1 = readadc(1)

samplePot1 = readadc(2)

GPIO.output(led1, True) #turns the led on

time.sleep(.1) #sleeps a little bit so you can see the LED on

print "Job 1", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info

cursor.execute("INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))

con.commit() #this is important for live updating

time.sleep(.1)

GPIO.output(led1, False) #turns the led off

def slowSample():

sampleTime = time.ctime()

sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F

sampleLght1 = readadc(1)

samplePot1 = readadc(2)

GPIO.output(led2, True) #turns the led on

time.sleep(5)

print "Job 2", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info

cursor.execute("INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))

con.commit() #this is important for live updating

time.sleep(5)

GPIO.output(led2, False) #turns the led on

if __name__ == '__main__':

#the following 3 lines start up the interval job and keep it going

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(rapidSample, minutes=1)

scheduler.add_interval_job(slowSample, hours=1)

scheduler.start()

And there you go! The program should log data every minute and then every hour to two different tables. To view those data sets as php tables you can use this php script:

<?php
mysql_connect("localhost", "piplanter_user","piplanter_pass") or die ("Could not connect: " . mysql_error());
mysql_select_db("piplanter");

$result = mysql_query("SELECT * FROM piplanter_table_02");

echo "<table border='1'>
<tr>
<th>Sample_Number</th>
<th>Time</th>
<th>Temp F</th>
<th>LDR Value V</th>
</tr>";

while($row = mysql_fetch_array($result)){
	echo"<tr>";
	echo"<td>" . $row['Sample_Number'] . "</td>";
	echo"<td>" . $row['Time'] . "</td>";
	echo"<td>" . $row['Temp_F'] . "</td>";
	echo"<td>" . $row['LDR_V'] . "</td>";
	echo"</tr>";
}

echo "</table>";
mysql_close($con);
?>

<?php

mysql_connect("localhost", "piplanter_user","piplanter_pass") or die ("Could not connect: " . mysql_error());

mysql_select_db("piplanter");

$result = mysql_query("SELECT * FROM piplanter_table_02");

echo "<table border='1'>

<tr>

<th>Sample_Number</th>

<th>LDR Value V</th>

</tr>";

while($row = mysql_fetch_array($result)){

echo"<tr>";

echo"<td>" . $row['Sample_Number'] . "</td>";

echo"<td>" . $row['Time'] . "</td>";

echo"<td>" . $row['Temp_F'] . "</td>";

echo"<td>" . $row['LDR_V'] . "</td>";

echo"</tr>";

}

echo "</table>";

mysql_close($con);

Sometime later I’ll get to graphing the data.

esologic

Month: May 2013

PiPlanter | Second round of data collection

PiPlanter | Planting Seeds!

PiPlanter | Moisture detector and a few other updates

PiPlanter | Graphing timed mysql data with pchart

PiPlanter | Basic package setup and bringing everything together