xj/yii2-xunsearch

1.0.0 2014-08-06 03:22 UTC

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);