Skip to content

Simple RESTful API to persist Internet of Things information to central data hub

Notifications You must be signed in to change notification settings

khinds10/DeviceHub

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Device Hub

Generalized data hub to persist RaspberryPi project generated data for reporting and analysis

Installation

Copy the files from this project to a PHP enabled webhost of your choice with a MySQL instance available for use

Create the MySQL DB (having connectivity to your PHP webhost)

CREATE DATABASE my_devices;

USE my_devices;

CREATE TABLE devices ( entry INT NOT NULL AUTO_INCREMENT, time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, device VARCHAR(50), value1 VARCHAR(500), value2 VARCHAR(500), value3 VARCHAR(500), value4 VARCHAR(500), value5 VARCHAR(500), value6 VARCHAR(500), value7 VARCHAR(500), value8 VARCHAR(500), value9 VARCHAR(500), value10 VARCHAR(500), PRIMARY KEY (entry) );

ALTER TABLE devices ADD INDEX device (device); ALTER TABLE devices ADD INDEX time (time);

Configure Site Settings

Copy the settings.shadow.php file to a file named settings.php with the correct credentials for your MySQL instance

RPi Project python example to upload data

Python dependancy

sudo apt-get install python-requests

Code Snippet

import requests

r = requests.post("http://yourweb.com/api/log/", data={'device': 'weather-clock', 'value1': '78', 'value2': '56', 'value3': '', 'value4': '', 'value5': '', 'value6': '', 'value7': '', 'value8': '', 'value9': '', 'value10': ''}) print(r.status_code, r.reason) print(r.text)

weather-clock indentified device persisting value1 = 78 and value2 = 56 (value1 is *F and value2 is humidity % implied in this case)

Read Device Data Back

http://yourweb.com/api/read/?device=weather-clock

Additional API usage examples

http://yourweb.com/api/hello Output: HELLO WORLD

http://yourweb.com/api/test?var=testing_get_method Output: testing_get_method

About

Simple RESTful API to persist Internet of Things information to central data hub

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages