Teradata Python module cursor result set is exhausted after one iteration

Question

I am experimenting Teradata python module tutorial here

I am executing a query and I want to iterate over the result set several times. The problem is that if i iterate over the result set once, I can't do it again. Looks like the result set is exhausted and no more available for any further computation.

Please see the below code for details and suggest how can I preserve the result set.

import teradata

class DB():
    def __init__(self):
        udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0",logConsole=False)
        session = udaExec.connect(method="odbc", system="tddemo",username="dbc", password="dbc")
        self.session = session

    def fun1(self):
        rows = self.session.execute("SELECT  databasename, ownername  FROM DBC.DATABASES  where DatabaseName='financial'")
        return rows

db = DB()
rows = db.fun1()

# This loop prints accurate result like
#Row 1: [financial, Samples]
for row in rows:
    print(row)

# This loop does not print anything
for row in rows:
    print(row)  

# This line also gets printed
print("The End")

score 2 · Accepted Answer · answered Jun 12 '16 at 18:12

2

Generators can only be iterated over once, use list or tuple to convert them, and then you can iterate over it multiple times:

rows = tuple(db.func1())

for row in rows:
    # do something

for row in rows: # would work
    # do something else

answered Jun 12 '16 at 18:12

noteness

2,010
12
14

Can you briefly explain what generators are? I'm new to python – Ali Jun 12 '16 at 18:25
@Ali This is a good intro: http://stackoverflow.com/questions/1756096/understanding-generators-in-python – noteness Jun 12 '16 at 18:27

Teradata Python module cursor result set is exhausted after one iteration

1 Answers1