How to do Exception handling for mysql connection in python

Question

I'm new to python , I want to know how to do exception handling in python in a proper way.I want to raise an exception for failure of db connection.I also don't want to include all the lines of code in try block.I want to raise connection failure exception.How to do this?

try:
    conn = MySQLdb.connect(host="mysql", user="root", passwd="password"
                           , db="database")
    mycursor = conn.cursor()
    query = "INSERT INTO table1(col1,col2,col3)VALUES(%s,%s,%s)"
    val = (x,y,z)
    mycursor.execute(query, val)
    conn.commit()
    conn.close()
    print("Data inserted to db")
except Exception as ex:
    print(ex)

well, since you connect to mysql on second line you can just "try-except" this particular line, no need to handle other lines for connection failures — Volodymyr Vyshnevskyi
– Volodymyr Vyshnevskyi, Commented Mar 5, 2019 at 16:38

Sree · Accepted Answer · 2019-03-05 16:58:00Z

4

    conn = MySQLdb.connect(host="mysql", user="root", passwd="password"
                           , db="database")
    mycursor = conn.cursor()
    query = "INSERT INTO table1(col1,col2,col3)VALUES(%s,%s,%s)"  
    try:
        mycursor.execute(query, val)
    except MySQLdb.Error, e:
        try:
            print "MySQL Error [%d]: %s" % (e.args[0], e.args[1])
            return None
        except IndexError:
            print "MySQL Error: %s" % str(e)
            return None
    except TypeError, e:
        print(e)
        return None
    except ValueError, e:
        print(e)
        return None
    finally:
        mycursor.close()
        conn.close()

edited Mar 5, 2019 at 16:58

answered Mar 5, 2019 at 16:47

Sree

1,7581 gold badge19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

balderman · Accepted Answer · 2019-03-05 16:45:21Z

2

Something like:

connected = False
try:
    conn = MySQLdb.connect(host="mysql", user="root", passwd="password"
                           , db="database")
    connected  = True
except MySQLError as ex:
    print(ex)
if connected:
    mycursor = conn.cursor()
    query = "INSERT INTO table1(col1,col2,col3)VALUES(%s,%s,%s)"
    val = (x,y,z)
    mycursor.execute(query, val)
    conn.commit()
    conn.close()
    print("Data inserted to db")

answered Mar 5, 2019 at 16:45

balderman

24k8 gold badges39 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to do Exception handling for mysql connection in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related