kFsrCjcy

1import sqlite3
2import smtplib
3import Adafruit_BBIO.GPIO as GPIO
4import Adafruit_DHT
5import time
6
7def INIT():
8    conn = sqlite3.connect("measurement.db")
9    cursor = conn.cursor()
10    RECREATE_DATABASE(cursor)
11    return cursor
12
13def RECREATE_DATABASE(cursor):
14    sql = 'create table if not exists measurement(temperature number)'
15    cursor.execute(sql)
16
17def INSERT(cursor, temperature):
18    cursor.execute('insert into measurement(temperature) VALUES (?)', (temperature,))
19
20def SELECT(cursor):
21    sql = 'select temperature from measurement order by _rowid_ desc'
22    cursor.execute(sql)
23    return cursor.fetchone()
24
25
26
27def mmm():
28    import serial
29    import Adafruit_BBIO.UART as UART
30    from time import sleep
31    UART.setup("UART1")
32    ser = serial.Serial(port='/dev/ttyO1', baudrate=9600)
33    cursor = INIT()
34
35    while(1):
36        temp = ser.readline()
37        INSERT(cursor, float(temp))
38        tempFromDb = SELECT(cursor)
39        print(tempFromDb)
40
41
42
43if __name__ == '__main__':
44    mmm()