PiPlanter 2 | Getting Started Again

May 9, 2014 / 1 Comment

So I have decided to re write the PiPlanter from the ground up. In essence, it will accomplish the same exact thing but I’d like it to be a lot more of a stable platform to expand upon in the future. I’d also like PiPlanter to be professional enough to bring to market. First off there are a few things you’d need install & a few modifications you’d need to make to Raspian. First thing’s first, you’ll need to enable SPI in the kernel so:

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

Then run this to make it more permanent.

sudo modprobe spi-bcm2708

1	sudo modprobe spi-bcm2708

Now for the real meat of it. You’ll need these packages for SPI and the WiringPi library makes things a whole lot easier for us. This program also relies very heavily

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 apache2
sudo apt-get install mysql-server
sudo apt-get install php5
sudo apt-get install php5-mysql
sudo pip install tweepy&lt;/pre&gt;
&lt;pre style=&quot;color: #333333;&quot;&gt;sudo pip install apscheduler&lt;/pre&gt;
&lt;pre&gt;

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 apache2

sudo apt-get install mysql-server

sudo apt-get install php5

sudo apt-get install php5-mysql

sudo pip install tweepy</pre>

<pre style="color: #333333;">sudo pip install apscheduler</pre>

<pre>

Revised python code next post.

Using a pair of Arduinos to mimic a keyboard

September 28, 2013 / 3 Comments

Here’s a video:

So in my last post I showed you a way that I used a single arduino to talk to a Raspberry Pi (or any other computer) over HID. I’ve updated the project a bit and now I can input any number of things into the pi. Basically this is how it works.

Serial Console on computer -> Arduino Mega -> software serial port -> Arduino micro -> HID on other second computer (in this case the Pi)

There are two buttons that handle pressing the enter key and the delete key as those are hard to send over serial.

There are a few bits of relevant code, both for the arduino. Here’s the mega’s code:

int sent_led = 44;
int test_button = 30;

byte inread;

#include &amp;lt;SoftwareSerial.h&amp;gt;
SoftwareSerial SoftSerial(34, 36); // RX, TX

void setup(){
  pinMode(sent_led, OUTPUT);
  pinMode(test_button, INPUT);

  Serial.begin(9600);
  SoftSerial.begin(4800);

  SoftSerial.println("Hello, world?");

}

void loop(){
  if (Serial.available()&amp;gt;0){
    digitalWrite(sent_led, HIGH);
    Serial.print("Sending: ");
    inread = Serial.read();
    Serial.write(inread);
    SoftSerial.write(inread);
    Serial.print(" , ");
    Serial.print(inread);
    Serial.println("");
    digitalWrite(sent_led, LOW);
  }

}

int sent_led = 44;

int test_button = 30;

byte inread;

#include &lt;SoftwareSerial.h&gt;

SoftwareSerial SoftSerial(34, 36); // RX, TX

void setup(){

pinMode(sent_led, OUTPUT);

pinMode(test_button, INPUT);

Serial.begin(9600);

SoftSerial.begin(4800);

SoftSerial.println("Hello, world?");

}

