When building propel query, is it possible to get final SQL as string?

U039B0RUXMF

When building propel query, is it possible to get final SQL as string?

Alberto Reyer

Only via debugger when it's executed (\Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor::executeStatement) which has the advantage that you can see the passed in parameters as well.

You can also set $config[PropelConstants::PROPEL_DEBUG] = true to log all queries into a log file.

U017Y69D9U4

I think on the query object you can call toString() or something similar which should give you the actual SQL query?

Alberto Reyer

Only via debugger when it's executed (\Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor::executeStatement) which has the advantage that you can see the passed in parameters as well.

You can also set $config[PropelConstants::PROPEL_DEBUG] = true to log all queries into a log file.