def getInfo(self): sense = SenseHat.getSenseHat() timestamp = datetime.datetime.now().strftime('%d/%m/%Y %I:%M %p') pressure = sense.get_pressure() if pressure is not None: pressure = round(pressure, 2) return timestamp, pressure def dataLogger(self, timestamp, pressure): DB_NAME = "sensehat.db" connection = sqlite3.connect(DB_NAME) with connection: connection.execute( """INSERT INTO sensehat_data (timestamp, pressure) VALUES (:timestamp, :pressure)""", {"timestamp": timestamp, "pressure": temperature }) def displayData(self): DB_NAME = "sensehat.db" connection = sqlite3.connect(DB_NAME) connection.row_factory = sqlite3.Row with connection: cursor = connection.cursor() cursor.execute("SELECT * FROM sensehat_data") print("Database content:") print("-----------------") print("Time Pressure") for row in cursor: print(row["timestamp"], row["pressure"], sep=" ")
def getInfo(self): sense = SenseHat.getSenseHat() timestamp = datetime.datetime.now().strftime('%d/%m/%Y %I:%M %p') temperature = sense.get_temperature() humidity = sense.get_humidity() if temperature is not None: temperature = round(temperature, 2) if humidity is not None: humidity = round(humidity, 2) return timestamp, temperature, humidity