#!/usr/bin/env python
import Adafruit_DHT
import MySQLdb

sensor = Adafruit_DHT.DHT22
pin = 4
db = MySQLdb.connect("localhost", "root", "passwort", "haus")
curs=db.cursor()

try:
    humidity, temperature = Adafruit_DHT.read_retry(sensor, pin)
    curs.execute ("INSERT INTO temperatur_tb (datum, uhrzeit, wert) VALUES (CURRENT_DATE(), NOW(), %.2f);" % temperature)
    db.commit()
    print("Done")
except:
    print("Error. Rolling back.")
    db.rollback()