Sergei Tigrov
Sergei Tigrov
@santilin Could you make a PR for yii2 to support scheme names?
https://github.com/yiisoft/yii2/blob/master/docs/internals/git-workflow.md Usually a PR should contain: - code that solves the problem - validation tests - updated documentation (if needed) - a line in the CHANGELOG file
Yes, it looks like this. And use `ForeignKeyConstraint[]` instead of associative arrays.
> Perhaps the solution could be use `AbstractSchema::getTableMetadata()` into `Schema::findConstraints()` of each DB specific package? Or `AbstractSchema::getTableForeignKeys()`
Suggestion to use one way to get foreign keys `Schema::getTableForeignKeys()` and do not store them in `TableSchemaInterface` as for indexes
This could be done by one of the following ways: 1. By default for `...Join()` methods process condition of associative array as `"column name" => "column name"`, e.g. `['parent.id' =>...
Tests and doc added - https://github.com/yiisoft/db-mysql/pull/370 - https://github.com/yiisoft/db/pull/910
For an array attribute of Active Record model expecting that the query returns an array result. Try this ```php $model=Test::find()->select([new \yii\db\Expression('data[1:1]')])->one(); ```
> What's the support in other DBs? * `Pgsql`, `Mssql`, `Oracle` support `arrays` but `db` package has realization only for `Pgsql`; * `Mysql`, `Pgsql`, `Sqlite`, `Mssql`, `Oracle` support `json` but...