adilosa / weathermon Goto Github PK

This is what I've found from reading through the source:

CREATE TABLE reading (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    channel INTEGER,
    temperature INTEGER,
    humidity INTEGER,
    battery INTEGER,
    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE sensor (
    id INTEGER PRIMARY KEY,
    channel INTEGER,
    name TEXT
);

INSERT INTO sensor VALUES (1, 2, "MySensor");

Related: #3

Examples:

• sqlite3_open fails when the folder /var/www/weathermon/ does not exist
• sqlite3_exec fails when the db is not open or when the table reading does not exist in the database

Nevermind, just divide by ten to get the correct Fahrenheit value or read the comments of the original "Arduino-F007th-Sketches/Working sketch v3" to understand how to calculate the Celsius value correctly. Thanks :-)

Hi there, I have a Raspberry Pi and a RWS-371 component plugged into UART. So, I think the communication will work. I also installed all the libraries so the python script will run. I'm missing some knowledge about how to compile the C code and how to get the Python to read the actual data. Can you give me some more build steps?

Thanks,
Paul