xj / yii2-xunsearch
yii2-xunsearch
1.0.0
2014-08-06 03:22 UTC
Requires
- yiisoft/yii2: *
This package is auto-updated.
Last update: 2024-11-10 19:57:35 UTC
README
composer.json
"require": { xj/yii2-xunsearch: "*" },
Configure Components
return [ 'components' => [ 'xunsearch' => [ 'class' => 'xj\\xunsearch\\Connection', //Put Xunsearch ini to $configDirectory 'configDirectory' => '@common/config/xunsearch', ], ], ];
Create ActiveRecord
class Demo extends \xj\xunsearch\ActiveRecord { public static function primaryKey() { return ['pid']; } public function rules() { return [ [['pid', 'subject', 'message'], 'required'] ]; } public function attributes() { return [ 'pid', 'subject', 'message', ]; } }
INSERT
$model = new Demo(); $model->setAttributes([ 'pid' => 1, 'subject' => 'haha', 'message' => 'hehe', ]); $model->save();
QUERY
//where syntax $models = Demo::find()->where([ 'wild', 'key1', '-key2', // key1 -key2 'wild', 'key1', 'key2', 'key3', // key1 key2 key3 'pid' => [5, 6, 7], // (pid:5) OR (pid:6) OR (pid:7) 'pid' => 5, // pid:5 'and', 'key1', 'key2', 'key3', // (key1) AND (key2) AND (key3) 'or', '5', '6', '7', // (5) OR (6) OR (7) 'and', '啊', ['or', 'pid:30', 'pid:31'] // (啊) AND ((pid:30) OR (pid:31)) ])->all(); var_dump($models); //asArray $models = Demo::find()->where([ 'wild', 'key1', '-key2', // key1 -key2 ])->asArray()->all();
UPDATE
$model = Demo::findByPk(1); $model->subject = 'mod subject'; $model->save();
DELETE
$model = Demo::findByPk(1); $model->delete();
COUNT
$count = Demo::find()->where([ 'wild', 'key1', ])->count();
Work with ActiveDataProvider
$query = Demo::find(); $dataProvider = new \yii\data\ActiveDataProvider([ 'query' => $query, ]); $models = $dataProvider->getModels(); var_dump($models);