Creature Capture | Stopping Raspivid After a Non-Predetermined Time

<p>One of the biggest problems with the built in commands for using the <a href="http://ift.tt/1zF9dCP" target="_blank">Raspberry Pi Camera module </a>is that you can’t stop a recording after an unknown time. You can record for a given number of seconds and that’s it. I have attempted to solve this problem by backgrounding the initial record process with a time of 27777.8 hours (99999999 seconds) when it’s time to stop recording, the process is manually killed using pkill.</p> <p>Here is a test of my code, which I’ve called CameraModulePlus (written in python) which takes two videos, one for five seconds, and one for ten seconds, with a 10 second delay in between.</p> <div id="crayon-57073a727194f634971728" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-mac print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-plain-button" title="Toggle Plain Code"></div> <div class="crayon-button crayon-wrap-button" title="Toggle Line Wrap"></div> <div class="crayon-button crayon-copy-button" title="Copy"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Python</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-57073a727194f634971728-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-2">2</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-4">4</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-6">6</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-8">8</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-10">10</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-12">12</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-14">14</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-16">16</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-18">18</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-57073a727194f634971728-20">20</div> <div class="crayon-num" data-line="crayon-57073a727194f634971728-21">21</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-57073a727194f634971728-1" class="crayon-line"><span class="crayon-st">from</span> <span class="crayon-e">CameraModulePlus</span> <span class="crayon-r">import</span> <span class="crayon-e">CameraModuleVideo</span></div> <div id="crayon-57073a727194f634971728-2" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">subprocess</span></div> <div id="crayon-57073a727194f634971728-3" class="crayon-line"><span class="crayon-st">from</span> <span class="crayon-k">time</span> <span class="crayon-r">import</span> <span class="crayon-e">sleep</span></div> <div id="crayon-57073a727194f634971728-4" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">time</span></div> <div id="crayon-57073a727194f634971728-5" class="crayon-line"></div> <div id="crayon-57073a727194f634971728-6" class="crayon-line crayon-striped-line"><span class="crayon-v">v1</span> <span class="crayon-o">=</span> <span class="crayon-e">CameraModuleVideo</span><span class="crayon-sy">(</span><span class="crayon-s">“/home/pi/CreatureCapture/”</span><span class="crayon-sy">,</span> <span class="crayon-s">“video1”</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-7" class="crayon-line"><span class="crayon-v">v2</span> <span class="crayon-o">=</span> <span class="crayon-e">CameraModuleVideo</span><span class="crayon-sy">(</span><span class="crayon-s">“/home/pi/CreatureCapture/”</span><span class="crayon-sy">,</span> <span class="crayon-s">“video2”</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-8" class="crayon-line crayon-striped-line"></div> <div id="crayon-57073a727194f634971728-9" class="crayon-line"><span class="crayon-st">try</span><span class="crayon-o">:</span></div> <div id="crayon-57073a727194f634971728-10" class="crayon-line crayon-striped-line"><span class="crayon-v">v1</span><span class="crayon-sy">.</span><span class="crayon-e">startRecording</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-11" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">5</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-12" class="crayon-line crayon-striped-line"><span class="crayon-v">v1</span><span class="crayon-sy">.</span><span class="crayon-e">stopRecording</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-13" class="crayon-line"></div> <div id="crayon-57073a727194f634971728-14" class="crayon-line crayon-striped-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">10</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-15" class="crayon-line"></div> <div id="crayon-57073a727194f634971728-16" class="crayon-line crayon-striped-line"><span class="crayon-v">v2</span><span class="crayon-sy">.</span><span class="crayon-e">startRecording</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-17" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">10</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-18" class="crayon-line crayon-striped-line"><span class="crayon-v">v2</span><span class="crayon-sy">.</span><span class="crayon-e">stopRecording</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-57073a727194f634971728-19" class="crayon-line"></div> <div id="crayon-57073a727194f634971728-20" class="crayon-line crayon-striped-line"><span class="crayon-st">except</span> <span class="crayon-k">ValueError</span> <span class="crayon-st">as</span> <span class="crayon-v">e</span><span class="crayon-o">:</span></div> <div id="crayon-57073a727194f634971728-21" class="crayon-line"><span class="crayon-k">print</span><span class="crayon-sy">(</span><span class="crayon-v">e</span><span class="crayon-sy">)</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Here is a result of the 5 second duration test:</p> <div class="ezAdsense adsense adsense-midtext" style="text-align:center;margin:12px;"><script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js" type="text/javascript"> </script> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-2979805726071943" data-ad-slot="7471922310" data-ad-format="auto"></ins> <script type="text/javascript"> //<![CDATA[ (adsbygoogle = window.adsbygoogle || []).push({}); //]]> </script></div> <p><iframe width="678" height="381" src="https://www.youtube.com/embed/8MPRylqqxr4?feature=oembed" frameborder="0" allowfullscreen=""></iframe></p> <p> </p> <p>Here is a result of the 10 second duration test:</p> <p><iframe width="678" height="381" src="https://www.youtube.com/embed/N3yThiJD5nw?feature=oembed" frameborder="0" allowfullscreen=""></iframe></p> <p><span style="font-family: 'Source Sans Pro'; font-size: 18px; line-height: 27px;"> </span></p> <div id="huge-it-share-buttons-top" class="huge-it-share-buttons nobackground"> <h3>Share This:</h3> <ul class="huge-it-share-buttons-list"> <li class=" nobackground"><a href="http://ift.tt/1LIxY7s" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1LIxY7s','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -0px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="https://twitter.com/share?status=http://yoursmart.mobi/feed&text=Creature%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('https://twitter.com/share?status=http://yoursmart.mobi/feed&text=Creature Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -30px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1NcClmj%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcClmj Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -60px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxZZ0" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1LIxZZ0','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -90px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1WgK75Y%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time&mini=true&url=http://ift.tt/1LIxZZ4" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK75Y Capture | Stopping Raspivid After a Non-Predetermined Time&mini=true&url=http://ift.tt/1LIxZZ4','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -120px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1NcCje7%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcCje7 Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -150px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1WgK8a1%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK8a1 Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -180px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1NcClmn%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcClmn Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -210px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxY7u" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1LIxY7u','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -240px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1WgK8a3%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK8a3 Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -270px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1NcCjeb%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcCjeb Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -300px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTq" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1o7SuTq','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -330px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1WgK8a9%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK8a9 Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -360px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTs" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1o7SuTs','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -390px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1NcClmr%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcClmr Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -420px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1WgK8ad%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time&pic=&ralateUid=&" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK8ad Capture | Stopping Raspivid After a Non-Predetermined Time&pic=&ralateUid=&','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -450px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1NcClmv%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1NcClmv Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -480px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1WgK769%20Capture%20|%20Stopping%20Raspivid%20After%20a%20Non-Predetermined%20Time" id="backforunical464" name="backforunical464" onclick="javascript:void window.open('http://ift.tt/1WgK769 Capture | Stopping Raspivid After a Non-Predetermined Time','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -510px -120px" target="_blank"></a></li> </ul> <div class="clear"></div> </div> View more at: <a href="http://yoursmart.mobi/">http://yoursmart.mobi</a>

Creature Capture | Stopping Raspivid After a Non-Predetermined Time

One of the biggest problems with the built in commands for using the  Raspberry Pi Camera module  is that you can’t stop a recording after a...

Read more »

NODE.JS AND EXPRESS – CREATING A REST API

<p>Once you learn a little bit of Node.js you find that modules make life much easier. One of the most popular and useful is <a href="http://expressjs.com/" target="_blank">Express</a>. It carries a lot of similarities to the Ruby framework, <a href="http://ift.tt/qy3LV3" target="_blank">Sinatra</a>. This makes it a great tool for building REST APIs. This article will teach how to use Express and build a basic REST API.</p> <h2>Installing Express npm Module</h2> <p>The first thing we need to do is install the Express module. This can be done a couple different ways.</p> <p>The first method is updating your package.json file (or creating one) with the dependency for Express. The updates to the package.json will look similar to below.</p> <pre> <code class="rainbow" data-language="javascript">{ <span class="string">"name"</span>: <span class="string">"first-express-app"</span>, <span class="string">"description"</span>: <span class="string">"a fine piece of express art"</span>, <span class="string">"version"</span>: <span class="string">"0.0.1"</span>, <span class="string">"dependencies"</span>: { <span class="string">"express"</span>: <span class="string">"3.x"</span> } }</code> </pre> <p>Once the package.json file is updated you’ll need to run the npm installation.</p> <pre> <code class="rainbow" data-language="shell">npm install</code> </pre> <p>The second method is useful if you’ve already got a package.json file. You can use a lesser known option on npm install to <a href="http://ift.tt/1UDKUyD" itemprop="url" target="_bank" title="How to automatically water your plants with the Raspberry Pi"><strong>automatically</strong></a> update your package.json – the save option.</p> <pre> <code class="rainbow" data-language="shell">npm install express <span class="keyword operator">-</span><span class="keyword operator">-</span>save</code> </pre> <p>The project directory will now have a node_modules folder and inside it will be an express folder. Your application is now setup to start building.</p> <h2>First Application</h2> <p>To get rolling let’s build a very simple application to get familiar with the syntax of Express. This means creating a main file, in this case app.js.</p> <p>The start of the file needs to include the express module using a require statement. Once included you can invoke it as a function which will return an <a href="http://ift.tt/1RHealv" target="_blank">Express server instance</a>. This application instance will allow you to configure and add routes.</p> <pre> <code class="rainbow" data-language="javascript"><span class="keyword">var</span> express <span class="keyword operator">=</span> <span class="function call">require</span>(<span class="string">'express'</span>); <span class="keyword">var</span> app <span class="keyword operator">=</span> <span class="function call">express</span>();</code> </pre> <p>The next step is to add a route. This is a url that can be retrieved in the application. You build a route by calling app.METHOD where METHOD is an acceptable HTTP method like “get”. The route is passed the url that will be accessed, such as ‘/’ or the site root. The second parameter to a route is a callback to call when the url is retrieved.</p> <p>The route callback takes in a req (<a href="http://ift.tt/1sbsimp" target="_blank">request</a>) and res (<a href="http://ift.tt/HdmkOU" target="_blank">response</a>) which are modified versions of the objects passed to the core <a href="http://ift.tt/1S0kZ0c" target="_blank">request event</a>. Express adds functionality to both objects but for this exercise we’ll concentrate on the response object.</p> <p>With the response object the following code will do two things. It will set the content type header (Content-Type) using the res.type function. A text response will be sent back using res.send which will <a href="http://ift.tt/1Vc0TUk" itemprop="url" target="_bank" title="Automatically watering your plants with sensors, a Pi and webhooks"><strong>automatically</strong></a> set the content length header (Content-Length).</p> <pre> <code class="rainbow" data-language="javascript"><span class="keyword">var</span> express <span class="keyword operator">=</span> <span class="function call">require</span>(<span class="string">'express'</span>); <span class="keyword">var</span> app <span class="keyword operator">=</span> <span class="function call">express</span>(); app.<span class="function call">get</span>(<span class="string">'/'</span>, <span class="keyword">function</span>(req, res) { res.<span class="function call">type</span>(<span class="string">'text/plain'</span>); res.<span class="function call">send</span>(<span class="string">'i am a beautiful butterfly'</span>); });</code> </pre> <p>The final thing we need to do in this simple example is have the app listen for incoming requests. This is done using the aptly named listen function. This function will take any valid parameters that you can pass in to the regular <a href="http://ift.tt/1dvM206" target="_blank">http server</a>. In order to make it easy to change the port and support deploying to platforms like<a href="http://modulus.io/" target="_blank">Modulus</a> the port will be set to process.env.PORT or 4730 (a random port I chose). The process.env.PORT means if the PORT environment variable is passed in it will use it. This wraps up the basic app.</p> <p>first.js</p> <pre> <code class="rainbow" data-language="javascript"><span class="keyword">var</span> express <span class="keyword operator">=</span> <span class="function call">require</span>(<span class="string">'express'</span>); <span class="keyword">var</span> app <span class="keyword operator">=</span> <span class="function call">express</span>(); app.<span class="function call">get</span>(<span class="string">'/'</span>, <span class="keyword">function</span>(req, res) { res.<span class="function call">type</span>('text<span class="string regexp"><span class="string regexp open">/</span>plain'); /<span class="string regexp close">/</span></span> set content<span class="keyword operator">-</span>type res.<span class="function call">send</span>(<span class="string">'i am a beautiful butterfly'</span>); <span class="comment">// send text response</span> }); app.<span class="function call">listen</span>(process.env.PORT <span class="keyword operator">|</span><span class="keyword operator">|</span> <span class="constant numeric">4730</span>);</code> </pre> <p>You can test this by running the file using:</p> <pre> <code class="rainbow" data-language="shell">node app.js</code> </pre> <p>Then you may go to <a href="http://localhost:4730/" target="_blank">http://localhost:4730</a> in your browser and if all went well you’ll see ‘i am a beautiful butterfly’.</p> <h2>Basic REST API</h2> <div class="ezAdsense adsense adsense-midtext" style="text-align:center;margin:12px;"><script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js" type="text/javascript"> </script> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-2979805726071943" data-ad-slot="7471922310" data-ad-format="auto"></ins> <script type="text/javascript"> //<![CDATA[ (adsbygoogle = window.adsbygoogle || []).push({}); //]]> </script></div> <p>Now that we have a very basic express application we can dive into a more complex application. If you need more information on what a RESTful API is check out the<a href="http://ift.tt/1S0l0kM" target="_blank">Wikipedia article</a>.</p> <p>REST APIs are made up of four method types, GET, PUT, POST, and DELETE and with Express we can easily do them all. For the rest of this article we’re going to build a simple API that allows you to get and save quotes.</p> <p>To get started we’ll start with a basic Express application that just has an array of quotes. Each quote is an object with the author and text.</p> <p>quote.js</p> <pre> <code class="rainbow" data-language="javascript"><span class="keyword">var</span> express <span class="keyword operator">=</span> <span class="function call">require</span>(<span class="string">'express'</span>); <span class="keyword">var</span> app <span class="keyword operator">=</span> <span class="function call">express</span>(); <span class="keyword">var</span> quotes <span class="keyword operator">=</span> [ { author : <span class="string">'Audrey Hepburn'</span>, text : <span class="string">"Nothing is impossible, the word itself says 'I'm possible'!"</span>}, { author : <span class="string">'Walt Disney'</span>, text : <span class="string">"You may not realize it when it happens, but a kick in the teeth may be the best thing in the world for you"</span>}, { author : <span class="string">'Unknown'</span>, text : <span class="string">"Even the greatest was once a beginner. Don't be afraid to take that first step."</span>}, { author : <span class="string">'Neale Donald Walsch'</span>, text : <span class="string">"You are afraid to die, and you're afraid to live. What a way to exist."</span>} ]; app.<span class="function call">listen</span>(process.env.PORT <span class="keyword operator">|</span><span class="keyword operator">|</span> <span class="constant numeric">3412</span>);</code> </pre> <p>Now you’ll notice that this doesn’t really do anything. So let’s add a route to return all of the quotes in our array. Now, this is going to be really easy. We’re going to take advantage of a <a href="http://ift.tt/1RHe8tJ" target="_blank">helper function on the response object</a>, to send a json object.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="function call">get</span>(<span class="string">'/'</span>, <span class="keyword">function</span>(req, res) { res.<span class="function call">json</span>(quotes); });</code> </pre> <p>Let’s add the ability to retrieve a random quote. This, again, shouldn’t be hard addition. We’ll add a new route ‘/quote/random’; then we’ll calculate a random index, grab the quote, and return it.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="function call">get</span>(<span class="string">'/quote/random'</span>, <span class="keyword">function</span>(req, res) { <span class="keyword">var</span> id <span class="keyword operator">=</span> Math.<span class="function call">floor</span>(Math.<span class="function call">random</span>() <span class="keyword operator">*</span> quotes.<span class="support property">length</span>); <span class="keyword">var</span> q <span class="keyword operator">=</span> quotes[id]; res.<span class="function call">json</span>(q); });</code> </pre> <p>The next thing we’ll add in there is the ability to grab a single quote. The way you do this is by adding a “:param” to the route, so the route will look like “/quote/:id” and the id will be available using <a href="http://ift.tt/1l9Obic" target="_blank">req.params</a>.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="function call">get</span>(<span class="string">'/quote/:id'</span>, <span class="keyword">function</span>(req, res) { <span class="keyword">if</span>(quotes.<span class="support property">length</span> <span class="keyword operator"><</span><span class="keyword operator">=</span> req.params.id <span class="keyword operator">|</span><span class="keyword operator">|</span> req.params.id <span class="keyword operator"><</span> <span class="constant numeric">0</span>) { res.statusCode <span class="keyword operator">=</span> <span class="constant numeric">404</span>; <span class="keyword">return</span> res.<span class="function call">send</span>(<span class="string">'Error 404: No quote found'</span>); } <span class="keyword">var</span> q <span class="keyword operator">=</span> quotes[req.params.id]; res.<span class="function call">json</span>(q); });</code> </pre> <p>In the above the code you can see that we first check to make sure that the id requested is in the range of quotes we have. If no then we return a 404 error, meaning that the quote wasn’t found. In theory we’d probably return a nice error object in this case. If the request is good then we return the result found based on the id.</p> <p>One item to note is that since we have “/quote/random” and “/quote/:id” we have to put the random route first. Why you ask? Well, this is because routes are checked in order and if it was the other way around “random” would be treated like an id.</p> <p>So, I’m guessing you’ll want to be able to dynamically add quotes to the array. This will be done using a POST method to the API, this is done using <a href="http://ift.tt/O99t0Q" target="_blank">app.post</a>. The POST should have a JSON object for the new quote.</p> <p>In order to get the body from a POST in express we have to add a piece of middleware to our application. This is done using <a href="http://ift.tt/1S0l0kQ" target="_blank">bodyParser middleware</a>. Body parser will pretty much do what it sounds like – parse the body of the request and then it sets the body property on the request object.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="function call">use</span>(express.<span class="function call">bodyParser</span>());</code> </pre> <p>The above should be added to the top of the application before we add any routes.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="function call">post</span>(<span class="string">'/quote'</span>, <span class="keyword">function</span>(req, res) { <span class="keyword">if</span>(<span class="keyword operator">!</span>req.body.<span class="function call">hasOwnProperty</span>(<span class="string">'author'</span>) <span class="keyword operator">|</span><span class="keyword operator">|</span> <span class="keyword operator">!</span>req.body.<span class="function call">hasOwnProperty</span>(<span class="string">'text'</span>)) { res.statusCode <span class="keyword operator">=</span> <span class="constant numeric">400</span>; <span class="keyword">return</span> res.<span class="function call">send</span>(<span class="string">'Error 400: Post syntax incorrect.'</span>); } <span class="keyword">var</span> newQuote <span class="keyword operator">=</span> { author : req.body.author, text : req.body.text }; quotes.<span class="support method">push</span>(newQuote); res.<span class="function call">json</span>(<span class="constant language">true</span>); });</code> </pre> <p>At the beginning of our route function we check to make sure the body has both the “author” and “text” properties. If they don’t exist then we return an error. If the request is fine then we add it to our quotes and push back a true response.</p> <p>The last thing thing we’ll add is the ability to delete a response. This will be achieved using the DELETE method.</p> <pre> <code class="rainbow" data-language="javascript">app.<span class="keyword">delete</span>(<span class="string">'/quote/:id'</span>, <span class="keyword">function</span>(req, res) { <span class="keyword">if</span>(quotes.<span class="support property">length</span> <span class="keyword operator"><</span><span class="keyword operator">=</span> req.params.id) { res.statusCode <span class="keyword operator">=</span> <span class="constant numeric">404</span>; <span class="keyword">return</span> res.<span class="function call">send</span>(<span class="string">'Error 404: No quote found'</span>); } quotes.<span class="function call">splice</span>(req.params.id, <span class="constant numeric">1</span>); res.<span class="function call">json</span>(<span class="constant language">true</span>); });</code> </pre> <p>The above function starts by checking the length of our quotes to make sure we don’t try to delete something that isn’t there. If no error we <a href="http://ift.tt/1dGCC0m" target="_blank">splice</a> the array to remove the quote and return true to the client.</p> <p>That pretty much covers the basics. Now, this is only a drop in the bucket of what Express has and can do. The entire project and source code for this is available <a href="http://ift.tt/1S0l0kS" target="_blank">on GitHub</a>. Feel free to leave any questions below.</p> <div id="huge-it-share-buttons-top" class="huge-it-share-buttons nobackground"> <h3>Share This:</h3> <ul class="huge-it-share-buttons-list"> <li class=" nobackground"><a href="http://ift.tt/1LIxY7s" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1LIxY7s','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -0px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="https://twitter.com/share?status=http://yoursmart.mobi/feed&text=NODE.JS%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('https://twitter.com/share?status=http://yoursmart.mobi/feed&text=NODE.JS AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -30px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1RHeaBO%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHeaBO AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -60px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxZZ0" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1LIxZZ0','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -90px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1RHe8tM%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API&mini=true&url=http://ift.tt/1LIxZZ4" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHe8tM AND EXPRESS – CREATING A REST API&mini=true&url=http://ift.tt/1LIxZZ4','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -120px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1RHe8tO%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHe8tO AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -150px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1S0l0kU%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1S0l0kU AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -180px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1RHeaBS%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHeaBS AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -210px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxY7u" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1LIxY7u','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -240px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1RHeaBU%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHeaBU AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -270px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1S0l0kW%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1S0l0kW AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -300px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTq" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1o7SuTq','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -330px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1S0kZ0j%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1S0kZ0j AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -360px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTs" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1o7SuTs','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -390px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1S0l0l0%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1S0l0l0 AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -420px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1RHe8tU%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API&pic=&ralateUid=&" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHe8tU AND EXPRESS – CREATING A REST API&pic=&ralateUid=&','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -450px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1S0l0Bf%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1S0l0Bf AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -480px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1RHebpk%20AND%20EXPRESS%20%E2%80%93%20CREATING%20A%20REST%20API" id="backforunical460" name="backforunical460" onclick="javascript:void window.open('http://ift.tt/1RHebpk AND EXPRESS – CREATING A REST API','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -510px -120px" target="_blank"></a></li> </ul> <div class="clear"></div> </div> View more at: <a href="http://yoursmart.mobi/">http://yoursmart.mobi</a>

NODE.JS AND EXPRESS – CREATING A REST API

Once you learn a little bit of Node.js you find that modules make life much easier. One of the most popular and useful is Express . It carri...

Read more »

PiPlanter | Graphing timed mysql data with pchart

<p>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.</p> <p>First, get the php5-gd package by running:</p> <div id="crayon-5706bac752006389554019" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Shell</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706bac752006389554019-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706bac752006389554019-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">php5</span><span class="crayon-o">–</span><span class="crayon-v">gd</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Then download, rename and move the pChart files to the proper directory:</p> <div id="crayon-5706bac752011885372437" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Shell</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706bac752011885372437-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752011885372437-2">2</div> <div class="crayon-num" data-line="crayon-5706bac752011885372437-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752011885372437-4">4</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706bac752011885372437-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-r">mkdir</span> <span class="crayon-o">/</span><span class="crayon-v">srv</span><span class="crayon-o">/</span><span class="crayon-v">www</span><span class="crayon-o">/</span><span class="crayon-v">lib</span><span class="crayon-o">/</span></div> <div id="crayon-5706bac752011885372437-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-e">wget</span> <span class="crayon-v">http</span><span class="crayon-o">:</span><span class="crayon-o">/</span><span class="crayon-o">/</span><span class="crayon-v">www</span><span class="crayon-e">.pchart</span><span class="crayon-e">.net</span><span class="crayon-o">/</span><span class="crayon-v">release</span><span class="crayon-o">/</span><span class="crayon-v">pChart2</span><span class="crayon-sy">.</span><span class="crayon-cn">1.3.tar.gz</span></div> <div id="crayon-5706bac752011885372437-3" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">tar</span> <span class="crayon-o">–</span><span class="crayon-e">xzvf</span> <span class="crayon-v">pChart2</span><span class="crayon-sy">.</span><span class="crayon-cn">1.3.tar.gz</span></div> <div id="crayon-5706bac752011885372437-4" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-r">mv</span> <span class="crayon-v">pChart2</span><span class="crayon-sy">.</span><span class="crayon-cn">1.3</span> <span class="crayon-v">pChart</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Now pChart is ready to be used.</p> <p>I used a lot of the info found here:</p> <div class="ezAdsense adsense adsense-midtext" style="text-align:center;margin:12px;"><script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js" type="text/javascript"> </script> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-2979805726071943" data-ad-slot="7471922310" data-ad-format="auto"></ins> <script type="text/javascript"> //<![CDATA[ (adsbygoogle = window.adsbygoogle || []).push({}); //]]> </script></div> <p><a href="http://ift.tt/20bJuL6" target="_blank">http://ift.tt/20bJuL6</a></p> <p><a href="http://ift.tt/1WfKNZw" target="_blank">http://ift.tt/1WfKNZw</a></p> <p>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 <a href="http://ift.tt/25HSsUs" itemprop="url" target="_bank" title="Controlling DC Motors Using Python With a Raspberry Pi"><strong>python</strong></a> script seen in <a href="http://ift.tt/20bJuL8" target="_blank">this</a> post) and after leaving it on in my room for like 3 days, render this graph:</p> <p><a href="http://ift.tt/1WfKOfL" target="_blank"><img alt="" class="aligncenter wp-image-580" height="180" src="http://ift.tt/1WfKOfL" width="660" /></a></p> <p>Here’s that php script:</p> <div id="crayon-5706bac752017554634927" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">PHP</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706bac752017554634927-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-2">2</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-4">4</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-6">6</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-8">8</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-10">10</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-12">12</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-14">14</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-16">16</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-18">18</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-20">20</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-21">21</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-22">22</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-23">23</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-24">24</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-25">25</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-26">26</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-27">27</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-28">28</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-29">29</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-30">30</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-31">31</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-32">32</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-33">33</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-34">34</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-35">35</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-36">36</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-37">37</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-38">38</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-39">39</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-40">40</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-41">41</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-42">42</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-43">43</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-44">44</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-45">45</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-46">46</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-47">47</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-48">48</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-49">49</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-50">50</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-51">51</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-52">52</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-53">53</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-54">54</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-55">55</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-56">56</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-57">57</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-58">58</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-59">59</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-60">60</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-61">61</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706bac752017554634927-62">62</div> <div class="crayon-num" data-line="crayon-5706bac752017554634927-63">63</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706bac752017554634927-1" class="crayon-line"><span class="crayon-ta"><?php</span></div> <div id="crayon-5706bac752017554634927-2" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-3" class="crayon-line"><span class="crayon-c">/* Include all the classes */</span></div> <div id="crayon-5706bac752017554634927-4" class="crayon-line crayon-striped-line"><span class="crayon-k">include</span><span class="crayon-sy">(</span><span class="crayon-s">“/srv/www/lib/pChart/class/pData.class.php”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-5" class="crayon-line"><span class="crayon-k">include</span><span class="crayon-sy">(</span><span class="crayon-s">“/srv/www/lib/pChart/class/pDraw.class.php”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-6" class="crayon-line crayon-striped-line"><span class="crayon-k">include</span><span class="crayon-sy">(</span><span class="crayon-s">“/srv/www/lib/pChart/class/pImage.class.php”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-7" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-8" class="crayon-line crayon-striped-line"><span class="crayon-c">/* Create your dataset object */</span></div> <div id="crayon-5706bac752017554634927-9" class="crayon-line"><span class="crayon-v">$myData</span> <span class="crayon-o">=</span> <span class="crayon-r">new</span> <span class="crayon-e">pData</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-10" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-11" class="crayon-line"><span class="crayon-v">$db</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_connect</span><span class="crayon-sy">(</span><span class="crayon-s">“localhost”</span><span class="crayon-sy">,</span> <span class="crayon-s">“piplanter_user”</span><span class="crayon-sy">,</span> <span class="crayon-s">“piplanter_pass”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//location of server, db username, db pass</span></div> <div id="crayon-5706bac752017554634927-12" class="crayon-line crayon-striped-line"><span class="crayon-e">mysql_select_db</span><span class="crayon-sy">(</span><span class="crayon-s">“piplanter”</span><span class="crayon-sy">,</span> <span class="crayon-v">$db</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-13" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-14" class="crayon-line crayon-striped-line"><span class="crayon-v">$Requete</span> <span class="crayon-o">=</span> <span class="crayon-s">“SELECT * FROM `piplanter_table_05`”</span><span class="crayon-sy">;</span> <span class="crayon-c">//table name</span></div> <div id="crayon-5706bac752017554634927-15" class="crayon-line"><span class="crayon-v">$Result</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_query</span><span class="crayon-sy">(</span><span class="crayon-v">$Requete</span><span class="crayon-sy">,</span> <span class="crayon-v">$db</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-16" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-17" class="crayon-line"><span class="crayon-c">/*This fetches the data from the mysql database, and adds it to pchart as points*/</span></div> <div id="crayon-5706bac752017554634927-18" class="crayon-line crayon-striped-line"><span class="crayon-st">while</span><span class="crayon-sy">(</span><span class="crayon-v">$row</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_fetch_array</span><span class="crayon-sy">(</span><span class="crayon-v">$Result</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span></div> <div id="crayon-5706bac752017554634927-19" class="crayon-line"><span class="crayon-sy">{</span></div> <div id="crayon-5706bac752017554634927-20" class="crayon-line crayon-striped-line"><span class="crayon-c">//$Sample_Number = $row[“Sample_Number”]; //Not using this data</span></div> <div id="crayon-5706bac752017554634927-21" class="crayon-line"><span class="crayon-c">//$myData->addPoints($Sample_Number,”Sample_Number”);</span></div> <div id="crayon-5706bac752017554634927-22" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-23" class="crayon-line"><span class="crayon-v">$Time</span> <span class="crayon-o">=</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">“Time”</span><span class="crayon-sy">]</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-24" class="crayon-line crayon-striped-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span><span class="crayon-e">addPoints</span><span class="crayon-sy">(</span><span class="crayon-v">$Time</span><span class="crayon-sy">,</span><span class="crayon-s">“Time”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-25" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-26" class="crayon-line crayon-striped-line"><span class="crayon-v">$Temp_F</span> <span class="crayon-o">=</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">“Temp_F”</span><span class="crayon-sy">]</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-27" class="crayon-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span><span class="crayon-e">addPoints</span><span class="crayon-sy">(</span><span class="crayon-v">$Temp_F</span><span class="crayon-sy">,</span><span class="crayon-s">“Temp_F”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-28" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-29" class="crayon-line"><span class="crayon-v">$LDR_V</span> <span class="crayon-o">=</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">“LDR_V”</span><span class="crayon-sy">]</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-30" class="crayon-line crayon-striped-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span><span class="crayon-e">addPoints</span><span class="crayon-sy">(</span><span class="crayon-v">$LDR_V</span><span class="crayon-sy">,</span><span class="crayon-s">“LDR_V”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-31" class="crayon-line"><span class="crayon-sy">}</span></div> <div id="crayon-5706bac752017554634927-32" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-33" class="crayon-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span> <span class="crayon-e">setSerieOnAxis</span><span class="crayon-sy">(</span><span class="crayon-s">“Temp_F”</span><span class="crayon-sy">,</span> <span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//assigns the data to the frist axis</span></div> <div id="crayon-5706bac752017554634927-34" class="crayon-line crayon-striped-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span> <span class="crayon-e">setAxisName</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">,</span> <span class="crayon-s">“Temperature”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//adds the label to the first axis</span></div> <div id="crayon-5706bac752017554634927-35" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-36" class="crayon-line crayon-striped-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span> <span class="crayon-e">setSerieOnAxis</span><span class="crayon-sy">(</span><span class="crayon-s">“LDR_V”</span><span class="crayon-sy">,</span> <span class="crayon-cn">1</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-37" class="crayon-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span> <span class="crayon-e">setAxisName</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">,</span> <span class="crayon-s">“LDR”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-38" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-39" class="crayon-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span> <span class="crayon-e">setAxisPosition</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">,</span><span class="crayon-cn">AXIS_POSITION_LEFT</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//moves the second axis to the far left</span></div> <div id="crayon-5706bac752017554634927-40" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-41" class="crayon-line"><span class="crayon-v">$myData</span><span class="crayon-o">-></span><span class="crayon-e">setAbscissa</span><span class="crayon-sy">(</span><span class="crayon-s">“Time”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//sets the time data set as the x axis label</span></div> <div id="crayon-5706bac752017554634927-42" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-43" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-44" class="crayon-line crayon-striped-line"><span class="crayon-v">$myPicture</span> <span class="crayon-o">=</span> <span class="crayon-r">new</span> <span class="crayon-e">pImage</span><span class="crayon-sy">(</span><span class="crayon-cn">1100</span><span class="crayon-sy">,</span><span class="crayon-cn">300</span><span class="crayon-sy">,</span><span class="crayon-v">$myData</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">/* Create a pChart object and associate your dataset */</span></div> <div id="crayon-5706bac752017554634927-45" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-46" class="crayon-line crayon-striped-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">setFontProperties</span><span class="crayon-sy">(</span><span class="crayon-t">array</span><span class="crayon-sy">(</span><span class="crayon-s">“FontName”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-s">“/srv/www/lib/pChart/fonts/pf_arma_five.ttf”</span><span class="crayon-sy">,</span><span class="crayon-s">“FontSize”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">6</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">/* Choose a nice font */</span></div> <div id="crayon-5706bac752017554634927-47" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-48" class="crayon-line crayon-striped-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">setGraphArea</span><span class="crayon-sy">(</span><span class="crayon-cn">80</span><span class="crayon-sy">,</span><span class="crayon-cn">40</span><span class="crayon-sy">,</span><span class="crayon-cn">1000</span><span class="crayon-sy">,</span><span class="crayon-cn">200</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">/* Define the boundaries of the graph area */</span></div> <div id="crayon-5706bac752017554634927-49" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-50" class="crayon-line crayon-striped-line"><span class="crayon-v">$Settings</span> <span class="crayon-o">=</span> <span class="crayon-t">array</span><span class="crayon-sy">(</span><span class="crayon-s">“R”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">250</span><span class="crayon-sy">,</span> <span class="crayon-s">“G”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">250</span><span class="crayon-sy">,</span> <span class="crayon-s">“B”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">250</span><span class="crayon-sy">,</span> <span class="crayon-s">“Dash”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">1</span><span class="crayon-sy">,</span> <span class="crayon-s">“DashR”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">0</span><span class="crayon-sy">,</span> <span class="crayon-s">“DashG”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">0</span><span class="crayon-sy">,</span> <span class="crayon-s">“DashB”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-51" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-52" class="crayon-line crayon-striped-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">drawScale</span><span class="crayon-sy">(</span><span class="crayon-t">array</span><span class="crayon-sy">(</span><span class="crayon-s">“LabelRotation”</span><span class="crayon-o">=</span><span class="crayon-o">></span><span class="crayon-cn">320</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">/* Draw the scale, keep everything automatic */</span></div> <div id="crayon-5706bac752017554634927-53" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-54" class="crayon-line crayon-striped-line"><span class="crayon-c">/*The combination makes a cool looking graph*/</span></div> <div id="crayon-5706bac752017554634927-55" class="crayon-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">drawPlotChart</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-56" class="crayon-line crayon-striped-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">drawLineChart</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706bac752017554634927-57" class="crayon-line"></div> <div id="crayon-5706bac752017554634927-58" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-59" class="crayon-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">drawLegend</span><span class="crayon-sy">(</span><span class="crayon-cn">90</span><span class="crayon-sy">,</span><span class="crayon-cn">20</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">//adds the legend</span></div> <div id="crayon-5706bac752017554634927-60" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-61" class="crayon-line"><span class="crayon-v">$myPicture</span><span class="crayon-o">-></span><span class="crayon-e">autoOutput</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span> <span class="crayon-c">/* Build the PNG file and send it to the web browser */</span></div> <div id="crayon-5706bac752017554634927-62" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706bac752017554634927-63" class="crayon-line"><span class="crayon-ta">?></span></div> </div> </td> </tr> </tbody> </table> </div> </div> <div id="huge-it-share-buttons-top" class="huge-it-share-buttons nobackground"> <h3>Share This:</h3> <ul class="huge-it-share-buttons-list"> <li class=" nobackground"><a href="http://ift.tt/1LIxY7s" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1LIxY7s','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -0px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -30px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIsm%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLIsm | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -60px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxZZ0" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1LIxZZ0','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -90px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ5Hb%20|%20Graphing%20timed%20mysql%20data%20with%20pchart&mini=true&url=http://ift.tt/1LIxZZ4" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ5Hb | Graphing timed mysql data with pchart&mini=true&url=http://ift.tt/1LIxZZ4','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -120px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIss%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLIss | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -150px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ8To%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ8To | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -180px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLKAr%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLKAr | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -210px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxY7u" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1LIxY7u','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -240px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8Tx%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ8Tx | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -270px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAt%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLKAt | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -300px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTq" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1o7SuTq','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -330px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8TA%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ8TA | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -360px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTs" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1o7SuTs','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -390px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAD%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLKAD | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -420px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ5XD%20|%20Graphing%20timed%20mysql%20data%20with%20pchart&pic=&ralateUid=&" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ5XD | Graphing timed mysql data with pchart&pic=&ralateUid=&','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -450px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLIIO%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/22fLIIO | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -480px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ99U%20|%20Graphing%20timed%20mysql%20data%20with%20pchart" id="backforunical456" name="backforunical456" onclick="javascript:void window.open('http://ift.tt/1qwJ99U | Graphing timed mysql data with pchart','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -510px -120px" target="_blank"></a></li> </ul> <div class="clear"></div> </div> View more at: <a href="http://yoursmart.mobi/">http://yoursmart.mobi</a>

PiPlanter | Graphing timed mysql data with pchart

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 ...

Read more »

PiPlanter | Basic package setup and bringing everything together

<p>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.</p> <p>First I need to get the components of a LAMP server with the following commands:</p> <div id="crayon-5706ba7027699753579351" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Shell</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027699753579351-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027699753579351-4">4</div> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-5">5</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027699753579351-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">apache2</span></div> <div id="crayon-5706ba7027699753579351-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">mysql</span><span class="crayon-o">–</span><span class="crayon-e">server</span></div> <div id="crayon-5706ba7027699753579351-3" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">php5</span></div> <div id="crayon-5706ba7027699753579351-4" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">php5</span><span class="crayon-o">–</span><span class="crayon-e">server</span></div> <div id="crayon-5706ba7027699753579351-5" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">php5</span><span class="crayon-o">–</span><span class="crayon-v">mysql</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Once you get the mysql server setup, you’ll need to create a database and tables in mysql.</p> <p>To create the database you’ll be using run the following command:</p> <div id="crayon-5706ba70276c1572798143" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276c1572798143-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276c1572798143-1" class="crayon-line"><span class="crayon-e">CREATE</span> <span class="crayon-e">DATABASE</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>And then grant the proper privileges to use later with the command:</p> <div id="crayon-5706ba70276e1372992774" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276e1372992774-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70276e1372992774-2">2</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276e1372992774-1" class="crayon-line"><span class="crayon-v">mysql</span><span class="crayon-o">></span> <span class="crayon-v">mysql</span><span class="crayon-o">></span> <span class="crayon-e">GRANT</span> <span class="crayon-e">ALL</span> <span class="crayon-e">PRIVILEGES</span> <span class="crayon-e">ON</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">.</span><span class="crayon-o">*</span> <span class="crayon-st">TO</span> <span class="crayon-s">‘user’</span><span class="crayon-sy">@</span><span class="crayon-s">‘localhost’</span> <span class="crayon-e">IDENTIFIED</span> <span class="crayon-i">BY</span> <span class="crayon-s">‘pass’</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70276e1372992774-2" class="crayon-line crayon-striped-line"><span class="crayon-e">FLUSH</span> <span class="crayon-v">PRIVILEGES</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Then we can enter the database and create a table:</p> <div id="crayon-5706ba70276fe909198342" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276fe909198342-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70276fe909198342-2">2</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276fe909198342-1" class="crayon-line"><span class="crayon-st">USE</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70276fe909198342-2" class="crayon-line crayon-striped-line"><span class="crayon-e">CREATE</span> <span class="crayon-e">TABLE</span> <span class="crayon-e">piplanter_table_01</span><span class="crayon-sy">(</span><span class="crayon-e">Sample_Number</span> <span class="crayon-t">INT</span> <span class="crayon-st">NOT</span> <span class="crayon-t">NULL</span> <span class="crayon-e">AUTO_INCREMENT</span> <span class="crayon-e">PRIMARY</span> <span class="crayon-v">KEY</span><span class="crayon-sy">,</span> <span class="crayon-r">Time</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span><span class="crayon-sy">,</span> <span class="crayon-e">Temp_F</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span><span class="crayon-sy">,</span> <span class="crayon-e">LDR_V</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span> <span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Now we need to set up the specific libraries for <a href="http://ift.tt/1SDfWQV" itemprop="url" target="_bank" title="Running A Python Script At Boot Using Cron"><strong>python</strong></a> the first of which being spidev, the spi tool for the <a href="http://ift.tt/1UIqQdK" itemprop="url" target="_bank" title="raspberry"><strong>raspberry</strong></a> pi which we can grab from git using the following commands:</p> <div id="crayon-5706ba7027719611053800" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027719611053800-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027719611053800-4">4</div> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-5">5</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027719611053800-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">git</span></div> <div id="crayon-5706ba7027719611053800-2" class="crayon-line crayon-striped-line"><span class="crayon-e">git</span> <span class="crayon-r">clone</span> <span class="crayon-v">git</span><span class="crayon-o">:</span><span class="crayon-o">/</span><span class="crayon-o">/</span><span class="crayon-v">github</span><span class="crayon-e">.com</span><span class="crayon-o">/</span><span class="crayon-v">doceme</span><span class="crayon-o">/</span><span class="crayon-v">py</span><span class="crayon-o">–</span><span class="crayon-e">spidev</span></div> <div id="crayon-5706ba7027719611053800-3" class="crayon-line"><span class="crayon-r">cd</span> <span class="crayon-v">py</span><span class="crayon-o">–</span><span class="crayon-v">spidev</span><span class="crayon-o">/</span></div> <div id="crayon-5706ba7027719611053800-4" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">dev</span></div> <div id="crayon-5706ba7027719611053800-5" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">python</span> <span class="crayon-v">setup</span><span class="crayon-e">.py</span> <span class="crayon-v">install</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>You also need to (copied from http://ift.tt/1Vc0WPO):</p> <p>As root, edit the kernel module blacklist file:</p> <div id="crayon-5706ba7027732119237297" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027732119237297-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027732119237297-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-r">vi</span> <span class="crayon-o">/</span><span class="crayon-v">etc</span><span class="crayon-o">/</span><span class="crayon-v">modprobe</span><span class="crayon-e">.d</span><span class="crayon-o">/</span><span class="crayon-v">raspi</span><span class="crayon-o">–</span><span class="crayon-v">blacklist</span><span class="crayon-e">.conf</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Comment out the spi-bcm2708 line so it looks like this:</p> <div id="crayon-5706ba7027749603743915" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027749603743915-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027749603743915-1" class="crayon-line"><span class="crayon-c">#blacklist spi-bcm2708</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Save the file so that the module will load on future reboots. To enable the module now, enter:</p> <div id="crayon-5706ba702775e457102376" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba702775e457102376-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba702775e457102376-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">modprobe</span> <span class="crayon-v">spi</span><span class="crayon-o">–</span><span class="crayon-v">bcm2708</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>We will also need WiringPi:</p> <div id="crayon-5706ba7027771922428619" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027771922428619-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027771922428619-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027771922428619-3">3</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027771922428619-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">imaging</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-v">imaging</span><span class="crayon-o">–</span><span class="crayon-e">tk</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">pip</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">dev</span> <span class="crayon-e">git</span></div> <div id="crayon-5706ba7027771922428619-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-e">pip</span> <span class="crayon-e">install</span> <span class="crayon-e">spidev</span></div> <div id="crayon-5706ba7027771922428619-3" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">pip</span> <span class="crayon-e">install</span> <span class="crayon-v">wiringpi</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Then you need to get APscheduler, the timing program used to execute the incremental timing with the following commands:</p> <div id="crayon-5706ba7027783753120952" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027783753120952-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027783753120952-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027783753120952-3">3</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027783753120952-1" class="crayon-line"><span class="crayon-e">wget</span> <span class="crayon-v">https</span><span class="crayon-o">:</span><span class="crayon-o">/</span><span class="crayon-o">/</span><span class="crayon-v">pypi</span><span class="crayon-e">.python</span><span class="crayon-e">.org</span><span class="crayon-o">/</span><span class="crayon-v">packages</span><span class="crayon-o">/</span><span class="crayon-v">source</span><span class="crayon-o">/</span><span class="crayon-v">A</span><span class="crayon-o">/</span><span class="crayon-v">APScheduler</span><span class="crayon-o">/</span><span class="crayon-v">APScheduler</span><span class="crayon-o">–</span><span class="crayon-cn">2.1.0.tar.gz</span></div> <div id="crayon-5706ba7027783753120952-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">tar</span> <span class="crayon-o">–</span><span class="crayon-e">xzvf</span> <span class="crayon-v">APScheduler</span><span class="crayon-o">–</span><span class="crayon-cn">2.1.0.tar.gz</span></div> <div id="crayon-5706ba7027783753120952-3" class="crayon-line"><span class="crayon-e">python</span> <span class="crayon-v">setup</span><span class="crayon-e">.py</span> <span class="crayon-v">install</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>You will need mysqldb to interface <a href="http://ift.tt/1S5WXUP" itemprop="url" target="_bank" title="How To Autorun A Python Script On Raspberry Pi Boot"><strong>python</strong></a> and mysql:</p> <div id="crayon-5706ba7027794360204196" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027794360204196-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027794360204196-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-v">mysqldb</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Once you reboot, the following program should work:</p> <div id="crayon-5706ba70277a4245282675" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Python</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-2">2</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-4">4</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-6">6</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-8">8</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-10">10</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-12">12</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-14">14</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-16">16</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-18">18</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-20">20</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-21">21</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-22">22</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-23">23</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-24">24</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-25">25</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-26">26</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-27">27</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-28">28</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-29">29</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-30">30</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-31">31</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-32">32</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-33">33</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-34">34</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-35">35</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-36">36</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-37">37</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-38">38</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-39">39</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-40">40</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-41">41</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-42">42</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-43">43</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-44">44</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-45">45</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-46">46</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-47">47</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-48">48</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-49">49</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-50">50</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-51">51</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-52">52</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-53">53</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-54">54</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-55">55</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-56">56</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-57">57</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-58">58</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-59">59</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-60">60</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-61">61</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-62">62</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-63">63</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-64">64</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-65">65</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-66">66</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-67">67</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-68">68</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-69">69</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-70">70</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-71">71</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-72">72</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-73">73</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-74">74</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-75">75</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-76">76</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-77">77</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-78">78</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-79">79</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-80">80</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-81">81</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-82">82</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70277a4245282675-1" class="crayon-line"><span class="crayon-c">#Timing setup</span></div> <div id="crayon-5706ba70277a4245282675-2" class="crayon-line crayon-striped-line"><span class="crayon-st">from</span> <span class="crayon-k">datetime</span> <span class="crayon-r">import</span> <span class="crayon-k">datetime</span></div> <div id="crayon-5706ba70277a4245282675-3" class="crayon-line"><span class="crayon-st">from</span> <span class="crayon-v">apscheduler</span><span class="crayon-sy">.</span><span class="crayon-e">scheduler</span> <span class="crayon-r">import</span> <span class="crayon-e">Scheduler</span></div> <div id="crayon-5706ba70277a4245282675-4" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">time</span></div> <div id="crayon-5706ba70277a4245282675-5" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-k">datetime</span></div> <div id="crayon-5706ba70277a4245282675-6" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">sys</span></div> <div id="crayon-5706ba70277a4245282675-7" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-8" class="crayon-line crayon-striped-line"><span class="crayon-v">now</span> <span class="crayon-o">=</span><span class="crayon-k">datetime</span><span class="crayon-sy">.</span><span class="crayon-k">datetime</span><span class="crayon-sy">.</span><span class="crayon-e">now</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-9" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-10" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">logging</span> <span class="crayon-c">#if you start getting logging errors, uncomment these two lines</span></div> <div id="crayon-5706ba70277a4245282675-11" class="crayon-line"><span class="crayon-k">logging</span><span class="crayon-sy">.</span><span class="crayon-e">basicConfig</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-12" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-13" class="crayon-line"><span class="crayon-c">#GPIO setup</span></div> <div id="crayon-5706ba70277a4245282675-14" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-v">RPi</span><span class="crayon-sy">.</span><span class="crayon-e">GPIO</span> <span class="crayon-st">as</span> <span class="crayon-e">GPIO</span></div> <div id="crayon-5706ba70277a4245282675-15" class="crayon-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setmode</span><span class="crayon-sy">(</span><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">BOARD</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-16" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-17" class="crayon-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">cleanup</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-18" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-19" class="crayon-line"><span class="crayon-v">pin</span> <span class="crayon-o">=</span> <span class="crayon-cn">26</span> <span class="crayon-c">#pin for the adc</span></div> <div id="crayon-5706ba70277a4245282675-20" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">pin</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-21" class="crayon-line"><span class="crayon-v">led1</span> <span class="crayon-o">=</span> <span class="crayon-cn">11</span> <span class="crayon-c">#pin for the short indicator led</span></div> <div id="crayon-5706ba70277a4245282675-22" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-23" class="crayon-line"><span class="crayon-v">led2</span> <span class="crayon-o">=</span> <span class="crayon-cn">13</span> <span class="crayon-c">#pin for other long indicator led</span></div> <div id="crayon-5706ba70277a4245282675-24" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-25" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-26" class="crayon-line crayon-striped-line"><span class="crayon-c">#the adc’s SPI setup</span></div> <div id="crayon-5706ba70277a4245282675-27" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-e">spidev</span></div> <div id="crayon-5706ba70277a4245282675-28" class="crayon-line crayon-striped-line"><span class="crayon-v">spi</span> <span class="crayon-o">=</span> <span class="crayon-v">spidev</span><span class="crayon-sy">.</span><span class="crayon-e">SpiDev</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-29" class="crayon-line"><span class="crayon-v">spi</span><span class="crayon-sy">.</span><span class="crayon-k">open</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">,</span> <span class="crayon-cn">0</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-30" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-31" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-e">MySQLdb</span></div> <div id="crayon-5706ba70277a4245282675-32" class="crayon-line crayon-striped-line"><span class="crayon-v">con</span> <span class="crayon-o">=</span> <span class="crayon-v">MySQLdb</span><span class="crayon-sy">.</span><span class="crayon-e">connect</span><span class="crayon-sy">(</span><span class="crayon-s">‘localhost’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter_user’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter_pass’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter’</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277a4245282675-33" class="crayon-line"><span class="crayon-v">cursor</span> <span class="crayon-o">=</span> <span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">cursor</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-34" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-35" class="crayon-line"><span class="crayon-c">#fuction that can read the adc</span></div> <div id="crayon-5706ba70277a4245282675-36" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-v">adcnum</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-37" class="crayon-line"><span class="crayon-c"># read SPI data from MCP3008 chip, 8 possible adc’s (0 thru 7)</span></div> <div id="crayon-5706ba70277a4245282675-38" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-st">if</span> <span class="crayon-v">adcnum</span> <span class="crayon-o">></span> <span class="crayon-cn">7</span> <span class="crayon-st">or</span> <span class="crayon-v">adcnum</span> <span class="crayon-o"><</span> <span class="crayon-cn">0</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-39" class="crayon-line"><span class="crayon-h">        </span><span class="crayon-st">return</span> <span class="crayon-o">–</span><span class="crayon-cn">1</span></div> <div id="crayon-5706ba70277a4245282675-40" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">r</span> <span class="crayon-o">=</span> <span class="crayon-v">spi</span><span class="crayon-sy">.</span><span class="crayon-e">xfer2</span><span class="crayon-sy">(</span><span class="crayon-sy">[</span><span class="crayon-cn">1</span><span class="crayon-sy">,</span> <span class="crayon-cn">8</span> <span class="crayon-o">+</span> <span class="crayon-v">adcnum</span> <span class="crayon-o"><<</span> <span class="crayon-cn">4</span><span class="crayon-sy">,</span> <span class="crayon-cn">0</span><span class="crayon-sy">]</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-41" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">adcout</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-v">r</span><span class="crayon-sy">[</span><span class="crayon-cn">1</span><span class="crayon-sy">]</span> <span class="crayon-o">&</span> <span class="crayon-cn">3</span><span class="crayon-sy">)</span> <span class="crayon-o"><<</span> <span class="crayon-cn">8</span><span class="crayon-sy">)</span> <span class="crayon-o">+</span> <span class="crayon-v">r</span><span class="crayon-sy">[</span><span class="crayon-cn">2</span><span class="crayon-sy">]</span></div> <div id="crayon-5706ba70277a4245282675-42" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-st">return</span> <span class="crayon-e">adcout</span></div> <div id="crayon-5706ba70277a4245282675-43" class="crayon-line"><span class="crayon-e">    </span></div> <div id="crayon-5706ba70277a4245282675-44" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">rapidSample</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-45" class="crayon-line"><span class="crayon-v">sampleTime</span> <span class="crayon-o">=</span> <span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">ctime</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-46" class="crayon-line crayon-striped-line"><span class="crayon-v">sampleTemp1</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-o">*</span><span class="crayon-cn">3.3</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-cn">1024</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-sy">(</span><span class="crayon-cn">10.0</span><span class="crayon-o">/</span><span class="crayon-cn">1000</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span> <span class="crayon-c">#this translates the analog voltage to temperature in def F</span></div> <div id="crayon-5706ba70277a4245282675-47" class="crayon-line"><span class="crayon-v">sampleLght1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-48" class="crayon-line crayon-striped-line"><span class="crayon-v">samplePot1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">2</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-49" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-50" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-t">True</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-51" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-sy">.</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span> <span class="crayon-c">#sleeps a little bit so you can see the <a href="http://ift.tt/1LK8gQ0" itemprop="url" target="_bank" title="LED"><strong>LED</strong></a> on</span></div> <div id="crayon-5706ba70277a4245282675-52" class="crayon-line crayon-striped-line"><span class="crayon-k">print</span> <span class="crayon-s">“Job 1”</span><span class="crayon-sy">,</span> <span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-s">“LDR:”</span><span class="crayon-sy">,</span><span class="crayon-i">sampleLght1</span> <span class="crayon-sy">,</span><span class="crayon-s">“Pot:”</span><span class="crayon-sy">,</span><span class="crayon-v">samplePot1</span><span class="crayon-sy">,</span><span class="crayon-s">“Temp:”</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span> <span class="crayon-c">#prints the debug info</span></div> <div id="crayon-5706ba70277a4245282675-53" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-54" class="crayon-line crayon-striped-line"><span class="crayon-v">cursor</span><span class="crayon-sy">.</span><span class="crayon-e">execute</span><span class="crayon-sy">(</span><span class="crayon-s">“INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,’%s’,’%s’)”</span><span class="crayon-sy">,</span><span class="crayon-sy">(</span><span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span><span class="crayon-sy">,</span><span class="crayon-v">sampleLght1</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-55" class="crayon-line"><span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">commit</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span> <span class="crayon-c">#this is important for live updating</span></div> <div id="crayon-5706ba70277a4245282675-56" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-57" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-sy">.</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-58" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-t">False</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led off</span></div> <div id="crayon-5706ba70277a4245282675-59" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-60" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">slowSample</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-61" class="crayon-line"><span class="crayon-v">sampleTime</span> <span class="crayon-o">=</span> <span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">ctime</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-62" class="crayon-line crayon-striped-line"><span class="crayon-v">sampleTemp1</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-o">*</span><span class="crayon-cn">3.3</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-cn">1024</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-sy">(</span><span class="crayon-cn">10.0</span><span class="crayon-o">/</span><span class="crayon-cn">1000</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span> <span class="crayon-c">#this translates the analog voltage to temperature in def F</span></div> <div id="crayon-5706ba70277a4245282675-63" class="crayon-line"><span class="crayon-v">sampleLght1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-64" class="crayon-line crayon-striped-line"><span class="crayon-v">samplePot1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">2</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-65" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-66" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-t">True</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-67" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">5</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-68" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-69" class="crayon-line"><span class="crayon-k">print</span> <span class="crayon-s">“Job 2”</span><span class="crayon-sy">,</span> <span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-s">“LDR:”</span><span class="crayon-sy">,</span><span class="crayon-i">sampleLght1</span> <span class="crayon-sy">,</span><span class="crayon-s">“Pot:”</span><span class="crayon-sy">,</span><span class="crayon-v">samplePot1</span><span class="crayon-sy">,</span><span class="crayon-s">“Temp:”</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span> <span class="crayon-c">#prints the debug info</span></div> <div id="crayon-5706ba70277a4245282675-70" class="crayon-line crayon-striped-line"><span class="crayon-v">cursor</span><span class="crayon-sy">.</span><span class="crayon-e">execute</span><span class="crayon-sy">(</span><span class="crayon-s">“INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,’%s’,’%s’)”</span><span class="crayon-sy">,</span><span class="crayon-sy">(</span><span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span><span class="crayon-sy">,</span><span class="crayon-v">sampleLght1</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-71" class="crayon-line"><span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">commit</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span> <span class="crayon-c">#this is important for live updating</span></div> <div id="crayon-5706ba70277a4245282675-72" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-73" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">5</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-74" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-t">False</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-75" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-76" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-77" class="crayon-line"><span class="crayon-st">if</span> <span class="crayon-v">__name__</span> <span class="crayon-o">==</span> <span class="crayon-s">‘__main__’</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-78" class="crayon-line crayon-striped-line"><span class="crayon-c">#the following 3 lines start up the interval job and keep it going</span></div> <div id="crayon-5706ba70277a4245282675-79" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span> <span class="crayon-o">=</span> <span class="crayon-e">Scheduler</span><span class="crayon-sy">(</span><span class="crayon-v">standalone</span><span class="crayon-o">=</span><span class="crayon-t">True</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-80" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">add_interval_job</span><span class="crayon-sy">(</span><span class="crayon-v">rapidSample</span><span class="crayon-sy">,</span> <span class="crayon-v">minutes</span><span class="crayon-o">=</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-81" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">add_interval_job</span><span class="crayon-sy">(</span><span class="crayon-v">slowSample</span><span class="crayon-sy">,</span> <span class="crayon-v">hours</span><span class="crayon-o">=</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-82" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">start</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>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:</p> <div id="crayon-5706ba70277b6608933182" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">PHP</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-2">2</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-4">4</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-6">6</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-8">8</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-10">10</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-12">12</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-14">14</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-16">16</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-18">18</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-20">20</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-21">21</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-22">22</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-23">23</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-24">24</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-25">25</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-26">26</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70277b6608933182-1" class="crayon-line"><span class="crayon-ta"><?php</span></div> <div id="crayon-5706ba70277b6608933182-2" class="crayon-line crayon-striped-line"><span class="crayon-e">mysql_connect</span><span class="crayon-sy">(</span><span class="crayon-s">“localhost”</span><span class="crayon-sy">,</span> <span class="crayon-s">“piplanter_user”</span><span class="crayon-sy">,</span><span class="crayon-s">“piplanter_pass”</span><span class="crayon-sy">)</span> <span class="crayon-st">or</span> <span class="crayon-k">die</span> <span class="crayon-sy">(</span><span class="crayon-s">“Could not connect: “</span> <span class="crayon-sy">.</span> <span class="crayon-e">mysql_error</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-3" class="crayon-line"><span class="crayon-e">mysql_select_db</span><span class="crayon-sy">(</span><span class="crayon-s">“piplanter”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-4" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-5" class="crayon-line"><span class="crayon-v">$result</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_query</span><span class="crayon-sy">(</span><span class="crayon-s">“SELECT * FROM piplanter_table_02”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-6" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-7" class="crayon-line"><span class="crayon-k">echo</span> <span class="crayon-s">“<table border=’1′></span></div> <div id="crayon-5706ba70277b6608933182-8" class="crayon-line crayon-striped-line"><span class="crayon-s"><tr></span></div> <div id="crayon-5706ba70277b6608933182-9" class="crayon-line"><span class="crayon-s"><th>Sample_Number</th></span></div> <div id="crayon-5706ba70277b6608933182-10" class="crayon-line crayon-striped-line"><span class="crayon-s"><th>Time</th></span></div> <div id="crayon-5706ba70277b6608933182-11" class="crayon-line"><span class="crayon-s"><th>Temp F</th></span></div> <div id="crayon-5706ba70277b6608933182-12" class="crayon-line crayon-striped-line"><span class="crayon-s"><th>LDR Value V</th></span></div> <div id="crayon-5706ba70277b6608933182-13" class="crayon-line"><span class="crayon-s"></tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-14" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-15" class="crayon-line"><span class="crayon-st">while</span><span class="crayon-sy">(</span><span class="crayon-v">$row</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_fetch_array</span><span class="crayon-sy">(</span><span class="crayon-v">$result</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">{</span></div> <div id="crayon-5706ba70277b6608933182-16" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-17" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Sample_Number’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-18" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Time’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-19" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Temp_F’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-20" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘LDR_V’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-21" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“</tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-22" class="crayon-line crayon-striped-line"><span class="crayon-sy">}</span></div> <div id="crayon-5706ba70277b6608933182-23" class="crayon-line"></div> <div id="crayon-5706ba70277b6608933182-24" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span> <span class="crayon-s">“</table>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-25" class="crayon-line"><span class="crayon-e">mysql_close</span><span class="crayon-sy">(</span><span class="crayon-v">$con</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-26" class="crayon-line crayon-striped-line"><span class="crayon-ta">?></span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Sometime later I’ll get to graphing the data.</p> <div id="huge-it-share-buttons-top" class="huge-it-share-buttons nobackground"> <h3>Share This:</h3> <ul class="huge-it-share-buttons-list"> <li class=" nobackground"><a href="http://ift.tt/1LIxY7s" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxY7s','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -0px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -30px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIsm%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIsm | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -60px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxZZ0" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxZZ0','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -90px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ5Hb%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together&mini=true&url=http://ift.tt/1LIxZZ4" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ5Hb | Basic package setup and bringing everything together&mini=true&url=http://ift.tt/1LIxZZ4','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -120px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIss%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIss | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -150px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ8To%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8To | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -180px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLKAr%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAr | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -210px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxY7u" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxY7u','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -240px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8Tx%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8Tx | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -270px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAt%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAt | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -300px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTq" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1o7SuTq','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -330px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8TA%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8TA | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -360px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTs" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1o7SuTs','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -390px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAD%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAD | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -420px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ5XD%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together&pic=&ralateUid=&" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ5XD | Basic package setup and bringing everything together&pic=&ralateUid=&','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -450px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLIIO%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIIO | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -480px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ99U%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ99U | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -510px -120px" target="_blank"></a></li> </ul> <div class="clear"></div> </div> View more at: <a href="http://yoursmart.mobi/">http://yoursmart.mobi</a>

PiPlanter | Basic package setup and bringing everything together

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 d...

Read more »