void loop(){

if (Serial.available()&gt;0){

digitalWrite(sent_led, HIGH);

Serial.print("Sending: ");

inread = Serial.read();

Serial.write(inread);

SoftSerial.write(inread);

Serial.print(" , ");

Serial.print(inread);

Serial.println("");

digitalWrite(sent_led, LOW);

}

And here’s the side for the arduino micro, that writes as an HID.

int stat_led = 3;
int enter_led = 4;
int delete_led = 5;

int enter_button = 6;
int delete_button = 7;
int engage_switch = 8;

#include &lt;SoftwareSerial.h&gt;
SoftwareSerial SoftSerial(11, 10); // RX, TX

void setup(){
pinMode(enter_led, OUTPUT);
pinMode(delete_led, OUTPUT);
pinMode(stat_led, OUTPUT);

pinMode(enter_button, INPUT);
pinMode(delete_button, INPUT);
pinMode(engage_switch, INPUT);

Serial.begin(9600);
SoftSerial.begin(4800);

Keyboard.begin(); //

}

void loop(){
if (SoftSerial.available()){
digitalWrite(stat_led, HIGH);
Keyboard.write(SoftSerial.read());
digitalWrite(stat_led, LOW);
}

if (digitalRead(enter_button) == HIGH){
Keyboard.press(KEY_RETURN);
delay(100);
Keyboard.release(KEY_RETURN);
digitalWrite(enter_led, HIGH);
}
else if (digitalRead(enter_button) == LOW){
digitalWrite(enter_led, LOW);
}

if (digitalRead(delete_button) == HIGH){
digitalWrite(delete_led, HIGH);
Keyboard.press(KEY_BACKSPACE);
delay(100);
Keyboard.release(KEY_BACKSPACE);
}
else if (digitalRead(delete_button) == LOW){
digitalWrite(delete_led, LOW);
}

}

int stat_led = 3;

int enter_led = 4;

int delete_led = 5;

int enter_button = 6;

int delete_button = 7;

int engage_switch = 8;

#include <SoftwareSerial.h>

SoftwareSerial SoftSerial(11, 10); // RX, TX

void setup(){

pinMode(enter_led, OUTPUT);

pinMode(delete_led, OUTPUT);

pinMode(stat_led, OUTPUT);

pinMode(enter_button, INPUT);

pinMode(delete_button, INPUT);

pinMode(engage_switch, INPUT);

Serial.begin(9600);

SoftSerial.begin(4800);

Keyboard.begin(); //

}

void loop(){

if (SoftSerial.available()){

digitalWrite(stat_led, HIGH);

Keyboard.write(SoftSerial.read());

digitalWrite(stat_led, LOW);

}

if (digitalRead(enter_button) == HIGH){

Keyboard.press(KEY_RETURN);

delay(100);

Keyboard.release(KEY_RETURN);

digitalWrite(enter_led, HIGH);

}

else if (digitalRead(enter_button) == LOW){

digitalWrite(enter_led, LOW);

}

if (digitalRead(delete_button) == HIGH){

digitalWrite(delete_led, HIGH);

Keyboard.press(KEY_BACKSPACE);

delay(100);

Keyboard.release(KEY_BACKSPACE);

}

else if (digitalRead(delete_button) == LOW){

digitalWrite(delete_led, LOW);

}

Using Arduino Micro as a USB keyboard for Raspberry Pi

September 16, 2013 / 5 Comments

Greetings from WPI! Here’s a video:

Desperate times call for desperate measures. I recently found out that a club at my school is essentially a hackerspace equipped with 3D printers so I could finally print enclosures for the PiPlanter and the DSFU. But that means I would need to finial the designs for both of them. I needed to find a way to interface with this thing here. So being the idiot that I am, I forgot a USB keyboard, I forgot an analog video cable, I forgot a monitor for the pi and forgot to update the Pi to the latest Raspian build.

What I did bring was an Easy Cap Capture Card in addition to my standard idea-kit which among other things consists of an Arduino Micro, some buttons, some resistors, and wire.

Essentially all I needed to do was connect the Pi to the EasyCap, and be able to send 4 different phrases to it over the keyboard. I needed to be able to send ‘pi’,’password’ (not my actual password), ‘ifconfig’ and enter. I realized that I could easily send this data to the Pi via the Micro as it has the Keyboard. functions built in.

As you can see in the video it worked! And I’m kind of stunned that it did. I can now SSH into the Pi.

Here’s the code for the Arduino:

int uname = 3;
int pass = 4;
int command = 5;
int enter = 6;

int green = 7;
int red = 8;

void setup(){
  pinMode(3, INPUT);
  pinMode(4, INPUT);
  pinMode(5, INPUT);
  pinMode(6, INPUT);

  pinMode(7, OUTPUT);
  pinMode(8, OUTPUT);

  Serial.begin(9600);

  Keyboard.begin();
}

void loop(){
  if (digitalRead(uname) == HIGH){
    Serial.print("1");
    Keyboard.print("pi");
    digitalWrite(green, HIGH);
    digitalWrite(red, LOW);
    delay(1000);
  }
  else {
    Serial.print("0");
    digitalWrite(green, LOW);
    digitalWrite(red, HIGH);
  }

  Serial.print(",");

  if (digitalRead(pass) == HIGH){
    Serial.print("1");
    Keyboard.print("password");
    digitalWrite(green, HIGH);
    digitalWrite(red, LOW);
    delay(1000);
  }
  else {
    Serial.print("0");
    digitalWrite(green, LOW);
    digitalWrite(red, HIGH);
  }

  Serial.print(",");

  if (digitalRead(command) == HIGH){
    Serial.print("1");
    Keyboard.print("ifconfig");
    digitalWrite(green, HIGH);
    digitalWrite(red, LOW);
    delay(1000);
  }
  else {
    Serial.print("0");
    digitalWrite(green, LOW);
    digitalWrite(red, HIGH);
  }

  Serial.print(",");

  if (digitalRead(enter) == HIGH){
    Serial.print("1");
    Keyboard.press(KEY_RETURN);
    delay(10);
    Keyboard.releaseAll();
    digitalWrite(green, HIGH);
    digitalWrite(red, LOW);
    delay(1000);
  }
  else {
    Serial.print("0");
    digitalWrite(green, LOW);
    digitalWrite(red, HIGH);
  }

  Serial.println("");
  delay(10);
}

int uname = 3;

int pass = 4;

int command = 5;

int enter = 6;

int green = 7;

int red = 8;

void setup(){

pinMode(3, INPUT);

pinMode(4, INPUT);

pinMode(5, INPUT);

pinMode(6, INPUT);

pinMode(7, OUTPUT);

pinMode(8, OUTPUT);

Serial.begin(9600);

Keyboard.begin();

}

void loop(){

if (digitalRead(uname) == HIGH){

Serial.print("1");

Keyboard.print("pi");

digitalWrite(green, HIGH);

digitalWrite(red, LOW);

delay(1000);

}

else {

Serial.print("0");

digitalWrite(green, LOW);

digitalWrite(red, HIGH);

}

Serial.print(",");

if (digitalRead(pass) == HIGH){

Serial.print("1");

Keyboard.print("password");

digitalWrite(green, HIGH);

digitalWrite(red, LOW);

delay(1000);

}

else {

Serial.print("0");

digitalWrite(green, LOW);

digitalWrite(red, HIGH);

}

Serial.print(",");

if (digitalRead(command) == HIGH){

Serial.print("1");

Keyboard.print("ifconfig");

digitalWrite(green, HIGH);

digitalWrite(red, LOW);

delay(1000);

}

else {

Serial.print("0");

digitalWrite(green, LOW);

digitalWrite(red, HIGH);

}

Serial.print(",");

if (digitalRead(enter) == HIGH){

Serial.print("1");

Keyboard.press(KEY_RETURN);

delay(10);

Keyboard.releaseAll();

digitalWrite(green, HIGH);

digitalWrite(red, LOW);

delay(1000);

}

else {

Serial.print("0");

digitalWrite(green, LOW);

digitalWrite(red, HIGH);

}

Serial.println("");

delay(10);

}

Thanks for Reading!

PiPlanter | Goals and changes

September 3, 2013 / 1 Comment

So I am 151 miles away from the PiPlanter. But thanks to the internet, modern day routers, and wifi dongles I can pretty much control everything about it from here.

That being said, there are a few things I would like to change about the project. First of all, the program itself needs to be more modular. Reason being is that the core program should never stop running, even if changes need to be made. I should be able to screen the main program once, and then never have to stop it ever. This would be advantageous in a few ways but the main example is that the plants will require more water as they get larger, and then less once they start yielding fruit. I could script this, but I think that it would be best to be able to edit the ‘ontime’ value from the program without having to stop the whole process.

I’ll keep y’all posted as I try to implement this.

Multiple Project Update

August 9, 2013 / Leave a comment

Hi guys

So I’ve been eeking out all that I can of my last few days of summer, and there hasn’t been much rain or bad weather at all. As a result, I’m not posting much at all.

Doesn’t mean I’m not working though, I’ve been doing a couple things.

First thing’s first my speaker is done. I just need to get a bunch of video edited, and a big post written.

Secondly I’m still working really hard on my dead simple flickr uploader (dsfu). The cool thing about this project is that it has the potential to be very useful to quite a number of people, so I’m trying to make sure that it is very stable, and very easy to duplicate. This means for the most part I’ve been doing a series of 4000+ photo uploads trying to break my script. It’s happened a lot, and you can check my twitter feed to see my brain melt as I try and figure out the problem. This project won’t necessarily be “complete” until I have a 3D printer at my disposal to create the enclosure I want.

As for the PiPlanter, it’s still a work in progress. The update I did with my last post was a start to something really complete it is in no way finished. I still need to move the camera, and the plants.

Thanks for reading!

PiPlanter | Big Overhaul Update

July 30, 2013 / Leave a comment

Okay! So I leave for college in less than 30 days, but I’d like to make sure my tomatoes to continue to grow once I leave so I’ve taken some steps to make sure that my departure goes smoothly.

Here’s a video of my revised setup:

There are a few key differences between this setup and my previous one:

The main one is that the watering system has been 100% re-vamped. The water distribution happens via a hose with holes in it instead of using the tray at the bottom of the plant grid in the previous video.

It also takes, uploads and tweets a picture of itself using a raspberry pi camera module.

It also creates a new mysql table every two weeks, and in turn, renders a new kind of graph. The renderscript.php file receives an argument from the python script which is the table code.

Here’s the python script:

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




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)
pump = 7 #pin for the pump
GPIO.setup(pump, GPIO.OUT)
GPIO.output(pump, False)




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




#sets up the program's ability to write to a mysql database
import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()




#tweepy setup, you must use the keys given to you when you create your app
import tweepy
consumer_key=""
consumer_secret=""
access_token=""
access_token_secret=""
#"logs in" to twitter, 
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)




#Flickr Setup
import flickrapi
api_key = ''
api_secret = ''
flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')
(token, frob) = flickr.get_token_part_one(perms='write')
if not token: raw_input("Press ENTER after you authorized this program")
flickr.get_token_part_two((token, frob))




#Variable Setup
ontime = 60




global table_number
table_number = 0




#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 water():
	
	print "===== Starting Watering Process ====="
	
	GPIO.output(NPNtrans, True)
	GPIO.output(sampleLED, True)
	
	time.sleep(1)
	
	sensor1_before = readadc(0)
	sensor2_before = readadc(1)
	sensor3_before = readadc(2)
	sensor4_before = readadc(3)
	
	before = "WATERING START / Moisture Before - " + "Sensor 1:" + str(sensor1_before) + " Sensor 2:" + str(sensor2_before) + " Sensor 3:" + str(sensor3_before) + " Sensor 4:" + str(sensor4_before) + " - Average:" + str((float(sensor1_before+sensor2_before+sensor3_before+sensor4_before)/4)) 
	api.update_status(before) 
	print before
	
	GPIO.output(pump, True)
	time.sleep(ontime)
	GPIO.output(pump, False)
	
	time.sleep(60) #gives the water time to penetrate the soil
	
	sensor1_after = readadc(0)
	sensor2_after = readadc(1)
	sensor3_after = readadc(2)
	sensor4_after = readadc(3)
	
	after = "WATERING COMPLETED / Moisture After - " + "Sensor 1:" + str(sensor1_after) + " Sensor 2:" + str(sensor2_after) + " Sensor 3:" + str(sensor3_after) + " Sensor 4:" + str(sensor4_after) + " - Average: " + str((float(sensor1_after+sensor2_after+sensor3_after+sensor4_after)/4)) 
	api.update_status(after) 
	print after
	
	GPIO.output(NPNtrans, False)
	GPIO.output(sampleLED, False)
	
	print "====== Watering Process Complete ====="    	
    	
