Hi. Just to give full details, I put this static function into a custom DB
debug class that extends Zend_Db. Also the function (for more brute force(!)
needs) accepts a boolean to force the output stream to terminate.
Then, you can simply cal this function anywhere you need by:
Database_Debug ::dumpSQL();
Hope you find it useful. I've been working with ZF only for a short while,
but I really like it - sorry if this way is not the best(!) way to debug but
I find this a quite useful way to quickly debug SQL calls.
class Database_Debug extends Zend_Db
{
/**
* The Class constructor.
*
* @param void
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Dumps the last constructed SQL statement into the output stream.
*
* @param boolean $exit - Whether to exit the output stream.
* @return void
*/
public static function dumpSQL($exit = true)
{
$db = Zend_Db_Table::getDefaultAdapter();
$dbProfiler = $db->getProfiler();
$dbQuery = $dbProfiler->getLastQueryProfile();
$dbSQL = $dbQuery->getQuery();
print_r($dbSQL);
if ($exit)
{
exit;
}
}
}
Regards,
Narinder.
--
on 29/03/2010 14:58, Sergio Rinaudo at [email protected] wrote:
>
> Very nice :)
> Thank you!
>
> Sergio Rinaudo
>
>
>> Date: Mon, 29 Mar 2010 09:09:04 +0100
>> From: [email protected]
>> To: [email protected]
>> Subject: Re: [fw-general] Get query and error messages from $db->update
>>
>> Hi. Something like this will work:
>>
>> public function dumpSQL()
>> {
>> $db = Zend_Db_Table::getDefaultAdapter();
>> $dbProfiler = $db->getProfiler();
>> $dbQuery = $dbProfiler->getLastQueryProfile();
>> $dbSQL = $dbQuery->getQuery();
>>
>> print_r($dbSQL);
>> }
>>
>> Regards,
>>
>> Narinder.
>> --
>>
>> ______________________________________________________
>> | Narinder Chandi, Director,
>> | ToolBox Systems Limited, Surrey, England, UK.
>> | tel : +44 (0)1372 720117, mob : +44 (0)7973 512495
>> | www : http://www.toolbox.uk.com
>> | Skype : NarinderChandi
>> | LinkedIn : http://www.linkedin.com/in/toolboxsystems
>> | Twitter : @ToolBoxSystems
>> |______________________________________________________
>> | Consultancy * Development * Support
>> |______________________________________________________
>>
>>
>> on 29/03/2010 09:01, Sergio Rinaudo at [email protected] wrote:
>>
>>>
>>> Hi everybody,
>>> if I construct an update query programmatically using Zend_Db, how can I get
>>> this query and how to get what is the problem if the query fails?
>>> Thanks
>>>
>>> Sergio Rinaudo
>>>
