Raspi solar monitoring project, update mysql database

Question

for my raspberry pil solar system monitoring project, i am using six sensors that measure both voltage and current from the PV panel, batt and load sides. Those sensors return analog output and has been read by my arduino uno and then being called by my python script using serial command. i have printed a txt file just to make sure that i am taking the reading. now i want to upload the code to the table that i have created following the instrustion of the raspberry pi weather station guidelines, the database name is weather and i have created the table using the following codes

      CREATE TABLE WEATHER_MEASUREMENT(
      ID BIGINT NOT NULL AUTO_INCREMENT,
      REMOTE_ID BIGINT,
      PV_VOLTAGE DECIMAL(6,2) NOT NULL,
      PV_CURRENT DECIMAL(6,2) NOT NULL,
      BATT_VOLTAGE DECIMAL(6,2) NOT NULL,
      BATT_CURRENT DECIMAL(6,2) NOT NULL,
      LOAD_VOLTAGE(6,2) NOT NULL,
      LOAD_CURRENT DECIMAL(6,2) NULL, 
      CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY ( ID )
      );

below are my python and arduino codes (i test my sensors using a DC powe supply, the 4th and 5th value printed is abit weird because i didnt connect my sensors to the supply). [1]http://www.imgpaste.net/image/xt61S "tooltip"

i am actually a newbie to python and the arduino language. i did the codes by referring to some guides and other people posts so please point out my mistake or any necessary codes that i ve written. Cheers.

i want to ask how should i implemetn those mysql setting inside my python code — Aaron Tzeng, Oct 22 '16 at 06:16

score 0 · Answer 1 · answered Oct 23 '16 at 22:54

You need to first install MySQLdb for your python. Download it from MySQL for Python page.

and install it as follows,

$ gunzip MySQL-python-1.2.2.tar.gz
$ tar -xvf MySQL-python-1.2.2.tar
$ cd MySQL-python-1.2.2
$ python setup.py build
$ python setup.py install

You can then connect to your database as follows,

#!/usr/bin/python

import MySQLdb

# Open database connection
db = MySQLdb.connect("localhost","userName","userPassword","databaseName" )

Once you are connected to database, you can add, update, delete data into your table.

Please google "MySQL Python tutorial" to learn how to execute basic queries, or visit here, https://www.tutorialspoint.com/python/python_database_access.htm

Raspi solar monitoring project, update mysql database

1 Answers1