Committing mysql query with python

Question

I'm having trouble committing an insert statement.

It seems that python can't call the db object and I do not understand why.

Error:

On line self.db.commit()

[-] ERROR:  'NoneType' object has no attribute 'commit'

Code:

class Database(object):    
    def __init__(self):
        self.db = self.db_connect()

    def db_connect(self):
        try:
            self.db = MySQLdb.connect(host=MYSQL_HOST, 
                                    user=MYSQL_USER, 
                                    passwd=MYSQL_PWD, 
                                  db=MYSQL_DATABASE) 
            print '[+] Connected to {db} database'.format(db=MYSQL_DATABASE)
            self.cur = self.db.cursor()
        except Exception as e:
            print '[-] ERROR: ',e

    def add_email(self, email):
        try:            
            self.cur.execute('INSERT INTO User (email) VALUES (%s)', (email))           
            self.db.commit()
            print '[+] Added {email} to User(email) '.format(email=email)
        except Exception as e:
            print '[-] ERROR: ',e
            print '[*] Rolling back'
            self.db.rollback()

NPatel · Accepted Answer · 2014-04-04 10:13:27Z

2

Your function def db_connect not return any thing. Means it returns None.

As per your code

def __init__(self):
    self.db = self.db_connect() # db_connect return None

set self.db as None and when you try to commit, it gives error.

answered Apr 4, 2014 at 10:13

NPatel

21.4k17 gold badges104 silver badges166 bronze badges

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

Collectives™ on Stack Overflow

Committing mysql query with python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related