Import statements for timeit module

[Scott David Daniels]

bruno at modulix wrote:
> ChaosKCW wrote:
> 
>>Hi
>>
>>I was wondering if someone could help with the import statements needed
>>to use the timeit module in the following code. I need to access the
>>"cur" object.
>>
>>Thanks,
>>
...>
> 'cur' is local to the function, so it's not an attribute of your module,
> so you can't hope to import it anyway.

Although you could change your code as follows:

 >>import cx_Oracle
 >>import timeit
 >>
 >>def VerifyTagIntegrity(con, TableOwner):
       global cur, sql  ###
 >>    cur = con.cursor()
 >>    sql = 'select (select count(*) from %s.f4111) as F4111_COUNT,
 >>(select count(*) from %s.f4111_tag) as TAG_COUNT from dual;' %
 >>(TableOwner, TableOwner)
 >>    print "      SQL: %s" % (sql)
XXX>>  timer = timeit.Timer('cur.execute(sql)', 'from __main__ import
 >>cur')
       timer = timeit.Timer('cur.execute(sql)',   ###
                            'from __main__ import cur, sql') ###
 >>    print timer.timeit()

-- 
-Scott David Daniels
scott.daniels at acm.org