QFirebug with Database profiling

Submitted by enzo on Mon, 03/16/2009 - 04:13

Hello folks

After integrate FirePHP in QCubed, I included support for Database Profiling, this option is so useful when you try to debug your queries ran in your ajax elements like panels or Datagrid Data bind functions.

This Profiling support I18N.

This is an example using profiling for a function to answer the event QAutoCompleteTextBoxEvent in a QAutoCompleteTextBox


public function txtProductName_Change($strFormId, $strControlId, $strParameter){

QApplication::$Database[1]->EnableProfiling();

$objProductArray = Inventory::QueryArray(
QQ::Like(QQN::Inventory()->Name,'%' . $strParameter .'%'),
QQ::Clause(QQ::OrderBy(QQN::Inventory()->Name),QQ::LimitInfo(20))
);

foreach($objProductArray as $objProduct){
echo QApplication::HtmlEntities($objProduct->Name)."\n";
}

QFirebug::OutputProfiling(QApplication::$Database[1]);
exit;
}

Check the attached picture for more reference, you know a picture talks more than million words.

Could you check the patch against QCubed 1.0.0 RC2

Enjoy

Regards

	Attachment	(click to download)
	QFirebug.patch	57.15 KB
	QFirebug-IncludePath.patch	875 bytes