def hourlyUpdate():
	GPIO.output(pump, False)
	print "----------start----------\n"
	
	GPIO.output(NPNtrans, True)
	GPIO.output(sampleLED, True)
	
	time.sleep(1)
	
	sampleTime = time.ctime()
	
	mst1 = 1024-readadc(0)
	mst2 = 1024-readadc(1)
	mst3 = 1024-readadc(2)
	mst4 = 1024-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 'Polling Probes \n'
	
	#prints debug info to console
	print sampleTime,"|","MST1:",mst1,"MST2:",mst2,"MST3:",mst3,"MST4:",mst4,"Pot1:",pot1,"LDR1:",ldr1,"TMP1:",tmp1 #prints the debug info
	
	global table_number
	print 'Adding Data To Table: ' + str(table_number)




	#adds the data to the mysql table
	global table_number
	cursor.execute('INSERT INTO piplanter_table_'+ table_code +'(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
	GPIO.output(NPNtrans, False) #turns the probes off
	print 'Data Collected, Disengaging Probes \n'
	
	
	#takes a picture of the plants
	print 'Taking Picture with Raspberry Pi Camera Board'
	picture_dir = '/home/pi/documents/piplanter/images/'
	os.system('raspistill -o ' + picture_dir + str(time.strftime('%m-%d-%y_%H-%M-%S')) + '.jpg')
	print 'Capture Successfull: ' + picture_dir + str(time.strftime('%m-%d-%y_%H-%M-%S')) + '.jpg'
		
	#finds the newest image in the directory
	print '\nUploading Picture To Flickr'
	picture_allfiles = sorted(os.listdir(picture_dir), key=lambda p: os.path.getctime(os.path.join(picture_dir, p)))
	picture_newest = picture_dir+picture_allfiles[-1]
	print 'File for upload: ' + picture_newest #prints location and file to console
	
	#uploads the picture of the plants to flickr
	picture_title = 'Picture @ ' + str(sampleTime)
	picture_response = flickr.upload(filename=picture_newest, title=picture_title, format='etree') #uploads the file to flickr
	picture_photoID = picture_response.find('photoid').text #gets the id of the photo for constructing a url
	print 'Picture Upload Successful, Photo ID: ' + picture_photoID + '\n' #more debug info
	
	time.sleep(10)
	
	#renders the image of the graph
	print "Graph Render Start"
	global table_code
	os.system('php /opt/bitnami/wordpress/piplanter/renderScript.php ' + table_code ) #renders the .png file
	print "Graph Render Complete \n"
	
	#finds the newest image in the directory
	print 'Uploading Graph To Flickr'
	graph_allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))
	graph_newest = '/opt/bitnami/wordpress/piplanter/renders/'+graph_allfiles[-1]
	print 'File for upload: ' + graph_newest #prints location and file to console
	
	graph_title = 'Graph @ ' + str(sampleTime)
	graph_response = flickr.upload(filename=graph_newest, title=graph_title, format='etree') #uploads the file to flickr
	graph_photoID = graph_response.find('photoid').text #gets the id of the photo for constructing a url
	print 'Graph Upload Successful, Photo ID: ' + graph_photoID + '\n' #more debug info
	
	#tweets the images and data
	send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+  str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' + 'http://www.flickr.com/photos/97350286@N08/'+ str(graph_photoID) + ' Pic: ' + 'http://www.flickr.com/photos/97350286@N08/' + str(picture_photoID) #builds the text of the tweet
	print "Tweeting:" , send  #for debug purposes
	api.update_status(send) #tweets the tweet
		
	time.sleep(.1)
	GPIO.output(sampleLED, False)
	
	print "\n-----------end-----------"
	
def table_update():
	
	global table_number
	table_number = table_number + 1
	
	global table_code
	table_code = str(time.strftime('%m_%d_%y_%H_%M_%S')) + '__' + str(table_number)
	print 'Creating Table: ' + table_code
	cursor.execute('USE piplanter')
	con.commit()
	cursor.execute('CREATE TABLE piplanter_table_'+ table_code +'(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), mst1_V VARCHAR(100), mst2_V VARCHAR(100), mst3_V VARCHAR(100), mst4_V VARCHAR(100), pot1_V VARCHAR(100), ldr1_V VARCHAR(100), tmp1_F VARCHAR(100) );')
	con.commit()




table_update()
hourlyUpdate()
	
scheduler = Scheduler(standalone=True)




scheduler.add_interval_job(hourlyUpdate, hours=1)
scheduler.add_interval_job(water, days=1)
scheduler.add_interval_job(table_update, weeks=2)




scheduler.start() #runs the program indefianately once every hour

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

import os

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)

pump = 7 #pin for the pump

GPIO.setup(pump, GPIO.OUT)

GPIO.output(pump, False)

#the adc's SPI setup

import spidev

spi = spidev.SpiDev()

spi.open(0, 0)

#sets up the program's ability to write to a mysql database

import MySQLdb

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

cursor = con.cursor()

#tweepy setup, you must use the keys given to you when you create your app

import tweepy

consumer_key=""

consumer_secret=""

access_token=""

access_token_secret=""

#"logs in" to twitter,

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

auth.set_access_token(access_token, access_token_secret)

api = tweepy.API(auth)

#Flickr Setup

import flickrapi

api_key = ''

api_secret = ''

flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')

(token, frob) = flickr.get_token_part_one(perms='write')

if not token: raw_input("Press ENTER after you authorized this program")

flickr.get_token_part_two((token, frob))

#Variable Setup

ontime = 60

global table_number

table_number = 0

#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 water():

print "===== Starting Watering Process ====="

GPIO.output(NPNtrans, True)

GPIO.output(sampleLED, True)

time.sleep(1)

sensor1_before = readadc(0)

sensor2_before = readadc(1)

sensor3_before = readadc(2)

sensor4_before = readadc(3)

before = "WATERING START / Moisture Before - " + "Sensor 1:" + str(sensor1_before) + " Sensor 2:" + str(sensor2_before) + " Sensor 3:" + str(sensor3_before) + " Sensor 4:" + str(sensor4_before) + " - Average:" + str((float(sensor1_before+sensor2_before+sensor3_before+sensor4_before)/4))

api.update_status(before)

print before

GPIO.output(pump, True)

time.sleep(ontime)

GPIO.output(pump, False)

time.sleep(60) #gives the water time to penetrate the soil

sensor1_after = readadc(0)

sensor2_after = readadc(1)

sensor3_after = readadc(2)

sensor4_after = readadc(3)

after = "WATERING COMPLETED / Moisture After - " + "Sensor 1:" + str(sensor1_after) + " Sensor 2:" + str(sensor2_after) + " Sensor 3:" + str(sensor3_after) + " Sensor 4:" + str(sensor4_after) + " - Average: " + str((float(sensor1_after+sensor2_after+sensor3_after+sensor4_after)/4))

api.update_status(after)

print after

GPIO.output(NPNtrans, False)

GPIO.output(sampleLED, False)

print "====== Watering Process Complete ====="

def hourlyUpdate():

GPIO.output(pump, False)

print "----------start----------\n"

GPIO.output(NPNtrans, True)

GPIO.output(sampleLED, True)

time.sleep(1)

sampleTime = time.ctime()

mst1 = 1024-readadc(0)

mst2 = 1024-readadc(1)

mst3 = 1024-readadc(2)

mst4 = 1024-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 'Polling Probes \n'

#prints debug info to console

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

global table_number

print 'Adding Data To Table: ' + str(table_number)

#adds the data to the mysql table

global table_number

