o read-back the SQL string used in Query() in Web.Py/Python
2.7<http://stackoverflow.com/questions/14526012/how-to-read-back-the-sql-string-used-in-query-in-web-py-python-2-7>
up vote0down
votefavorite<http://stackoverflow.com/questions/14526012/how-to-read-back-the-sql-string-used-in-query-in-web-py-python-2-7#>
**
I'm making a connection to a MySql database, in Python 2.7 & Web.Py, using
the Query() method for escaped input and advanced SQL queries.
A very simplified example follows:
conn = web.database(dbn = 'mysql', db = 'database_name', user = 'db_user_name',
pw = "db_password")
db_rows = db.conn.query("SELECT * FROM table WHERE value=$my_value AND
string=$username", vars={'my_value':17, 'username':"String"})for row in db_rows:
etc
This is all working fine, but I want to be able to debug things by running
the same query directly on MySQL, so I can see/validate the results.
To do this, I need to be able to see the whole SQL string that was used,
together with the injected variables.
Is there any way to read back the actual string that MySql is using for the
query?
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/webpy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
