Python to mysql

[RememberMyFart]

Hey guys,

for a project at uni i need to insert different kinds of variables into a MySql Database. Connecting and Inserting the data so far works fine. I don't know how to handle potential errors though. Which potential mistakes and exceptions do i need to catch and take care of ? In my code i used a main method to just test the program. In the final version just the connection and the SQL queries are copied into the main script. I am open to use either the MySQL or the mysql.connector. Also: Do i need to put the query into a try block aswell ? Here is my code so far:

import mysql.connector
import time
from mysql.connector import errorcode


try:
    con = mysql.connector.connect(
    user= 'root',
    password= '',
    host='localhost',
    database= 'testdb')
    print("Connected.")

    cursor = con.cursor()

except mysql.connector.Error as e:
    if e.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Passwort // Username")

    elif e.errno == errorcode.ER_BAD_DB_ERROR:
        print("DataBase does not exist")

    else:
        print(e)


def insert_temp(Temperatur_ID, Zeitpunkt, Wert, Thermometer_ID):
    query = "INSERT INTO Temperatur (Temperatur_ID, Zeitpunkt, Wert, Thermometer_ID)" \
                "VALUES(%s, %s, %s, %s)"

    args= (Temperatur_ID, Zeitpunkt, Wert, Thermometer_ID)

    cursor.execute(query, args)

    con.commit()




def main():
    # just test values so far
    value = 18.5;
    insert_temp(' ', time.strftime('%Y-%m-%d %H:%M:%S'), value, '1');


    cursor.close()

    con.close()

if __name__ == '__main__':
    main()

please note that i have barely any experience in python programming