Mein Python-Code
Code: Alles auswählen
import serial
import pymysql
device = /dev/ttyACM0'
arduino = serial.Serial(device,9600)
data = arduino.readline()
print (data)
connection = pymysql.conect("localhost","pi","","temperature_db) or die("cant connect to database")
print (connection)
with connection:
cursor = connection .cursor
cursor.execute("INSERT INTO tempLog (Temperature) VALUES (%s)" %(data))
connection.commit()
connection.execute()