Raspberry Pi PLC/Domotica testcase

apt-get update
apt-get install python, py-pycurl

apt-get update apt-get install python, py-pycurl

import RPi.GPIO as GPIO
import time
import os
 
buttonPin = 07
GPIO.setmode(GPIO.BOARD)
GPIO.setup(buttonPin,GPIO.IN)
 
while True:
  if (GPIO.input(buttonPin)):
    os.system("sudo python /home/pi/plc_handle.py")
    #print "button called"

import RPi.GPIO as GPIO import time import os buttonPin = 07 GPIO.setmode(GPIO.BOARD) GPIO.setup(buttonPin,GPIO.IN) while True: if (GPIO.input(buttonPin)): os.system("sudo python /home/pi/plc_handle.py") #print "button called"

import time
import RPi.GPIO as GPIO
import datetime
import pycurl, json
 
buttonPin = 07
GPIO.setmode(GPIO.BOARD)
GPIO.setup(buttonPin,GPIO.IN)
 
# reset state
last_state = -1
 
while True:
  input = GPIO.input(buttonPin)
  now = datetime.datetime.now()
 
  # check if value changed
  if (input != last_state) :
    	print "Button state is changed:",input, " @ ",now
	api_url = "webserver.com/api/input.php"
	data = "location_id=1&status=%s" % input
	c = pycurl.Curl()
	c.setopt(pycurl.URL, api_url)
	c.setopt(pycurl.POST, 1)
	c.setopt(pycurl.POSTFIELDS, data)
	c.perform()
 
  # update previous input
  last_state = input
 
  # slight pause to debounce
  time.sleep(1)

import time import RPi.GPIO as GPIO import datetime import pycurl, json buttonPin = 07 GPIO.setmode(GPIO.BOARD) GPIO.setup(buttonPin,GPIO.IN) # reset state last_state = -1 while True: input = GPIO.input(buttonPin) now = datetime.datetime.now() # check if value changed if (input != last_state) : print "Button state is changed:",input, " @ ",now api_url = "webserver.com/api/input.php" data = "location_id=1&status=%s" % input c = pycurl.Curl() c.setopt(pycurl.URL, api_url) c.setopt(pycurl.POST, 1) c.setopt(pycurl.POSTFIELDS, data) c.perform() # update previous input last_state = input # slight pause to debounce time.sleep(1)

sudo python /home/pi/plc.py

sudo python /home/pi/plc.py

python /home/pi/plc.py
exit 0

python /home/pi/plc.py exit 0

<?
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
 
$dbh = new PDO('mysql:host=localhost; dbname=database', 'username', 'password');
 
$response = array(
    'status'    => 'nok'
);
 
if(!Empty($_POST['location_id']))
{
    $status = $_POST['status'];
    $location_id = $_POST['location_id'];
 
    // create log
    $sql = "INSERT INTO status_log (location_id, status, created_at, updated_at) VALUES (:location_id, :status, NOW(), NOW())";
    $q = $dbh->prepare($sql);
    $q->execute(array(':location_id' => $location_id,
                      ':status'      => $status));
 
    // update location  
    $sql = "UPDATE location SET status=:status, updated_at=NOW() WHERE id=:location_id";
    $q = $dbh->prepare($sql);
    $q->execute(array(':location_id' => $location_id,
                      ':status'      => $status));
 
    // output
    $response = array(
        'status'    => 'ok'
    ); 
}
 
echo json_encode($response);
?>

<? header('Cache-Control: no-cache, must-revalidate'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Content-type: application/json'); $dbh = new PDO('mysql:host=localhost; dbname=database', 'username', 'password'); $response = array( 'status' => 'nok' ); if(!Empty($_POST['location_id'])) { $status = $_POST['status']; $location_id = $_POST['location_id']; // create log $sql = "INSERT INTO status_log (location_id, status, created_at, updated_at) VALUES (:location_id, :status, NOW(), NOW())"; $q = $dbh->prepare($sql); $q->execute(array(':location_id' => $location_id, ':status' => $status)); // update location $sql = "UPDATE location SET status=:status, updated_at=NOW() WHERE id=:location_id"; $q = $dbh->prepare($sql); $q->execute(array(':location_id' => $location_id, ':status' => $status)); // output $response = array( 'status' => 'ok' ); } echo json_encode($response); ?>