cursor.execute('INSERT INTO piplanter_table_'+ table_code +'(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

GPIO.output(NPNtrans, False) #turns the probes off

print 'Data Collected, Disengaging Probes \n'

#takes a picture of the plants

print 'Taking Picture with Raspberry Pi Camera Board'

picture_dir = '/home/pi/documents/piplanter/images/'

os.system('raspistill -o ' + picture_dir + str(time.strftime('%m-%d-%y_%H-%M-%S')) + '.jpg')

print 'Capture Successfull: ' + picture_dir + str(time.strftime('%m-%d-%y_%H-%M-%S')) + '.jpg'

#finds the newest image in the directory

print '\nUploading Picture To Flickr'

picture_allfiles = sorted(os.listdir(picture_dir), key=lambda p: os.path.getctime(os.path.join(picture_dir, p)))

picture_newest = picture_dir+picture_allfiles[-1]

print 'File for upload: ' + picture_newest #prints location and file to console

#uploads the picture of the plants to flickr

picture_title = 'Picture @ ' + str(sampleTime)

picture_response = flickr.upload(filename=picture_newest, title=picture_title, format='etree') #uploads the file to flickr

picture_photoID = picture_response.find('photoid').text #gets the id of the photo for constructing a url

print 'Picture Upload Successful, Photo ID: ' + picture_photoID + '\n' #more debug info

time.sleep(10)

#renders the image of the graph

print "Graph Render Start"

global table_code

os.system('php /opt/bitnami/wordpress/piplanter/renderScript.php ' + table_code ) #renders the .png file

print "Graph Render Complete \n"

#finds the newest image in the directory

print 'Uploading Graph To Flickr'

graph_allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))

graph_newest = '/opt/bitnami/wordpress/piplanter/renders/'+graph_allfiles[-1]

print 'File for upload: ' + graph_newest #prints location and file to console

graph_title = 'Graph @ ' + str(sampleTime)

graph_response = flickr.upload(filename=graph_newest, title=graph_title, format='etree') #uploads the file to flickr

graph_photoID = graph_response.find('photoid').text #gets the id of the photo for constructing a url

print 'Graph Upload Successful, Photo ID: ' + graph_photoID + '\n' #more debug info

#tweets the images and data

send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+ str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' + 'http://www.flickr.com/photos/97350286@N08/'+ str(graph_photoID) + ' Pic: ' + 'http://www.flickr.com/photos/97350286@N08/' + str(picture_photoID) #builds the text of the tweet

print "Tweeting:" , send #for debug purposes

api.update_status(send) #tweets the tweet

time.sleep(.1)

GPIO.output(sampleLED, False)

print "\n-----------end-----------"

def table_update():

global table_number

table_number = table_number + 1

global table_code

table_code = str(time.strftime('%m_%d_%y_%H_%M_%S')) + '__' + str(table_number)

print 'Creating Table: ' + table_code

cursor.execute('USE piplanter')

con.commit()

cursor.execute('CREATE TABLE piplanter_table_'+ table_code +'(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), mst1_V VARCHAR(100), mst2_V VARCHAR(100), mst3_V VARCHAR(100), mst4_V VARCHAR(100), pot1_V VARCHAR(100), ldr1_V VARCHAR(100), tmp1_F VARCHAR(100) );')

con.commit()

table_update()

hourlyUpdate()

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(hourlyUpdate, hours=1)

scheduler.add_interval_job(water, days=1)

scheduler.add_interval_job(table_update, weeks=2)

scheduler.start() #runs the program indefianately once every hour

Here’s the .php script:

&lt;?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");

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

$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_" . $argv[1] . "`"; //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))
{	
	$Time = $row["Time"];
	$myData-&gt;addPoints($Time,"Time");
	
	$mst1_V = $row["mst1_V"];
	$myData-&gt;addPoints($mst1_V,"mst1_V");
	$mst2_V = $row["mst2_V"];
	$myData-&gt;addPoints($mst2_V,"mst2_V");
	$mst3_V = $row["mst3_V"];
	$myData-&gt;addPoints($mst3_V,"mst3_V");
	$mst4_V = $row["mst4_V"];
	$myData-&gt;addPoints($mst4_V,"mst4_V");
	
	$ldr1_V = $row["ldr1_V"];
	$myData-&gt;addPoints($ldr1_V,"ldr1_V");
	
	$tmp1_F = $row["tmp1_F"];
	$myData-&gt;addPoints($tmp1_F,"tmp1_F");
}

$myData-&gt; setSerieOnAxis("tmp1_F", 0); //assigns the data to the frist axis
$myData-&gt; setAxisName(0, "Degrees F"); //adds the label to the first axis

$myData-&gt; setSerieOnAxis("ldr1_V", 1);
$myData-&gt; setAxisName(1, "LDR");

$myData-&gt; setSerieOnAxis("mst1_V", 2);
$myData-&gt; setSerieWeight("mst1_V",2);
$myData-&gt; setSerieOnAxis("mst2_V", 2);
$myData-&gt; setSerieOnAxis("mst3_V", 2);
$myData-&gt; setSerieOnAxis("mst4_V", 2);
$myData-&gt; setAxisName(2, "Relative Moisture");

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

$myData-&gt; setSerieWeight("mst1_V",1); //draws the line tickness
$myData-&gt;setPalette("mst1_V",array("R"=&gt;58,"G"=&gt;95,"B"=&gt;205,"Alpha"=&gt;80)); //sets the line color
$myData-&gt; setSerieWeight("mst2_V",1);
$myData-&gt;setPalette("mst2_V",array("R"=&gt;39,"G"=&gt;64,"B"=&gt;139,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst3_V",1);
$myData-&gt;setPalette("mst3_V",array("R"=&gt;0,"G"=&gt;34,"B"=&gt;102,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst4_V",1);
$myData-&gt;setPalette("mst4_V",array("R"=&gt;67,"G"=&gt;110,"B"=&gt;238,"Alpha"=&gt;80));

$myData-&gt; setSerieWeight("ldr1_V",2);
$myData-&gt; setSerieTicks("ldr1_V", 4);

$myData-&gt; setSerieWeight("tmp1_F",2);
$myData-&gt; setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(4000,500,$myData); /* Create a pChart object and associate your dataset */ 
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=&gt;6)); /* Choose a nice font */
$myPicture-&gt;setGraphArea(130,40,3900,300); /* Define the boundaries of the graph area */
$myPicture-&gt;drawScale(array("LabelRotation"=&gt;320)); /* Draw the scale, keep everything automatic */ 

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

/*The combination makes a cool looking graph*/
$myPicture-&gt;drawPlotChart(array("DisplayValues"=&gt;TRUE));
$myPicture-&gt;drawLineChart();
$myPicture-&gt;drawLegend(30,320); //adds the legend

//$date-&gt; date("d-M-Y:H:i:s");

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

$myPicture-&gt;render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");

?&gt;

<?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");

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

$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_" . $argv[1] . "`"; //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))

{

$Time = $row["Time"];

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

$mst1_V = $row["mst1_V"];

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

$mst2_V = $row["mst2_V"];

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

$mst3_V = $row["mst3_V"];

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

$mst4_V = $row["mst4_V"];

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

$ldr1_V = $row["ldr1_V"];

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

$tmp1_F = $row["tmp1_F"];

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

}

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

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

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

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

$myData-> setSerieOnAxis("mst1_V", 2);

$myData-> setSerieWeight("mst1_V",2);

$myData-> setSerieOnAxis("mst2_V", 2);

$myData-> setSerieOnAxis("mst3_V", 2);

$myData-> setSerieOnAxis("mst4_V", 2);

$myData-> setAxisName(2, "Relative Moisture");

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

$myData-> setSerieWeight("mst1_V",1); //draws the line tickness

$myData->setPalette("mst1_V",array("R"=>58,"G"=>95,"B"=>205,"Alpha"=>80)); //sets the line color

$myData-> setSerieWeight("mst2_V",1);

$myData->setPalette("mst2_V",array("R"=>39,"G"=>64,"B"=>139,"Alpha"=>80));

$myData-> setSerieWeight("mst3_V",1);

$myData->setPalette("mst3_V",array("R"=>0,"G"=>34,"B"=>102,"Alpha"=>80));

$myData-> setSerieWeight("mst4_V",1);

$myData->setPalette("mst4_V",array("R"=>67,"G"=>110,"B"=>238,"Alpha"=>80));

