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