Was ist an meinem Code falsch? "IndentationError: expected an indented block"

pi@raspberrypi:~/solarueberwachung $  python heiztemp.py
 Zeit: 2023-04-26 17:00:25 Sensor: d64e421f64ff hat die Temperatur 22.4375
 Zeit: 2023-04-26 17:00:25 Sensor: 3077421f64ff hat die Temperatur 18.75
 Zeit: 2023-04-26 17:00:25 Sensor: 566a9c1e64ff hat die Temperatur 18.8125
{None: 18.8125}
Traceback (most recent call last):
  File "/home/pi/solarueberwachung/heiztemp.py", line 92, in <module>
    main()
  File "/home/pi/solarueberwachung/heiztemp.py", line 87, in main
    insert_to_db(timestamp, sensor_name_to_temperature)
  File "/home/pi/solarueberwachung/heiztemp.py", line 40, in insert_to_db
    sensor_name_to_temperature["S1"],
KeyError: 'S1'

MariaDB [(none)]> SHOW FIELDS FROM solarueberwachung FROM solarueberwachung;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| datetime | datetime     | NO   |     | NULL    |                |
| S1       | decimal(3,1) | YES  |     | NULL    |                |
| S2       | decimal(3,1) | YES  |     | NULL    |                |
| S3       | decimal(3,1) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.005 sec)

{}
{}
{}
Traceback (most recent call last):
  File "/home/pi/solarueberwachung/heiztemp.py", line 92, in <module>
    main()
  File "/home/pi/solarueberwachung/heiztemp.py", line 87, in main
    insert_to_db(timestamp, sensor_name_to_temperature)
  File "/home/pi/solarueberwachung/heiztemp.py", line 40, in insert_to_db
    sensor_name_to_temperature["S1"],
KeyError: 'S1'

