子查询ActiveRecord Yii [英] Sub-queries ActiveRecord Yii

问题描述

是否可以在Yii的ActiveRecord中进行子查询?

Is it possible to make sub-queries in ActiveRecord in Yii?

我有这样的查询:

select * from table1 where table1.field1 in (select table2.field2 from table2)

select * from table1 where table1.field1 in (select table2.field2 from table2)

我当前正在使用休闲代码:

i'm currently using the fallowing code:

object1::model()->findAll(array('condition'=>'t.field1 in (select table2.field2 from table2)'))

我想知道是否有一种方法可以在不使用SQL且不使用联接的情况下构造子查询.

i would like to know if there is a manner to construct the sub-query without using SQL, and without using joins.

有什么解决办法吗?

在此先感谢

推荐答案

首先通过db字段查找doublet:

First find doublets by db fields:

$model=new MyModel('search');
$model->unsetAttributes();

$criteria=new CDbCriteria();
$criteria->select='col1,col2,col3';
$criteria->group = 'col1,col2,col3';
$criteria->having = 'COUNT(col1) > 1 AND COUNT(col2) > 1 AND COUNT(col3) > 1';

获取子查询:

$subQuery=$model->getCommandBuilder()->createFindCommand($model->getTableSchema(),$criteria)->getText();

添加子查询条件:

$mainCriteria=new CDbCriteria();
$mainCriteria->condition=' (col1,col2,col3) in ('.$subQuery.') ';
$mainCriteria->order = 'col1,col2,col3';

使用方法:

$result = MyModel::model()->findAll($mainCriteria);

或者:

$dataProvider = new CActiveDataProvider('MyModel', array(
        'criteria'=>$mainCriteria,
));

来源: http://www.yiiframework.com/wiki/364/using-sub-query-for-doubletts/

这篇关于子查询ActiveRecord Yii的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！