This is an old revision of the document!
Dinca Laura-Aida - SSA
Smart Garden project aims to be a plant environment monitoring system. Thanks to a temperature and humidity sensor, we have the data on the basis of which we can implement a logic for opening the irrigation system when needed. Being a proof of concept implementation, it has not yet been used in a real garden and the condition for opening the valve is chosen for testing purposes.
Components:
import sqlite3 import os database_path = "./database.db" conn = sqlite3.connect(database_path) cursor = conn.cursor() cursor.execute(""" CREATE TABLE IF NOT EXISTS sensorData ( id INTEGER PRIMARY KEY, temperature INTEGER, humidity INTEGER ) """) conn.commit() conn.close()