well, i know that repeating (query) is somehow strange, i believe the
main reason is that *compile()**.process*are not bound to the query
anymore (*i might be wrong*). well, for me it was a one time solution,
perhaps a little digging can bring you a better approach :)
cheers,
richard.
On
yeah, well, that's much simpler. in my scenario, where i had to use this
piece of code, literal_binds are necessary since the query is somehow
huge, with lots of alias and parameters :)
On 04/22/2015 11:07 AM, Mike Bayer wrote:
On 4/22/15 8:27 AM, Richard Gerd Kuesters wrote:
hi,
you
Hi Richard,
thanks, your solution works. ( I don't need formatted output)
However using *query* twice in the expression looks to me a bit awkward.
Isn't there some shortcut?
Dne středa 22. dubna 2015 14:27:41 UTC+2 Richard Kuesters napsal(a):
hi,
you must use a specific dialect so
Hi Mike, your solutions works too. Thanks to you both!
Dne středa 22. dubna 2015 16:07:28 UTC+2 Michael Bayer napsal(a):
On 4/22/15 8:27 AM, Richard Gerd Kuesters wrote:
hi,
you must use a specific dialect so sqlalchemy can create it for you. not
the best usage, imho, but here it
On 4/22/15 8:27 AM, Richard Gerd Kuesters wrote:
hi,
you must use a specific dialect so sqlalchemy can create it for you.
not the best usage, imho, but here it goes:
*stmt = query.compile().process(query, literal_binds=True)*
OK since Pavel noted the double compile, if you want the
Just be warned of this method -- make sure you're using the most recent
SqlAlchemy version in the .9x or 1.x branches. Earlier versions would not
apply LIMIT or OFFSET into the bind.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe
Hello,
I have pythonic application which imports custom module written in C++
using boost::python.
The module creates database connection(s) and executes queries.
The python calls various methods on that module and passes plain SQL into
them. Results are then returned to python.
I would like
hi,
you must use a specific dialect so sqlalchemy can create it for you. not
the best usage, imho, but here it goes:
*stmt = query.compile().process(query, literal_binds=True)*
i don't know if you want it formated or what, if so, *sqlparse*provides
a good way to do it.
but, again, this