Connect MySQL with Python (GUI)

Question

I'm trying to connect a MySQL database with python GUI. But this part of code returns a empty set. I'm not sure what's wrong with my code because there are no error codes... Please help!

def ButtonPressed (self):
    print("Finding Parts!")
    self.ProdNum = self.aVar.get()
    print("Entry text was:", self.ProdNum)

    self.db = mysql.connector.connect (user='ezhu', password='<password>', host='127.0.0.1', database='centricsit_prices')
    self.query = ("SELECT sd, sy, price FROM css_hp WHERE prod_num = '%s'")
    self.cursor = self.db.cursor()
    self.cursor.execute (self.query, (self.ProdNum))
    self.results = self.cursor.fetchall()
    print (self.results)
    self.cursor.close()

@alecxe: well, not like 127.0.0.1 would be of any use in getting at OP's database... — Marc B
– Marc B, Commented Mar 22, 2016 at 21:17

alecxe · Accepted Answer · 2016-03-22 21:16:52Z

1

You are missing the comma:

self.cursor.execute (self.query, (self.ProdNum, ))
                                          HERE^

It is quite important since the query parameters are expected to be passed as an iterable. Comma would make it a tuple. Without a comma, you are passing query parameters as a string, which is also an iterable, hence your query is parameterized with a first character of self.ProdNum, hence nothing matched by the select query.

edited Mar 22, 2016 at 21:16

answered Mar 22, 2016 at 21:13

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

1 Comment

Tomasz Dzieniak Over a year ago

This is what rapid debugging is called. Nice spot.

Collectives™ on Stack Overflow

Connect MySQL with Python (GUI)

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related