Converting from Tuple to List to modify in Python

Question

I am querying a Oracle database and need some special handling around one column of data that is a clob. I can read in the clobe with .read(). I'd like to write the actual value back to my array. It's a tuple so I must convert to a list, write the value, then convert back to tuple. I am getting the error message: TypeError: 'tuple' object does not support item assignment

My Code:

import cx_Oracle

# USE THIS CONNECTION STRING FOR PRODUCTION
production_username = 'username'
production_password = 'password'

con_string = '%s/%s@hostname:port/orcl' % (production_username, production_password)
con = cx_Oracle.connect(con_string)
cursor = con.cursor()
querystring = ("Select ID, Description from Table")
cursor.execute(querystring)
data = cursor.fetchall()

for currentrow in range(1, len(data)): 
     description= data[currentrow][1].read()
    data = list(data)
    data[currentrow][1] = description
    data = tuple(data)
con.close()
print data

@bernie can you elaborate on what you mean about storing data structures? — user2242044
– user2242044, Commented Aug 21, 2014 at 5:30

sundar nataraj · Accepted Answer · 2014-08-21 05:28:54Z

1

Try this way

for currentrow in data : 
     description= currentrow[1].read()
     tupled_data= tuple([currentrow[0],description])


print tupled_data

answered Aug 21, 2014 at 5:28

sundar nataraj

8,7202 gold badges36 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Converting from Tuple to List to modify in Python

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