$myData-> setSerieWeight("ldr1_V",2);

$myData-> setSerieTicks("ldr1_V", 4);

$myData-> setSerieWeight("tmp1_F",2);

$myData-> setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(4000,500,$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(130,40,3900,300); /* Define the boundaries of the graph area */

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

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

/*The combination makes a cool looking graph*/

$myPicture->drawPlotChart(array("DisplayValues"=>TRUE));

$myPicture->drawLineChart();

$myPicture->drawLegend(30,320); //adds the legend

//$date-> date("d-M-Y:H:i:s");

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

$myPicture->render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");

Thank you for reading!

PiPlanter | Transplanting and Transporting Plants

July 13, 2013 / 1 Comment

Hi! I moved the plants out of the bin and into 4 different pots, here are a few pictures of that process:

I need to think of a new way to water all 4 plants…

PiPlanter – A Plant Growth Automator

June 27, 2013 / 32 Comments

New Version The Post Below Is Out Of Date Click Here For The New Version

This post is many months in the making and I am very proud of the thing’s I’ve done here, and very thankful to all of those (specifically at www.reddit.com/r/raspberry_pi) who have helped me along my way to getting this project up and running.

This page contains every single post related to this project, please feel free to go back and look at my progression and pick up tips along the way if you want to try something like this.

Let’s get this going, here’s an overview video:

There are 8 parts to this system and, you guessed it, I’ll be going in-depth about every single one!

Sensor Network

So at it’s core, the PiPlanter is a Sensor Network & Pump System. Here’s a video explaining the sensor array:

This project uses a TMP35-37 sensor to get a pretty precise temperature reading of the room. Later down in this post you can find out the algorithm to determine the temperature in Fahrenheit. It also uses a basic LDR to get the relative ambient light level in the room. Along with those two sensors, there are 4 relative humidity sensors of my own design, here’s a picture of them as seen in this post:

They’re hooked up to the ADC (mentioned later) in the same way that the LDR is, with a voltage dividing resistor, and then fed directly into ADC. The principal behind this sensor is that when you insert it into soil, the water in that soil connected the two probes, causing a voltage to flow across them. So if there is more water in the soil, more electrons will flow across them, and the analog value will be higher. It’s very basic, but it works. I’ve done several long term tests, and over time, as the soil becomes dryer, the value gets lower, indicating relative dryness. Here is a picture of the four probes in the soil, with the plants.

The TMP sensor’s output is plugged directly into the ADC and the LDR is very basically connected to the ADC as well, this is essentially how how the whole thing is setup on the breadboard:

Pump System

The pump system is pretty dead simple. Essentially it is a PowerSwitch Tail II switching the mains to a 9v DC power supply. The 9v power supply is connected directly to a 12v DC submersible pump. Instead of using a motor driver chip, which requires 3 pins to do, and the chip would get hot and whatnot, I’ve decided to go with this method.

The pump is not self priming. This means it cannot make the transition from pumping air to pumping water. I wrestled with this problem for a long time, and came up with what I think is an elegant solution. I submerged the pump directly into the water, which means the pump will never fill with air, and will always pump water when activated. Here’s a video explaining the pump system:

Raspberry Pi ADC

The next system is the ADC connected to the Raspberry Pi. It is an 8 bit, 8 port analog to digital converter that can easily run on 3.3v so it’s perfect for the pi. Here is the chip, and you set it up as follows (I took this from an earlier post I wrote)

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

To read from the ADC, add the following to your python code. The full code will be listed later:

#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

#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

So just use “readadc(n)” to get a value.

Python Code

I’ve made a real effort this time to comment my code well, so I’m not going to do a line by line breakdown like I often do, but I will clearly state the installs and setup things as follows. I’m assuming you have python-dev installed.

Download and install: APScheduler, this is a very straight forward install

Download and install: tweepy, you will need to go through the API setup process.

Download and install: flickrapi, you will need to go through the API setup process.

Here’s the source code for the python component of this project:

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

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)
pump = 7 #pin for the pump
GPIO.setup(pump, GPIO.OUT)

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

#sets up the program's ability to write to a mysql database
import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()

#tweepy setup, you must use the keys given to you when you create your app
import tweepy
consumer_key=""
consumer_secret=""
access_token=""
access_token_secret=""
#"logs in" to twitter,
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)

#Flickr Setup
import flickrapi
api_key = ''
api_secret = ''
flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')
(token, frob) = flickr.get_token_part_one(perms='write')
if not token: raw_input("Press ENTER after you authorized this program")
flickr.get_token_part_two((token, frob))

#Variable Setup
ontime = 20

#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():

	date0 = "21-06-2013 15"
	date1 = "25-06-2013 12"
	date2 = "29-06-2013 12"
	date3 = "04-07-2013 12"
	date4 = "06-07-2013 12"

	if str(time.strftime('%d-%m-%Y %H')) == date0:
		water()
	if str(time.strftime('%d-%m-%Y %H')) == date1:
		water()
	if str(time.strftime('%d-%m-%Y %H')) == date2:
		water()
	if str(time.strftime('%d-%m-%Y %H')) == date3:
		water()
	if str(time.strftime('%d-%m-%Y %H')) == date4:
		water()

	print "----------start----------"

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

	time.sleep(1)

	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

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

	#adds the data to the mysql table
	cursor.execute("INSERT INTO piplanter_table_17(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

	GPIO.output(NPNtrans, False) #turns the probes off

	#renders the image of the graph
	print "render start"
	os.system("php /opt/bitnami/wordpress/piplanter/renderScript.php") #renders the .png file
	print "render complete"

	#finds the newest image in the directory
	allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))
	newest = '/opt/bitnami/wordpress/piplanter/renders/'+allfiles[-1]
	print 'File for upload: ' + newest #prints location and file to console

	response = flickr.upload(filename=newest, title=sampleTime, format='etree') #uploads the file to flickr
	photoID = response.find('photoid').text #gets the id of the photo for constructing a url
	print 'Upload Successful, Photo ID: ' + photoID #more debug info

	#tweets the image and data
	send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+  str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' +'http://www.flickr.com/photos/97350286@N08/'+photoID +' - www.esologic.com/?p=643'  #builds the text of the tweet
	print "Tweeting:" , send  #for debug purposes
	api.update_status(send) #tweets the tweet

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

	print "-----------end-----------"

def water():

	print "===== Starting Watering Process ====="

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

	time.sleep(1)

	sensor1_before = readadc(0)
	sensor2_before = readadc(1)
	sensor3_before = readadc(2)
	sensor4_before = readadc(3)

	before = "WATERING START / Moisture Before - " + "Sensor 1:" + str(sensor1_before) + " Sensor 2:" + str(sensor2_before) + " Sensor 3:" + str(sensor3_before) + " Sensor 4:" + str(sensor4_before) + " - Average:" + str((float(sensor1_before+sensor2_before+sensor3_before+sensor4_before)/4))
	api.update_status(before)
	print before

	GPIO.output(pump, True)
	time.sleep(ontime)
	GPIO.output(pump, False)

	time.sleep(60) #gives the water time to penetrate the soil

	sensor1_after = readadc(0)
	sensor2_after = readadc(1)
	sensor3_after = readadc(2)
	sensor4_after = readadc(3)

	after = "WATERING COMPLETED / Moisture After - " + "Sensor 1:" + str(sensor1_after) + " Sensor 2:" + str(sensor2_after) + " Sensor 3:" + str(sensor3_after) + " Sensor 4:" + str(sensor4_after) + " - Average: " + str((float(sensor1_after+sensor2_after+sensor3_after+sensor4_after)/4))
	api.update_status(after)
	print after

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

	print "====== Watering Process Complete ====="
#water()
slowSample() #runs the sample once before the interval starts, mostly a debug function

scheduler = Scheduler(standalone=True)
scheduler.add_interval_job(slowSample, hours=1)
scheduler.start() #runs the program indefianately once every hour

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

