db
db copied to clipboard
yiisoft
Yii Database Library
Improve performance | Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ❌ | Breaks BC? | ❌ | Fixed issues | -
| Q | A | ------------- | --- | Is bugfix? | ✔️ | New feature? | ✔️ | Breaks BC? | ✔️/❌
* `DbArrayHelper::getColumn()` should be replaced with `array_column()` * `DbArrayHelper::getValueByPath()` are not suitable for db fields and shold be removed E.g. `$key` can be `table_name.column` what will be result of an...
| Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ✔️ | Breaks BC? | ❌
For some cases a query like `SELECT 1 FROM ...` required. If allow scalars `int|float|bool` for columns in `Query::select()` method, the result could be `$query->select(1)` => `SELECT 1 FROM ...`...
For example, in Cycle it implemented so: https://github.com/cycle/database/blob/331a16879523ee4209d9090c5bf20d0e62e72159/src/Query/SelectQuery.php#L119
The method should return all types defined by user. `public function getUserDefinedTypes(string $schemaName = '', bool $refresh = false): array;`
Currently, is avaliable only when manually escape value. See here: https://github.com/yiisoft/db/blob/03dc4342c5e0943e21c7307d01ca708258a2a105/src/QueryBuilder/Condition/Builder/LikeConditionBuilder.php#L87
This is a draft to see new concept of columns for version 2.0 Main changes: 1. Removed `ColumnSchema::$name` and `ColumnSchema::$precision` (use `ColumnSchema::$size`) 2. Renames `ColumnSchema::$enumValues` to `ColumnSchema::$values` (related with some...
* Remove `AbstractDMLQueryBuilder::getTypecastValue()` method * Remove `string $table` argument from `AbstractDMLQueryBuilder::normalizeColumnNames()` and `AbstractDMLQueryBuilder::getNormalizeColumnNames()` * Remove `SchemaInterface::TYPE_JSONB` constant * Remove `TableSchemaInterface::compositeForeignKey()` method * Remove argument `bool $withColumn = false` from `Quoter::getTableNameParts()`...