python close mysql database connection

Question

I have a python script which uses a MySQL database connection, I want the database connection to be closed when the instance of the class does no longer exist therefore in my class I implemented a disconnect method as follows:

def disconnect(self):
    '''Disconnect from the MySQL server'''
    if self.conn is not None:
        self.log.info('Closing connection')
        self.conn.close()
        self.conn = None
        self.curs = None

Now I was thinking of calling this method as follows:

def __del__(self):
    self.disconnect()

However I've read that you cannot assume that the __del__ method will ever be called, if that is the case, what is the correct way? Where / when should I call the disconnect() method?

Important sidenote is that my script is running as a unix daemon and is instantiated as follows:

if __name__ == '__main__':
    daemon = MyDaemon(PIDFILE)
    daemonizer.daemonizerCLI(daemon, 'mydaemon', sys.argv[0], sys.argv[1], PIDFILE)

The above takes the class MyDaemon and creates an Unix Daemon by executing a double fork.

adamr · Accepted Answer · 2014-04-08 12:04:37Z

2

Maybe you could use with statment and populate __exit__ method. For example:

class Foo(object):

  def disconnect(self):
    '''Disconnect from the MySQL server'''
    if self.conn is not None:
        self.log.info('Closing connection')
        self.conn.close()
        self.conn = None
        self.curs = None
        print "disconnect..."

  def __exit__(self, *err):
    self.disconnect()

if __name__ == '__main__':
  with Foo() as foo:
    print foo, foo.curs

answered Apr 8, 2014 at 12:04

adamr

7506 silver badges20 bronze badges

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

1 Comment

Gio Over a year ago

I think this could be indeed the solution, however I'm not sure if it works in my specific situation as I'm running my script as a Unix daemon, I've edited my question to include this aspect.

Collectives™ on Stack Overflow

python close mysql database connection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related