Debug Executed Sql in Python

Question

I am executing some sql in python as follows

statement = "select * from TEST_TABLE"
debug("Statement: %s" % (statement, ))
cursor = gblDBConnection.cursor()
cursor.execute(statement)

I can debug the statement using a debug function I have written but would also like to debug the actual values returned ie after sql execution.

Is there a way of doing this?

Fabian · Accepted Answer · 2012-11-05 12:56:40Z

1

statement = "select * from TEST_TABLE"
cursor = gblDBConnection.cursor()
values = cursor.execute(statement)
debug(values)

?

answered Nov 5, 2012 at 12:56

Fabian

4,3481 gold badge22 silver badges32 bronze badges

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

1 Answer 1