opkg update opkg install mysql-server mysql -h192.168.0.20 -uroot -p
mysql> show databases; mysql> CREATE DATABASE ARDUINO; mysql> USE ARDUINO; mysql> CREATE TABLE temperature ( id INT NOT NULL AUTO_INCREMENT, sensor1 VARCHAR(20), sensor2 VARCHAR(20), insert_date TIMESTAMP, PRIMARY KEY (id) ); mysql> SHOW TABLES;
opkg update opkg install python-mysql nano /mnt/sda1/mysql.py
#!/usr/bin/python # -*- coding: utf-8 -*- import _mysql import sys, string, os try: con = _mysql.connect('192.168.0.20', 'root', 'password', 'ARDUINO') sqlstr="INSERT INTO temperature(sensor1, sensor2) VALUES( '" + sys.argv[1] +"', '" + sys.argv[2] + "')" #print sqlstr con.query(sqlstr) except _mysql.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) sys.exit(1) finally: if con: con.close()
chmod 755 /mnt/sda1/mysql.py /mnt/sda1/mysql.py 'test1' 'test2'
Arduino code:
#include <Process.h> int temperature; void setup() { Bridge.begin(); // Initialize Bridge } void loop() { int sensor1 = random(0, 100); int sensor2 = random(0, 10); Process p; p.begin("/mnt/sda1/mysql.py"); p.addParameter(String(sensor1)); p.addParameter(String(sensor2)); p.run(); delay(5000); }
Comments powered by CComment