pi@raspberrypi:~/solarueberwachung $ python heiztemp.py
Pumpe ist AUS
{'S1': 19.5, 'S2': 19.5625, 'S3': 18.9375}
Traceback (most recent call last):
  File "/home/pi/solarueberwachung/heiztemp.py", line 89, in <module>
    main()
  File "/home/pi/solarueberwachung/heiztemp.py", line 85, in main
    insert_to_db(timestamp, sensor_name_to_temperature, pumpe)
  File "/home/pi/solarueberwachung/heiztemp.py", line 53, in insert_to_db
    cursor.execute(query, args)
  File "/home/pi/.local/lib/python3.9/site-packages/mysql/connector/cursor.py", line 598, in execute
    stmt = RE_PY_PARAM.sub(psub, stmt)
  File "/home/pi/.local/lib/python3.9/site-packages/mysql/connector/cursor.py", line 127, in __call__
    raise ProgrammingError(
mysql.connector.errors.ProgrammingError: Not enough parameters for the SQL statement

#!/usr/bin/env python3

import logging
from contextlib import closing
from datetime import datetime
from pathlib import Path
import mysql.connector
from gpiozero import DigitalInputDevice
from w1thermsensor import W1ThermSensor


LOGGING_FILE = Path("/home/pi/solarueberwachung/DS18B20_error.log")
PUMPE_STATUS_PIN = 27
ID_TO_SENSOR_NAME = {
    "d64e421f64ff": "S1",
    "3077421f64ff": "S2",
    "566a9c1e64ff": "S3",
}

USER = "andre"
PASSWORD = "solarueberwachung"
HOST = "localhost"
DATABASE = "solarueberwachung"


def insert_to_db(timestamp, sensor_name_to_temperature, pumpe):
    query = """
        INSERT INTO 
            solarueberwachung (
                datetime, 
                S1, 
                S2, 
                S3, 
                P1
            )
        VALUES 
            (%s, %s, %s, %s, %s, %s);
    """
    args = (
        timestamp,
        sensor_name_to_temperature["S1"],
        sensor_name_to_temperature["S2"],
        sensor_name_to_temperature["S3"],
        pumpe,
    )
    with closing(
        mysql.connector.connect(
            host=HOST, database=DATABASE, user=USER, password=PASSWORD
        )
    ) as connection:
        try:
            with connection.cursor() as cursor:
                cursor.execute(query, args)
        except Exception:
            connection.rollback()
            raise
        else:
            connection.commit()


def main():
    logging.basicConfig(
        filename=LOGGING_FILE,
        level=logging.DEBUG,
        format="%(asctime)s %(levelname)s %(name)s %(message)s",
    )

    logger = logging.getLogger(__name__)
    pump_status = DigitalInputDevice(PUMPE_STATUS_PIN)
    timestamp = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    sensor_name_to_temperature = {}
    for sensor in W1ThermSensor.get_available_sensors():
        sensor_name_to_temperature[
            ID_TO_SENSOR_NAME.get(sensor.id)
        ] = sensor.get_temperature()

    if pump_status.value:
        print("Pumpe ist AUS")
        pumpe = 0
    else:
        print("Pumpe ist AN")
        pumpe = 1

    print(sensor_name_to_temperature)
    insert_to_db(timestamp, sensor_name_to_temperature, pumpe)


if __name__ == "__main__":
    main()

MariaDB [solarueberwachung]> describe solarueberwachung;
+----------+----------+------+-----+---------+----------------+
| Field    | Type     | Null | Key | Default | Extra          |
+----------+----------+------+-----+---------+----------------+
| id       | int(11)  | NO   | PRI | NULL    | auto_increment |
| datetime | datetime | NO   |     | NULL    |                |
| S1       | int(3)   | YES  |     | NULL    |                |
| S2       | int(3)   | YES  |     | NULL    |                |
| S3       | int(3)   | YES  |     | NULL    |                |
| P1       | int(1)   | YES  |     | NULL    |                |
+----------+----------+------+-----+---------+----------------+
6 rows in set (0.004 sec)

#!/usr/bin/env python3

import logging
from contextlib import closing
from datetime import datetime
from pathlib import Path
import mysql.connector
from gpiozero import DigitalInputDevice
from w1thermsensor import W1ThermSensor

#OpenWeather
#https://www.youtube.com/watch?v=123Vz_3E0Zs
#https://github.com/csparpa/pyowm
from pyowm import OWM
from pyowm.utils import config
from pyowm.utils import timestamps

#OpenWeather
owm = OWM("1ffd413-OpenWeatherAPI")
mgr = owm.weather_manager()
observation = mgr.weather_at_place("Berlin, DE")
w = observation.weather

TAORG = w.temperature("celsius") # {'temp_max': 10.5, 'temp': 9.7, 'temp_min': 9.0}
TA= str(float(TAORG['temp'])) #DIe orginalTemp TAORG muss ins richtige Format gebracht werden,damit es in die Datenbank passt.
print("Es sind draußen " + TA + "°C ")

#Ab hier TempMessung
LOGGING_FILE = Path("/home/pi/heiztemp/DS18B20_error.log")
P1_STATUS_PIN = 22
P2_STATUS_PIN = 27
ID_TO_SENSOR_NAME = {
    "d64e421f64ff": "S1",
    "3077421f64ff": "S2",
    "566a9c1e64ff": "S3",
}

USER = "andre"
PASSWORD = "heiztemp"
HOST = "localhost"
DATABASE = "heiztemp"


def insert_to_db(timestamp, TA, sensor_name_to_temperature, p1, p2):
    query = """
        INSERT INTO 
            heiztemp (
                datetime,
                TA,
                S1, 
                S2, 
                S3, 
                P1,
                P2
            )
        VALUES 
            (%s, %s, %s, %s, %s, %s, %s);
    """
    args = (
        timestamp,
        TA,
        sensor_name_to_temperature["S1"],
        sensor_name_to_temperature["S2"],
        sensor_name_to_temperature["S3"],
        p1,
        p2,
    )
    with closing(
        mysql.connector.connect(
            host=HOST, database=DATABASE, user=USER, password=PASSWORD
        )
    ) as connection:
        try:
            with connection.cursor() as cursor:
                cursor.execute(query, args)
        except Exception:
            connection.rollback()
            raise
        else:
            connection.commit()


def main():
    logging.basicConfig(
        filename=LOGGING_FILE,
        level=logging.DEBUG,
        format="%(asctime)s %(levelname)s %(name)s %(message)s",
    )

    logger = logging.getLogger(__name__)
    pump1_status = DigitalInputDevice(P1_STATUS_PIN)
    pump2_status = DigitalInputDevice(P2_STATUS_PIN)
    timestamp = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    
    sensor_name_to_temperature = {}
    for sensor in W1ThermSensor.get_available_sensors():
 
        sensor_name = ID_TO_SENSOR_NAME.get(sensor.id)
        sensor_temp = sensor.get_temperature()
        
        print(
         f" Zeit: {timestamp} Sensor: {sensor_name}: {sensor_temp}°C"
        )
        sensor_name_to_temperature[
            ID_TO_SENSOR_NAME.get(sensor.id)
        ] = sensor.get_temperature()


    if pump1_status.value:
        print("P1 ist AUS")
        p1 = 0
    else:
        print("P1 ist AN")
        p1 = 1

    if pump2_status.value:
        print("P2 ist AUS")
        p2 = 0
    else:
        print("P2 ist AN")
        p2 = 1
    
    
    #print(sensor_name_to_temperature) #hiermit gibt er ein Dictonary aus
    insert_to_db(timestamp, TA, sensor_name_to_temperature, p1, p2)
    


if __name__ == "__main__":
    main()

CREATE USER andre@'localhost' IDENTIFIED BY 'heiztemp';
CREATE DATABASE heiztemp;
CREATE TABLE IF NOT EXISTS heiztemp.heiztemp (
id int auto_increment primary key,
datetime datetime not null,
TA dec(3,1),
S1 dec(3,1),
S2 dec(3,1),
S3 dec(3,1),
P1 int(1),
P2 int(1)
) ENGINE=innodb;
GRANT ALL ON heiztemp.heiztemp to andre@'localhost';
exit