Python Error connecting with MySQL

Question

I am getting error message when I have con.close()- mysql.connector.errors.OperationalError: [Errno 9] Bad file descriptor
I am getting error message when I remove con.close()- mysql.connector.errors.InterfaceError: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10054

Any suggestion? Thx
Below is my query:

import mysql.connector
class databaseConnection:
    def __init__ (self,settings ): 
        cur=settings.cursor()

        selectstmt=("SELECT qSQL FROM TBLTEST WHERE id = 4")
        cur.execute(selectstmt)
        res=cur.fetchone()
        qSQL=res[0]
        cur.execute(qSQL)
        qSQLresults=cur.fetchall()
        for row in qSQLresults:
            id= row[0]
            city= row[1]
            state=row[2]
            insertstmt=("""INSERT into FACTRESTTBL (id, city, state) 
                           values (%d, '%s', '%s')""" % (id, city, state))
            cur.execute(insertstmt)
            con.commit() 
        con.close() # 

print 'done'

con=mysql.connector.connect(host="localhost", 
                            user="root", 
                            password="test", 
                            database="test")
databaseobject = databaseConnection(con)

--

Aside: you should pass the parameters as a second argument to .execute() to guard against SQL-injection attack. — mechanical_meat
– mechanical_meat, Commented Feb 20, 2013 at 20:57
I did similar to: stackoverflow.com/questions/14863692/… So I used con.close() How would you " pass the parameters as a second argument to .execute() to guard against SQL-injection attack" — Mario
– Mario, Commented Feb 20, 2013 at 21:09
Like this: cur.execute(insertstmt, (id, city, state)). And you would change all your placeholders to the appropriate placeholder for the module you are using. Some use ?, others use %s. — mechanical_meat
– mechanical_meat, Commented Feb 20, 2013 at 21:15
In either case, it seems that your connection is being terminated prematurely. There may be a configuration you can set for a higher timeout period. — mechanical_meat
– mechanical_meat, Commented Feb 20, 2013 at 21:31

Mario · Accepted Answer · 2013-03-05 00:13:37Z

0

When I run the script on Vim on server, it works.

answered Mar 5, 2013 at 0:13

Mario

2,4935 gold badges22 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Python Error connecting with MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related