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:

• NodeMCU 32S
• Raspberry pi 4
• DHT22 - temperature and humidity sensor
• Solenoid valve - 12V, normally closed
• H-Bridge - model L298N, 12V
• Resistor 10kOhm
• Power supply adapter - 12V
• Breadboard
• Connection wires

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()