python comparing database results against strings

Question

I am trying to compare the output of a MSSQL (pyodbc) query against a seemingly similar tuple of strings, and python keeps telling me that they don't match.

def test_internship_direct_app_a_submit(self):

    address_result = SQLHelper.address_result("""
    select top 2 blah, blah, blah
            """ ) 
    print address_result[0]
    print type(address_result[0])
    print address_result[0] == ('1819 Harras Blvd', '', 'Atlantic City', 'NJ', '08401')

Console Output: (u'1819 Harras Blvd', u'', u'Atlantic City', 'NJ', u'08401')

type 'pyodbc.Row'

False

Question: how can manipulate the output from the database in order for it to be easily compared to a list of strings in a tuple? Thanks in advance

Oh, and here is the code in python I use to fetch the data:

def address_result(sql, param1):
cnxn = pyodbc.connect(connect_string)
cursor = cnxn.cursor()

params = (param1)
cursor.execute(sql ,params)
rows = cursor.fetchall()

addresses= []
for row in rows:
    addresses.append(row)


cursor.close()
cnxn.close()
return addresses

Try printing out what your database returned. That might offer a clue. — Jonathan Vanasco
– Jonathan Vanasco, Commented Feb 5, 2013 at 21:25
If I type in those two tuples I get True as expected but 'pyodbc.Row' isn't a Tuple but it's repr looks like one. You'll need to convert it to a Tuple. On their site they say Note that slicing rows returns tuples, not Row objects! does that mean address_result[0][:] would be OK? — sotapme
– sotapme, Commented Feb 5, 2013 at 21:27
Are the string data types defining the MSSQL columns char fields or varchar? If the full number of characters isn't used up in char fields, then a bunch of spaces will be returned with the value. Ex: if the address column has a data type of char(20), then 1819 Harras Blvd will actually be returned as 1819 Harras Blvd[space][space][space] . — Joshua Burns
– Joshua Burns, Commented Feb 5, 2013 at 21:29
I am doing a very similar thing but i am looking for the most effecient way as I have very large datasets, both db results and lists — Drewdin
– Drewdin, Commented Oct 8, 2014 at 0:38

Benji York · Accepted Answer · 2013-02-05 21:32:54Z

2

The problem is that the objects being returned from the database are of type pyodbc.Row not real tuples.

Add this to the end of your test script and attain enlightenment:

print tuple(address_result[0]) == ('1819 Harras Blvd', '', 'Atlantic City', 'NJ', '08401')

answered Feb 5, 2013 at 21:32

Benji York

2,06016 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

python comparing database results against strings

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