Through python when connecting MySQL and assign vales to variables, datatype changed from 'int' to 'tuple'

Question

Comparatively new in both python and mysql.

I have solved the issue, but want to know the reason. If I use 'comma' after assigning the values to the variables, then it is changing the next datatype from 'int' to 'tuple'. For sting it is not. If I omit the 'comma' after each line then datatype remains as they are casting. In the both the cases, code exec without 'Exception'.

The DB input datatype are: func_Name as varchar, nbin as int, winWidth as int, ashFilt as varchar etc.

part of the code:-

cursor.execute("SELECT * FROM func_table;")
tab_funcTab = cursor.fetchall()
    print("parameters in [func_table]: ", cursor.rowcount)
    for row in tab_funcTab:
        funcName =      (str(row['func_Name'])), # <- this commas
        nbin =          (int(row['nbin'])), # <- this commas
        winWid =        (int(row['winWidth'])),
        ashFilt =       (str(row['ashFilt']))

     print(tab_funcTab)
     [{'id': 1, 'func_Name': 'all', 'nbin': 100, 'winWidth': 5, 'ashFilt': 'biweight']   

     print(type(funcName), type(nbin), type(winWid), type(ashFilt))
     <class 'str'> <class 'tuple'> <class 'tuple'> <class 'str'>

Could someone pl explain the reason?

loginmind · Accepted Answer · 2020-02-15 06:35:53Z

1

Using comma after value will exactly create a tuple. I have tested your code again with both python2, and 3. You need to check it again.

answered Feb 15, 2020 at 6:35

loginmind

6036 silver badges11 bronze badges

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

3 Comments

Fakir Over a year ago

Yes, I have seen that. When I take out the 'comma' the datatype are as I wish or expected. The comma is making the int as tuple. Though the str remain as str.

loginmind Over a year ago

No, I have tested with str, it also make a tuple. You can try this for test: y=(str(1)),;print(type(y))

Fakir Over a year ago

Is it? But after taking out the commas at the end of each line, (though kept the casting) it is coming as 'int', 'str' as expected. And using that values the main prog is also working fine. But thanks anyway for your time and suggestion. I will test yours and let you know.

Collectives™ on Stack Overflow

Through python when connecting MySQL and assign vales to variables, datatype changed from 'int' to 'tuple'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related