Hi! I was previously (web2py 2.18.5) using postgres:pg8000 adapter and a dummy connection string with the parameter do_connect=False in order to be able to generate SQL query strings without actually connecting to any database.
I see that with the latest version (2.20.4) the "do_connect" was removed, and on post by Massimo on this group he says the connection will be delayed until it is really required. Unfortunately this doesn't seem to be 100% accurate, since either the DAL initialization or the _select method is triggering a connection to the database, requiring me to have a valid DB connection, even though I never actually send the query to the database. Is there a way to get the SQL without requiring a valid DB connection? (I know its an odd setup, a portion on my "BD" is actually behind an web API and all I need is to push a SQL string. I can of course reuse the credentials for portion of data that sits on a standard SQL database, and open a connection to it just to generate SQL string, but I would like to avoid that if possible). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/c4d373dd-021a-4ab7-985d-5000132b0e3cn%40googlegroups.com.