import os

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)

pump = 7 #pin for the pump

GPIO.setup(pump, GPIO.OUT)

#the adc's SPI setup

import spidev

spi = spidev.SpiDev()

spi.open(0, 0)

#sets up the program's ability to write to a mysql database

import MySQLdb

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

cursor = con.cursor()

#tweepy setup, you must use the keys given to you when you create your app

import tweepy

consumer_key=""

consumer_secret=""

access_token=""

access_token_secret=""

#"logs in" to twitter,

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

auth.set_access_token(access_token, access_token_secret)

api = tweepy.API(auth)

#Flickr Setup

import flickrapi

api_key = ''

api_secret = ''

flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')

(token, frob) = flickr.get_token_part_one(perms='write')

if not token: raw_input("Press ENTER after you authorized this program")

flickr.get_token_part_two((token, frob))

#Variable Setup

ontime = 20

#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():

date0 = "21-06-2013 15"

date1 = "25-06-2013 12"

date2 = "29-06-2013 12"

date3 = "04-07-2013 12"

date4 = "06-07-2013 12"

if str(time.strftime('%d-%m-%Y %H')) == date0:

water()

if str(time.strftime('%d-%m-%Y %H')) == date1:

water()

if str(time.strftime('%d-%m-%Y %H')) == date2:

water()

if str(time.strftime('%d-%m-%Y %H')) == date3:

water()

if str(time.strftime('%d-%m-%Y %H')) == date4:

water()

print "----------start----------"

GPIO.output(NPNtrans, True)

GPIO.output(sampleLED, True)

time.sleep(1)

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

#prints debug info to console

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

#adds the data to the mysql table

cursor.execute("INSERT INTO piplanter_table_17(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

GPIO.output(NPNtrans, False) #turns the probes off

#renders the image of the graph

print "render start"

os.system("php /opt/bitnami/wordpress/piplanter/renderScript.php") #renders the .png file

print "render complete"

#finds the newest image in the directory

allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))

newest = '/opt/bitnami/wordpress/piplanter/renders/'+allfiles[-1]

print 'File for upload: ' + newest #prints location and file to console

response = flickr.upload(filename=newest, title=sampleTime, format='etree') #uploads the file to flickr

photoID = response.find('photoid').text #gets the id of the photo for constructing a url

print 'Upload Successful, Photo ID: ' + photoID #more debug info

#tweets the image and data

send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+ str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' +'http://www.flickr.com/photos/97350286@N08/'+photoID +' - www.esologic.com/?p=643' #builds the text of the tweet

print "Tweeting:" , send #for debug purposes

api.update_status(send) #tweets the tweet

time.sleep(.1)

GPIO.output(sampleLED, False)

print "-----------end-----------"

def water():

print "===== Starting Watering Process ====="

GPIO.output(NPNtrans, True)

GPIO.output(sampleLED, True)

time.sleep(1)

sensor1_before = readadc(0)

sensor2_before = readadc(1)

sensor3_before = readadc(2)

sensor4_before = readadc(3)

api.update_status(before)

print before

GPIO.output(pump, True)

time.sleep(ontime)

GPIO.output(pump, False)

time.sleep(60) #gives the water time to penetrate the soil

sensor1_after = readadc(0)

sensor2_after = readadc(1)

sensor3_after = readadc(2)

sensor4_after = readadc(3)

api.update_status(after)

print after

GPIO.output(NPNtrans, False)

GPIO.output(sampleLED, False)

print "====== Watering Process Complete ====="

#water()

slowSample() #runs the sample once before the interval starts, mostly a debug function

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(slowSample, hours=1)

scheduler.start() #runs the program indefianately once every hour

There you go! Essentially, every hour, the raspberry pi samples data from 4 humidity probes, an LDR and a tmp sensor. Once the sampling is complete, it dumps the data into a mysql database. From there the data is rendered into a graph using pChart in the form of a .png image. From there, that .png files is uploaded to flickr using this api. Once the file is uploaded, it returns it’s photo ID to the python script. From there, a tweet is built containing the brightness at the time of the tweet, the temperature at the time of the tweet, and the average moisture of the plants. It also uses the photo ID from flickr obtained earlier to build a URL leading to that image on flickr which it tweets as well. The final part of the tweet is a url that leads to this post! (taken from)

MySQL Database

The database is extremely simple, after installing MySQL set it up and create table that follows this syntax:

CREATE TABLE piplanter_table_17(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), mst1_V VARCHAR(100), mst2_V VARCHAR(100), mst3_V VARCHAR(100), mst4_V VARCHAR(100), pot1_V VARCHAR(100), ldr1_V VARCHAR(100), tmp1_F VARCHAR(100) );

1	CREATE TABLE piplanter_table_17(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), mst1_V VARCHAR(100), mst2_V VARCHAR(100), mst3_V VARCHAR(100), mst4_V VARCHAR(100), pot1_V VARCHAR(100), ldr1_V VARCHAR(100), tmp1_F VARCHAR(100) );

Pretty basic stuff, the table is just where the python script dumps the data every hour.

PChart Graph

The software driving the graphing part of the project is a bit of php graphing software called pchart. It allows me to graph mysql values from a table in a variety of ways. It is very important, and the code for the php script is as follows:

&lt;?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");

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

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

$Requete = "SELECT * FROM `piplanter_table_17`"; //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))
{
	$Time = $row["Time"];
	$myData-&gt;addPoints($Time,"Time");

	$mst1_V = $row["mst1_V"];
	$myData-&gt;addPoints($mst1_V,"mst1_V");
	$mst2_V = $row["mst2_V"];
	$myData-&gt;addPoints($mst2_V,"mst2_V");
	$mst3_V = $row["mst3_V"];
	$myData-&gt;addPoints($mst3_V,"mst3_V");
	$mst4_V = $row["mst4_V"];
	$myData-&gt;addPoints($mst4_V,"mst4_V");

	$ldr1_V = $row["ldr1_V"];
	$myData-&gt;addPoints($ldr1_V,"ldr1_V");

	$tmp1_F = $row["tmp1_F"];
	$myData-&gt;addPoints($tmp1_F,"tmp1_F");
}

$myData-&gt; setSerieOnAxis("tmp1_F", 0); //assigns the data to the frist axis
$myData-&gt; setAxisName(0, "Degrees F"); //adds the label to the first axis

$myData-&gt; setSerieOnAxis("ldr1_V", 1);
$myData-&gt; setAxisName(1, "LDR");

$myData-&gt; setSerieOnAxis("mst1_V", 2);
$myData-&gt; setSerieWeight("mst1_V",2);
$myData-&gt; setSerieOnAxis("mst2_V", 2);
$myData-&gt; setSerieOnAxis("mst3_V", 2);
$myData-&gt; setSerieOnAxis("mst4_V", 2);
$myData-&gt; setAxisName(2, "Relative Moisture");

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

