db

db copied to clipboard

yii\db\command execute() don't handle errors on multiple queries

17

### What steps will reproduce the problem? Try to import db schema (from mysqldump or PhpMyAdmin schema export) with some error on non-first query. In example, change "int" column type...

tomaszkane

Query::all() with interator result

1

### What steps will reproduce the problem? Yii 2.x (and also Yii 1.x) `Query::all()` result is very limited. Main problems: - loading all record it once - larger memory requirement...

kamarton

DB CASE WHEN in SELECT

33

New feature, adding the possibility to use CASE WHEN in yii\db\Query ## DB support for CASE WHEN - [x] MySQL - [x] PostgreSQL - [ ] MSSQL - [ ]...

mariuszkrzaczkowski

Add some id to SQL statements

3

Reviewing the executed SQL statements in the debug toolbar or SQL log file is difficult to identify where they created. It would be very convenient to add id to the...

uldisn

Command::update() - add ability to pass Query to UPDATE FROM

2

``` php $db = db()->createCommand(" UPDATE bet SET status = subquery.winr FROM (:subquery) AS subquery WHERE bet.id = subquery.id ", ['subquery' => new Expression($this->leadersQuery()->select(['id', 'winr'])->createCommand()->rawSql)])->execute(); //->update(/*the truth is out there*/);...

exru

copyTable function for Command like renameTable

16

we should add one function `copyTable($table,$newName,$onlyStructure = true)` I hope it could provide a function to copy table efficient ## Funding * You can sponsor this specific effort via a...

zuoRambo

Add method batchUpdate in \yii\db\QueryBuilder

6

Very often in practice I have to do a bulk update of rows. IN PostgreSQL: ```sql UPDATE table AS t SET col1 = c.col1, col2 = c.col2 FROM (VALUES (1,...

dimmitri

Расширение QueryBuilder::buildSelect() для агрегирующих функций

2

### What steps will reproduce the problem? Нет гибкого конструктора для создания запросов с агрегирующими функциями. ### What is the expected result? Простой и гибкий конструктор в QueryBuilder::buildSelect() для формирования...

sergeiterehov

Retry DB transaction on deadlock in multi-master replication

6

Feature request for discussion. When the DB server uses multi-master replication, conflict can occur when clients of different replication masters write to the same row. In the case of Galera...

tom--

Please add a longtext type in the schema builder!

i-panov