it freezed and i tried debugging. it seems to be a recursive dead lock
problem.
def timer(db,f):
import time,os
import gluon.portalocker
myfile=open(os.path.join
(request.folder,'databases','sql.log'),'a')
print "locking"
gluon.portalocker.lock(myfile, gluon.portalocker.LOCK_EX)
t0=time.time()
print "pre f()"
f()
t0=time.time()-t0
print "unlocking"
gluon.portalocker.unlock(myfile)
myfile.write('%s: %s\n' % (t0,db._lastsql))
db['_execute']=lambda *a,**b: timer(db,lambda:db._execute(*a,**b))
and the output
locking
pre f()
locking
-vince
On Dec 22, 6:20 pm, mdipierro <[email protected]> wrote:
> grr
>
> db['_execute']=lambda *a,**b: timer(db,lambda:db._execute(*a,**b))
>
> On Dec 22, 4:17 am, vince <[email protected]> wrote:
>
> > db._execute=lambda *a,**b: timer(db,lambda:db._execute(*a,**b))
> > File "gluon/sql.py", line 305, in __setattr__
> > raise SyntaxError, 'Object exists and cannot be redefined'
> > SyntaxError: Object exists and cannot be redefined
>
> > On Dec 22, 5:43 pm, mdipierro <[email protected]> wrote:
>
> > > db=SQLDB(...)
> > > def timer(db,f):
> > > import time,os
> > > import gluon.portalocker
> > > myfile=open(os.path.join
> > > (request.folder,'databases','sql.log'),'a')
> > > gluon.portalocker,lock(myfile, gluon.portalocker.LOCK_EX)
> > > t0=time.time()
> > > f()
> > > t0=time.time()-t0
> > > gluon.portalocker,unlock(myfile)
> > > myfile.wriite('%s: %s\n' % (t0,db._lastsql)
> > > db._execute=lambda *a,**b: timer(db,lambda:db._execute(*a,**b))
>
> > > On Dec 22, 2:54 am, vince <[email protected]> wrote:
>
> > > > db._lastsql only record the last sql query right? is that any easy way
> > > > to log all the sql query it's executing to a file like sql.log does
> > > > for table update? i think it's really useful for preference fine tune.
>
> > > > -vince
>
> > > > On Dec 22, 4:26 pm, mdipierro <[email protected]> wrote:
>
> > > > > Will think about it but for now:
>
> > > > > def timer(myfile,db,f):
> > > > > import time
> > > > > t0=time.time()
> > > > > f()
> > > > > t0=time.time()-t0
> > > > > myfile.wriite('%s: %s\n' % (t0,db._lastsql)
>
> > > > > myfile=open('mylogfile.log','w')
> > > > > rows=timer(myfile,db,lambda:db(db.table.id>0).select())
>
> > > > > Massimo
>
> > > > > On Dec 22, 1:04 am, Jonathan Benn <[email protected]> wrote:
>
> > > > > > Hi,
>
> > > > > > On Dec 22, 4:52 am, vince <[email protected]> wrote:
>
> > > > > > > also is it possible to enable logging for all SQL query execution?
>
> > > > > > Logging with a timer included would be really handy.
>
> > > > > > Sincerely,
>
> > > > > > --Jonathan
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
