Python to MySQL Database: What exception handling
<p>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 ?</p>

<p>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:</p>

<pre><code>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()
</code></pre>

<p>please note that i have very little experience in python programming</p>