import serial
import psycopg2
try:
conn = psycopg2.connect("dbname='postgres' user='pi' host='localhost' password='root'")
cur = conn.cursor()
except:
print(" Não consigo conectar-me ao banco de dados ")
while 1:
cur = conn.cursor()
sensor = serial.Serial('/dev/ttyACM0', 9600)
int(sensor)
print(sensor.readline ())
cur.execute("CREATE TABLE IF NOT EXISTS test (id serial PRIMARY KEY, num integer, data varchar);")
conn.commit()
cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (sensor, "abc'def"))
conn.commit()
cur.close()
#conn.close()
O que significa esse erro?
