Yii 1.1: cthesql

Active Record Behavior that outputs the raw SQL generated by a given Data Provider
13 followers

Active Record Behavior that outputs the raw SQL generated by a given Data Provider.

If your like me, then you have had occasion to want to see or manipulate the raw SQL generated by a Data Provider. CTheSQL does just that.

Requirements

Tested on Yii 1.1.11...

Usage

Example 1

$model = new MyModelName('search');
 
$sql = $model->sql; //Default Data Provider is 'search'
 
echo $sql;

Example 2

model = new MyModelName('search');
 
$model->attributes = $_GET['MyModelName'];
 
$dataProvider = $model->searchGrid();
 
$dataProvider->criteria->addCondition('t.status > 0');
 
$sql = $model->getSql($dataProvider); //optional 2nd param tableAlias default = 't'
 
echo $sql;

Installation

  • Extract or clone to your application.extensions folder

  • Add the following to your main config:

'import'=>array(..,'ext.CTheSQL.*',)
  • Add CTheSQL behavior to your desired model(s):
public function behaviors(){ return array(..,'CTheSQL'=>'ext.CTheSQL.CTheSQL',); }

Resources

CTheSQL on GitHub

Be the first person to leave a comment

Please to leave your comment.

Create extension
Downloads