Where to define in Python class, mysql connection?

Question

So, I just got started today with python. I installed the python-mysql.connector so I can start writing some queries and within python work with the result, and then output some data to an lcd screen.

Right know this is what I have....

#!/usr/bin/python

import Adafruit_CharLCD
import mysql.connector

class LCDTests:

    def __init__(self):

        self.lcd = Adafruit_CharLCD;
        #self.lcd.begin(16,1);

        try:
            cnx = mysql.connector(user = '', password='' database='', host='')
        except mysql.connector.Error, e:
            try:
                print "MySQL Error [%d]: %s" % (e.args[0], e.args[1])
            except IndexError:
                print "MySQL Error: %s" % str(e)            
        else:
                cnx.close()

    def run(self):
            print('alex')
            #lcd.message('loading...');

test = LCDTests()
test.run()

But when ever I run ./test.py I keep getting the following output:

Traceback (most recent call last):
  File "./test.py", line 31, in <module>
    test = LCDTests()
  File "./test.py", line 16, in __init__
    cnx = mysql.connector(user = '...', password='...', database='...', host='...')
TypeError: 'module' object is not callable

Nothing what I found, while searching for the issue, really helped me fixing the issue... any ideas where the issue might be?

cmd · Accepted Answer · 2013-04-09 22:17:19Z

4

mysql.connector.connect(...) not mysql.connector(...)

module docs will probably be a good resource for you.

edited Apr 9, 2013 at 22:17

answered Jan 16, 2013 at 18:12

cmd

5,88819 silver badges31 bronze badges

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

Comments

Thomas Orozco · Accepted Answer · 2013-01-16 18:12:13Z

2

The proper syntax is mysql.connector.connect(user, password, host, database).

answered Jan 16, 2013 at 18:12

Thomas Orozco

55.6k12 gold badges120 silver badges120 bronze badges

Comments

R A · Accepted Answer · 2013-01-16 19:42:24Z

0

You have a typo. Currently you are referencing the module mysql.connector not the Connect class in the module. try

mysql.connector.Connect(...)

answered Jan 16, 2013 at 19:42

R A

1622 silver badges7 bronze badges

Collectives™ on Stack Overflow

Where to define in Python class, mysql connection?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related