fgh151/yii2-postgresql-array-field

Yii2 postgresql jsonb field support behavior

yii2-postgresql-array-field

Yii2 postgresql object field support behavior, _(*1)

================, _(*2)

Provides PostgreSQL object fields support for yii2 models., _(*3)

Installation

Add a dependency to your project's composer.json:, _(*4)

{
    "require": {
        "fgh151/yii2-postgresql-array-field": "*"
    }
}

Migration example

$this->createTable('UserReward', [
    'jsonField' => fgh151\PostgresqlJsonb\db\Schema::TYPE_JSONB
]);

Usage example

Attach behavior to one or more fields of your model

use yii\db\ActiveRecord;
use \fgh151\PostgresqlJsonb\PostgresqlJsonbFieldBehavior;

/**
 * @property array $modelField
 */
class Model extends ActiveRecord{
    public function behaviors() {
        return [
            [
                'class' => PostgresqlJsonbFieldBehavior::className(),
                'arrayFieldName' => 'modelField', // model's field to attach behavior
                'onEmptySaveNull' => true // if set to false, empty array will be saved as empty PostreSQL array '{}' (default: true)
            ]
        ];
    }
}

$model->jsonField->property = 'value';
$model->jsonField->otherProperty->otherPropertyValue = 'another value';