$myData-&gt; setSerieWeight("mst1_V",1); //draws the line tickness
$myData-&gt;setPalette("mst1_V",array("R"=&gt;58,"G"=&gt;95,"B"=&gt;205,"Alpha"=&gt;80)); //sets the line color
$myData-&gt; setSerieWeight("mst2_V",1);
$myData-&gt;setPalette("mst2_V",array("R"=&gt;39,"G"=&gt;64,"B"=&gt;139,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst3_V",1);
$myData-&gt;setPalette("mst3_V",array("R"=&gt;0,"G"=&gt;34,"B"=&gt;102,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst4_V",1);
$myData-&gt;setPalette("mst4_V",array("R"=&gt;67,"G"=&gt;110,"B"=&gt;238,"Alpha"=&gt;80));

$myData-&gt; setSerieWeight("ldr1_V",2);
$myData-&gt; setSerieTicks("ldr1_V", 4);

$myData-&gt; setSerieWeight("tmp1_F",2);
$myData-&gt; setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(2000,500,$myData); /* Create a pChart object and associate your dataset */
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=&gt;6)); /* Choose a nice font */
$myPicture-&gt;setGraphArea(130,40,1900,300); /* Define the boundaries of the graph area */
$myPicture-&gt;drawScale(array("LabelRotation"=&gt;320)); /* Draw the scale, keep everything automatic */

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

/*The combination makes a cool looking graph*/
$myPicture-&gt;drawPlotChart();
$myPicture-&gt;drawLineChart();
$myPicture-&gt;drawLegend(30,320); //adds the legend

//$date-&gt; date("d-M-Y:H:i:s");

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

$myPicture-&gt;render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");

?&gt;

<?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");

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

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

mysql_select_db("piplanter", $db);

$Requete = "SELECT * FROM `piplanter_table_17`"; //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))

{

$Time = $row["Time"];

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

$mst1_V = $row["mst1_V"];

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

$mst2_V = $row["mst2_V"];

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

$mst3_V = $row["mst3_V"];

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

$mst4_V = $row["mst4_V"];

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

$ldr1_V = $row["ldr1_V"];

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

$tmp1_F = $row["tmp1_F"];

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

}

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

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

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

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

$myData-> setSerieOnAxis("mst1_V", 2);

$myData-> setSerieWeight("mst1_V",2);

$myData-> setSerieOnAxis("mst2_V", 2);

$myData-> setSerieOnAxis("mst3_V", 2);

$myData-> setSerieOnAxis("mst4_V", 2);

$myData-> setAxisName(2, "Relative Moisture");

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

$myData-> setSerieWeight("mst1_V",1); //draws the line tickness

$myData->setPalette("mst1_V",array("R"=>58,"G"=>95,"B"=>205,"Alpha"=>80)); //sets the line color

$myData-> setSerieWeight("mst2_V",1);

$myData->setPalette("mst2_V",array("R"=>39,"G"=>64,"B"=>139,"Alpha"=>80));

$myData-> setSerieWeight("mst3_V",1);

$myData->setPalette("mst3_V",array("R"=>0,"G"=>34,"B"=>102,"Alpha"=>80));

$myData-> setSerieWeight("mst4_V",1);

$myData->setPalette("mst4_V",array("R"=>67,"G"=>110,"B"=>238,"Alpha"=>80));

$myData-> setSerieWeight("ldr1_V",2);

$myData-> setSerieTicks("ldr1_V", 4);

$myData-> setSerieWeight("tmp1_F",2);

$myData-> setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(2000,500,$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(130,40,1900,300); /* Define the boundaries of the graph area */

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

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

/*The combination makes a cool looking graph*/

$myPicture->drawPlotChart();

$myPicture->drawLineChart();

$myPicture->drawLegend(30,320); //adds the legend

//$date-> date("d-M-Y:H:i:s");

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

$myPicture->render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");

As you may be able to guess, upon the calling of this script, the program looks for a table called “piplanter_table_17” and does a bunch of stuff as commented to produce a graph. This is what a sample graph looks like:

This is data taken over 6 days, and it’s a lot to look at, but it’s good stuff.

Twitter & Flickr Integration

As you hopefully derived from the python code, this project uses Twitter to send data to me. Instead of using an email server or sending sms messages, I decided on twitter because of a few reasons. I use the service constantly, so I won’t ever miss a tweet. The API seemed really easy to use (and it was!) and allowed more than one person to acess the data at any one time. I decided to use flickr as my image hosting service for a lot of the same reasons, but the main one was their 1TB storage per person. You’ve already seen a sample flickr upload, so here’s a sample tweet:

Brghtnss: 2% / Tmprtr: 71 Dg F / Avg Plnt Moisture: 33% Graph: http://t.co/hBuyNQkE7H – http://t.co/H2p1UJx59w

— eso’s rpi (@eso_rpi) June 27, 2013

That’s essentially it! Thank you for reading, and please ask questions.

PiPlanter | Bringing most of it together

June 13, 2013 / Leave a comment

Last night I finished the majority of the software for this project. Here’s a video of me going over what happened and what the program does in simpler terms:

Essentially, every hour, the raspberry pi samples data from 4 humidity probes, an LDR and a tmp sensor. Once the sampling is complete, it dumps the data into a mysql database. From there the data is rendered into a graph using pChart in the form of a .png image. From there, that .png files is uploaded to flickr using this api. Once the file is uploaded, it returns it’s photo ID to the python script. From there, a tweet is built containing the brightness at the time of the tweet, the temperature at the time of the tweet, and the average moisture of the plants. It also uses the photo ID from flickr obtained earlier to build a URL leading to that image on flickr which it tweets as well. The final part of the tweet is a url that leads to this post!

That was a lot of explanation, but this program does quite a bit. The source comes in two parts, here’s the python script that handles the brunt of the processing. You will need a bunch of libraries to run this, you could pick through past posts of mine to find what those are, but when I do a final post for this project I will include all of those.

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

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)

#sets up the program's ability to write to a mysql database
import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()

#tweepy setup, you must use the keys given to you when you create your app
import tweepy
consumer_key=""
consumer_secret=""
access_token=""
access_token_secret=""

#"logs in" to twitter,
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)

import flickrapi
#import xml.etree.ElementTree as ET

api_key = ''
api_secret = ''

flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')

(token, frob) = flickr.get_token_part_one(perms='write')
if not token: raw_input("Press ENTER after you authorized this program")
flickr.get_token_part_two((token, frob))

#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

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

	#adds the data to the mysql table
	cursor.execute("INSERT INTO piplanter_table_15(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

	GPIO.output(NPNtrans, False) #turns the probes off

	#renders the image of the graph
	print "render start"
	os.system("php /opt/bitnami/wordpress/piplanter/renderScript.php") #renders the .png file
	print "render complete"

	#finds the newest image in the directory
	allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))
	newest = '/opt/bitnami/wordpress/piplanter/renders/'+allfiles[-1]
	print 'File for upload: ' + newest #prints location and file to console

	response = flickr.upload(filename=newest, title=sampleTime, format='etree') #uploads the file to flickr
	photoID = response.find('photoid').text #gets the id of the photo for constructing a url
	print 'Upload Successful, Photo ID: ' + photoID #more debug info

	#tweets the image and data
	send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+  str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' +'http://www.flickr.com/photos/97350286@N08/'+photoID +' - www.esologic.com/?p=643'  #builds the text of the tweet
	print "Tweeting:" , send  #for debug purposes
	api.update_status(send) #tweets the tweet

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

slowSample() #runs the sample once before the interval starts, mostly a debug function

scheduler = Scheduler(standalone=True)
scheduler.add_interval_job(slowSample, hours=1)
scheduler.start() #runs the program indefianately once every hour

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

import os

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)

#sets up the program's ability to write to a mysql database

import MySQLdb

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

cursor = con.cursor()

#tweepy setup, you must use the keys given to you when you create your app

import tweepy

consumer_key=""

consumer_secret=""

access_token=""

access_token_secret=""

#"logs in" to twitter,

auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

auth.set_access_token(access_token, access_token_secret)

api = tweepy.API(auth)

import flickrapi

#import xml.etree.ElementTree as ET

api_key = ''

api_secret = ''

flickr = flickrapi.FlickrAPI(api_key, api_secret, format='json')

(token, frob) = flickr.get_token_part_one(perms='write')

if not token: raw_input("Press ENTER after you authorized this program")

flickr.get_token_part_two((token, frob))

#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

#prints debug info to console

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

#adds the data to the mysql table

