Changes between Version 115 and Version 116 of DeveloperGuidelines/Tips

Timestamp:

11/16/11 10:39:56 (13 years ago)

Author:

Fran Boon

Comment:

Web2Py query debugging

DeveloperGuidelines/Tips

@@ -15 +15 @@
 calframe = inspect.getouterframes(curframe, 2)
 print 'caller name:', calframe[1][3]
+}}}
+ * Debug SQL Queries:
+{{{
+vi gluon/dal.py
+class BaseAdapter()
+    def select():
+        def response(sql):
+            if "searchphrase" in sql:
+                print >> sys.stderr, "Query: %s" % query
+                print >> sys.stderr, "SQL: %s" % sql
 }}}
  * [http://aymanh.com/python-debugging-techniques Python Debugging Techniques]