Example #1
0
    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="   ")
Example #2
0
    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