Sergei Tigrov comments

Results 111 comments of


                                            Sergei Tigrov

Realize `ReadOnlyActiveRecord`

Seems `readonly` class is not suitable due to relations stored in `$relation` property. And the relations can be loaded in several operations.

Base refresh materialized view

Added this to the 2.0.0 milestone due to (almost) any change of interfaces breaks BC

Set default `$currentOrder` in `Sort` class

Usually it's in ascending order.

Set default `$currentOrder` in `Sort` class

By default sort by all fields in ascending order

Set default `$currentOrder` in `Sort` class

If we use `KeysetPaginator`, then sorting is required. In case `$currentOrder` is not set, we can use the first field from the configuration. If multiple fields are required for sorting,...

Unique indexes can be loaded in 3 different ways

Related with https://github.com/yiisoft/db/blob/12b89274270adc85603348a4d27e8c7d97fad617/src/QueryBuilder/AbstractDMLQueryBuilder.php#L342-L359

Unique indexes can be loaded in 3 different ways

Fixed

Add posibility to drop table `IF EXISTS` and `CASCADE`

In cases when DBMS does not support functionality we use complex queries like [https://github.com/yiisoft/db-mssql/blob/eb4e5ef9eb7de1fb340b9c4bb894f921d4cad882/src/DDLQueryBuilder.php#L237](https://github.com/yiisoft/db-mssql/blob/eb4e5ef9eb7de1fb340b9c4bb894f921d4cad882/src/DDLQueryBuilder.php#L237)

insertBatch to generate multiple INSERT statements

Good point, but 1. It is better if it works by default. Currently it does not work. 2. The documentation should mention this. By default it is better to specify...

Bug Report: Issue with `getTableNames` in Yii2 Schema Handling on sqlite3 database

Current Yii SQLite driver does not support scheme names. From the [documentation](https://www.sqlite.org/lang_createtable.html) > If a schema-name is specified, it must be either "main", "temp", or the name of an [attached...