实现了 Active Record、Active Query
Yii2 SSDB GII 扩展开发中...
github: https://github.com/myweishanli/yii2-ssdb
注: 功能正在开发中...
更详细的配置说明文档正在编写中...
QQ群: 137158108 验证信息: github
有任何疑问可以发邮件到 myweishanli@gmail.com
安装这个扩展的首选方式是通过 composer.
执行
composer require myweishanli/yii2-ssdb:dev-master
或添加
"myweishanli/yii2-ssdb": "dev-master"
高级版是common/config/main-local.php
基础版是config/web.php
'components' => [
// ...
'ssdb' => [
'class' => 'wsl\ssdb\Connection',
'host' => 'localhost',
'port' => 8888,
],
],common/models/ssdb/User.php
/**
* This is the ActiveRecord class for [[\common\models\User]].
*
* @property string $user_id
* @property string $name
* @property integer $age
* @property integer $status
*/
class User extends \wsl\ssdb\ActiveRecord
{
public static $modelClass = '\common\models\User';
}默认只能使用单个主键排序 更多排序查询自定义排序规则
实际项目可能需求非常复杂，如果下方例子不能满足你的要求可以加QQ群探讨
$userModel = new User();
$userModel->user_id = 1000000;
$userModel->name = '张三';
$userModel->age = 19;
$userModel->status = 0;
$userModel->save();$model = User::find()->one();$model = User::find()->orderBy('user_id asc')->one();User::deleteAll();$model = User::find()->andWhere(['user_id' => 1000000])->one();$model = User::find()->andWhere(['user_id' => 1000000, 'age' => 19])->one();$models = User::find()->all();$models = User::find()->orderBy('age desc')->all();$models = User::find()->andWhere(['user_id' => 1000000])->all();$models = User::find()->offset(1)->limit(1)->all();$dataProvider = new ActiveDataProvider([
'query' => User::find(),
'pagination' => [
'pageSize' => 20,
],
]);
foreach ($dataProvider->getModels() as $itemModel) {
// code...
}