cursor.execute("INSERT INTO piplanter_table_15(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

GPIO.output(NPNtrans, False) #turns the probes off

#renders the image of the graph

print "render start"

os.system("php /opt/bitnami/wordpress/piplanter/renderScript.php") #renders the .png file

print "render complete"

#finds the newest image in the directory

allfiles = sorted(os.listdir('/opt/bitnami/wordpress/piplanter/renders/'), key=lambda p: os.path.getctime(os.path.join('/opt/bitnami/wordpress/piplanter/renders/', p)))

newest = '/opt/bitnami/wordpress/piplanter/renders/'+allfiles[-1]

print 'File for upload: ' + newest #prints location and file to console

response = flickr.upload(filename=newest, title=sampleTime, format='etree') #uploads the file to flickr

photoID = response.find('photoid').text #gets the id of the photo for constructing a url

print 'Upload Successful, Photo ID: ' + photoID #more debug info

#tweets the image and data

send = 'Brghtnss: ' + str(format((((float(ldr1)/1024)*100)),'.0f')) + '% / ' + 'Tmprtr: ' + str(format(tmp1,'.0f')) + ' Dg F' + ' / Avg Plnt Moisture: '+ str(format(float((float((mst1+mst2+mst3+mst4)/4)/1024)*100),'.0f')) + '%' + ' Graph: ' +'http://www.flickr.com/photos/97350286@N08/'+photoID +' - www.esologic.com/?p=643' #builds the text of the tweet

print "Tweeting:" , send #for debug purposes

api.update_status(send) #tweets the tweet

time.sleep(.1)

GPIO.output(sampleLED, False)

slowSample() #runs the sample once before the interval starts, mostly a debug function

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(slowSample, hours=1)

scheduler.start() #runs the program indefianately once every hour

Here’s the .php script that renders the graph from the mysql data. It is called by the python script.

&lt;?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");

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

$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_15`"; //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))
{
	$Time = $row["Time"];
	$myData-&gt;addPoints($Time,"Time");

	$mst1_V = $row["mst1_V"];
	$myData-&gt;addPoints($mst1_V,"mst1_V");
	$mst2_V = $row["mst2_V"];
	$myData-&gt;addPoints($mst2_V,"mst2_V");
	$mst3_V = $row["mst3_V"];
	$myData-&gt;addPoints($mst3_V,"mst3_V");
	$mst4_V = $row["mst4_V"];
	$myData-&gt;addPoints($mst4_V,"mst4_V");

	$ldr1_V = $row["ldr1_V"];
	$myData-&gt;addPoints($ldr1_V,"ldr1_V");

	$tmp1_F = $row["tmp1_F"];
	$myData-&gt;addPoints($tmp1_F,"tmp1_F");
}

$myData-&gt; setSerieOnAxis("tmp1_F", 0); //assigns the data to the frist axis
$myData-&gt; setAxisName(0, "Degrees F"); //adds the label to the first axis

$myData-&gt; setSerieOnAxis("ldr1_V", 1);
$myData-&gt; setAxisName(1, "LDR");

$myData-&gt; setSerieOnAxis("mst1_V", 2);
$myData-&gt; setSerieWeight("mst1_V",2);
$myData-&gt; setSerieOnAxis("mst2_V", 2);
$myData-&gt; setSerieOnAxis("mst3_V", 2);
$myData-&gt; setSerieOnAxis("mst4_V", 2);
$myData-&gt; setAxisName(2, "Relative Moisture");

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

$myData-&gt; setSerieWeight("mst1_V",1); //draws the line tickness
$myData-&gt;setPalette("mst1_V",array("R"=&gt;58,"G"=&gt;95,"B"=&gt;205,"Alpha"=&gt;80)); //sets the line color
$myData-&gt; setSerieWeight("mst2_V",1);
$myData-&gt;setPalette("mst2_V",array("R"=&gt;39,"G"=&gt;64,"B"=&gt;139,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst3_V",1);
$myData-&gt;setPalette("mst3_V",array("R"=&gt;0,"G"=&gt;34,"B"=&gt;102,"Alpha"=&gt;80));
$myData-&gt; setSerieWeight("mst4_V",1);
$myData-&gt;setPalette("mst4_V",array("R"=&gt;67,"G"=&gt;110,"B"=&gt;238,"Alpha"=&gt;80));

$myData-&gt; setSerieWeight("ldr1_V",2);
$myData-&gt; setSerieTicks("ldr1_V", 4);

$myData-&gt; setSerieWeight("tmp1_F",2);
$myData-&gt; setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(2000,500,$myData); /* Create a pChart object and associate your dataset */
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=&gt;6)); /* Choose a nice font */
$myPicture-&gt;setGraphArea(130,40,1900,300); /* Define the boundaries of the graph area */
$myPicture-&gt;drawScale(array("LabelRotation"=&gt;320)); /* Draw the scale, keep everything automatic */

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

/*The combination makes a cool looking graph*/
$myPicture-&gt;drawPlotChart();
$myPicture-&gt;drawLineChart();
$myPicture-&gt;drawLegend(30,320); //adds the legend

//$date-&gt; date("d-M-Y:H:i:s");

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

$myPicture-&gt;render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");
?&gt;

<?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");

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

$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_15`"; //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))

{

$Time = $row["Time"];

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

$mst1_V = $row["mst1_V"];

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

$mst2_V = $row["mst2_V"];

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

$mst3_V = $row["mst3_V"];

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

$mst4_V = $row["mst4_V"];

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

$ldr1_V = $row["ldr1_V"];

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

$tmp1_F = $row["tmp1_F"];

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

}

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

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

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

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

$myData-> setSerieOnAxis("mst1_V", 2);

$myData-> setSerieWeight("mst1_V",2);

$myData-> setSerieOnAxis("mst2_V", 2);

$myData-> setSerieOnAxis("mst3_V", 2);

$myData-> setSerieOnAxis("mst4_V", 2);

$myData-> setAxisName(2, "Relative Moisture");

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

$myData-> setSerieWeight("mst1_V",1); //draws the line tickness

$myData->setPalette("mst1_V",array("R"=>58,"G"=>95,"B"=>205,"Alpha"=>80)); //sets the line color

$myData-> setSerieWeight("mst2_V",1);

$myData->setPalette("mst2_V",array("R"=>39,"G"=>64,"B"=>139,"Alpha"=>80));

$myData-> setSerieWeight("mst3_V",1);

$myData->setPalette("mst3_V",array("R"=>0,"G"=>34,"B"=>102,"Alpha"=>80));

$myData-> setSerieWeight("mst4_V",1);

$myData->setPalette("mst4_V",array("R"=>67,"G"=>110,"B"=>238,"Alpha"=>80));

$myData-> setSerieWeight("ldr1_V",2);

$myData-> setSerieTicks("ldr1_V", 4);

$myData-> setSerieWeight("tmp1_F",2);

$myData-> setSerieTicks("tmp1_F", 4);

$myPicture = new pImage(2000,500,$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(130,40,1900,300); /* Define the boundaries of the graph area */

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

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

/*The combination makes a cool looking graph*/

$myPicture->drawPlotChart();

$myPicture->drawLineChart();

$myPicture->drawLegend(30,320); //adds the legend

//$date-> date("d-M-Y:H:i:s");

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

$myPicture->render("/opt/bitnami/wordpress/piplanter/renders/".date("d-M-Y_H:i:s").".png");

Thanks for reading!

Ammo Box Speakers | Ordering Parts

June 13, 2013 / Leave a comment

It’s summer time and I just got a bunch of money for graduating so the next logical step is make a boom box.

I have already ordered the parts, so here’s my list and an explanation for each part:

Amp – This is the heart of the system. Essentially it’s a small amplifier that will run on 12v. According to the reviews it’s pretty loud. It will take a very standard 3.5mm audio input, or a dual channel analog signal which will be easy to build around.

Battery – Long time followers will know I have a pretty big charger that should be able handle charging this beast. It’s 12v, which is the amp runs on.

Speakers – I picked these mostly because if their compatibility with the amp, and their good reviews on amazon, and the fact that they come with a grill and mounting hardware.

Bluetooth Receiver – This is another “selling point” of the system. Users will play music over Bluetooth. It can be powered via 5v, and I have a spare switching regulator that I can use to power it.

Ammo Box Enclosure – This will house the project. It is big enough, and easy enough to cut into to mount the speakers into the side. It is also sealed, so getting sand in it won’t be that big of an issue for beach trips.

I’ll keep updating as parts come in.