yii2-pgsql
Improved PostgreSQL schemas for Yii2.
Yii 2.0.14 and above supports array and json DB types.
Supports follow types for ActiveRecord models:
array, Yii 2.0.14 and above supportsarrayDB typejson, Yii 2.0.14 and above supportsjsonDB typecomposite, https://www.postgresql.org/docs/current/static/rowtypes.htmldomain, https://www.postgresql.org/docs/current/static/sql-createdomain.html- fixes type
bit, issue #7682 - converts Postgres types
timestamp,dateandtimeto PHP type\DateTimeand vice versa.
Limitation
Since version 1.2.0 requires Yii 2.0.14 and above.
You can use version 1.1.11 if you have Yii 2.0.13 and below.
Installation
The preferred way to install this extension is through composer.
Either run
php composer.phar require --prefer-dist tigrov/yii2-pgsql
or add
"tigrov/yii2-pgsql": "~1.0"
to the require section of your composer.json file.
Configuration
Once the extension is installed, add following code to your application configuration:
return [
//...
'components' => [
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'pgsql:host=localhost;dbname=<database>',
'username' => 'postgres',
'password' => '<password>',
'schemaMap' => [
'pgsql'=> 'tigrov\pgsql\Schema',
],
],
],
];Specify the desired types for a table
CREATE TABLE public.model (
id serial NOT NULL,
attribute1 text[],
attribute2 jsonb,
attribute3 timestamp DEFAULT now(),
CONSTRAINT model_pkey PRIMARY KEY (id)
);Configure Model's rules
/**
* @property string[] $attribute1 array of string
* @property array $attribute2 associative array or just array
* @property integer|string|\DateTime $attribute3 for more information about the type see \Yii::$app->formatter->asDatetime()
*/
class Model extends ActiveRecord
{
//...
public function rules()
{
return [
[['attribute1'], 'each', 'rule' => ['string']],
[['attribute2', 'attribute3'], 'safe'],
];
}
}Usage
You can then save array, json and timestamp types in database as follows:
/**
* @var ActiveRecord $model
*/
$model->attribute1 = ['some', 'values', 'of', 'array'];
$model->attribute2 = ['some' => 'values', 'of' => 'array'];
$model->attribute3 = new \DateTime('now');
$model->save();and then use them in your code
/**
* @var ActiveRecord $model
*/
$model = Model::findOne($pk);
$model->attribute1; // is array
$model->attribute2; // is associative array (decoded json)
$model->attribute3; // is \DateTime