Import statements for timeit module

[ChaosKCW]

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,

import cx_Oracle
import timeit

def VerifyTagIntegrity(con, TableOwner):
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)
timer = timeit.Timer('cur.execute(sql)', 'from __main__ import
cur')
print timer.timeit()

 

[bruno at modulix]

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,

import cx_Oracle
import timeit

def VerifyTagIntegrity(con, TableOwner):
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)
timer = timeit.Timer('cur.execute(sql)', 'from __main__ import
cur')
print timer.timeit()

'cur' is local to the function, so it's not an attribute of your module,
so you can't hope to import it anyway.

 

[ChaosKCW]

So timeit is mostly useless then ?

 

[Alex Martelli]

So timeit is mostly useless then ?

No, it's a precious jewel, but if you want to use it you must allow it
to import the code you want it to run.


Alex

 

[Scott David Daniels]

....>
'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:
timer = timeit.Timer('cur.execute(sql)', ###
'from __main__ import cur, sql') ###

 

[bruno at modulix]

So timeit is mostly useless then ?

I wouldn't say so.