111 Commits

Author SHA1 Message Date
ed9de17357 Sync to master branch. (#20401) 2025-06-09 12:03:50 -04:00
97a4d711ec Merge branch 'master' into sync-master-2052. 2025-04-26 19:03:07 -04:00
7037fd46ab Fix #20355: Fix SQL syntax for resetting sequence in QueryBuilder for MSSQL 2025-04-19 23:15:28 +03:00
883e1d81fc update links (#20219) 2024-06-30 20:45:04 +03:00
52e4a3e645 release version 2.0.50 2024-05-30 20:23:31 +03:00
20d6c65db2 Merge branch 'master' into sync-to-master. 2024-03-20 06:11:31 -03:00
e2a167028b Upgrade to PSR12 coding standard (#20121) 2024-03-19 17:21:27 +03:00
751bea079d Remove deprecated methods to QueryBuilder::class. 2023-09-22 09:45:35 -03:00
79c83ba7db Fix #9899: Fix caching a MSSQL query with BLOB data type 2023-07-24 10:03:18 +03:00
0b4d5aaafa Fix #19520: Fix for TIMESTAMP & ROWVERSION columns in MSSQL insert query 2022-11-13 21:26:49 +03:00
161526cd41 HTTPS everywhere (#19503) 2022-08-03 12:32:18 +03:00
4628b91e73 Fix types (#19332)
* Migration::upsert() returns void

* Unneeded `@property` tags

* Add missing `null` param/return types

* Null types for db\Query + db\ActiveQuery

* Fixed testSelect
2022-03-30 18:40:10 +02:00
d5a428e001 Fix some code smells (#18696) 2021-06-05 13:37:45 +03:00
7966fe47e6 Scrutinizer fixes (#18685)
* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/filters/AccessRule.php?selectedLabels%5B0%5D=2&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/helpers/BaseFileHelper.php?selectedLabels%5B0%5D=2&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/base/Application.php?selectedLabels%5B0%5D=7&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/base/Module.php?selectedLabels%5B0%5D=7&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/web/MultipartFormDataParser.php?selectedLabels%5B0%5D=7&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/web/Session.php?selectedLabels%5B0%5D=7&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/base/Controller.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/console/controllers/MigrateController.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* Added vardocs, and small refactor

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/db/conditions/InConditionBuilder.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/db/Connection.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/db/mssql/QueryBuilder.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/log/Logger.php?selectedLabels%5B0%5D=6&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/console/controllers/BaseMigrateController.php?selectedLabels%5B0%5D=18&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* Adding space between type

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/console/controllers/CacheController.php?selectedLabels%5B0%5D=18&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/console/controllers/FixtureController.php?selectedLabels%5B0%5D=18&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* https://scrutinizer-ci.com/g/yiisoft/yii2/issues/master/files/framework/console/controllers/MigrateController.php?selectedLabels%5B0%5D=18&selectedSeverities%5B0%5D=10&selectedSeverities%5B1%5D=5&orderField=path&order=asc&honorSelectedPaths=0

* Update framework/console/controllers/CacheController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/CacheController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

* Update framework/console/controllers/FixtureController.php

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>

Co-authored-by: Alexander Makarov <sam@rmcreative.ru>
2021-05-31 21:07:36 +03:00
f14b2ccd89 remove duplicate code 2021-04-28 18:32:43 +03:00
a7ee99ce92 Update framework/db/mssql/QueryBuilder.php
Co-authored-by: Bizley <pawel@positive.codes>
2021-04-28 18:28:20 +03:00
2d76f33dd4 Fixes after review 2021-04-27 12:15:31 +03:00
12ccd2adde Update framework/db/mssql/QueryBuilder.php
Co-authored-by: Bizley <pawel@positive.codes>
2021-04-27 12:09:32 +03:00
a0552f1680 Update framework/db/mssql/QueryBuilder.php
Co-authored-by: Bizley <pawel@positive.codes>
2021-04-27 12:09:14 +03:00
a1cc222927 Update framework/db/mssql/QueryBuilder.php
Co-authored-by: Bizley <pawel@positive.codes>
2021-04-27 12:08:06 +03:00
4fba562cd0 New attemp 2021-04-26 19:24:14 +03:00
9367af4b15 Fix for issue #18604 2021-04-25 20:19:14 +03:00
64ecbf10b1 Fix for issue #18526
DbCache doesn't working using MSSQL/SqlServer
2021-03-15 22:47:54 +03:00
9883b78214 Fix #18448: Fix issues in queries and tests for older MSSQL versions 2020-12-24 17:37:07 +03:00
7c7c7148f6 Fix #18287: Fix the OUTPUT got SQL syntax error if the column name is MSSQL keyword e.g key 2020-12-09 00:09:11 +03:00
7a50da5cf8 Fix #18287: Fix for OUTPUT INSERTED and computed columns. Added flag to computed values in table schema 2020-10-04 21:44:18 +03:00
4b2af4d2a4 Bug #13973: Correct alterColumn for MSSQL & drop constraints before drop column
Fixing #11158 and #13973
2020-09-08 12:50:32 +03:00
a624c31698 Fix #18198: Fix saving tables with trigger by outputting inserted data from insert query with usage of temporary table 2020-08-05 09:39:05 +03:00
d317e41b21 Fix #18101: Fix behavior of OUTPUT INSERTED.* for SQL Server query: "insert default values"; correct MSSQL unit tests; turn off profiling echo message in migration test 2020-06-14 14:20:21 +03:00
5c01dc75ae Fix #13828, Fix #17474: Fix retrieving inserted data for a primary key for SQL Server 2005 or later
- Bug #13828: Fix retrieving inserted data for a primary key of type uniqueidentifier for SQL Server 2005 or later.
- Bug #17474: Fix retrieving inserted data for a primary key of type trigger for SQL Server 2005 or later.

The OUTPUT clause is new to SQL Server 2005 and has the ability to access the INSERTED and DELETED tables as is the case with a trigger.
2020-06-06 22:44:40 +03:00
559206bc78 Fix #17635: Fix varbinary data handling for MSSQL 2020-01-16 19:19:34 +03:00
cdd40b8dfb Fix #17504: Fix upsert when $updateColumns = true but there are no columns to update in the table 2019-08-21 11:56:20 +03:00
b66a6133dc release version 2.0.24 2019-07-30 18:17:45 +03:00
9988efc04f Fix #16796: Fixed addition and removal of table and column comments in MSSQL 2019-07-23 18:50:57 +03:00
6fc04a622e Fix #17219: Fixed quoting of table names with spaces in MSSQL 2019-07-19 13:48:57 +03:00
55b06d2364 Fix #17413: Fixed MSSQL tests: QueryBuilderTest::testGetColumnType(), QueryBuilderTest::testResetSequence() 2019-07-09 11:47:55 +03:00
b0f2a52219 Fixes #16748: Fixed params when normalize data 2018-10-02 01:24:39 +03:00
cb15a413a7 Fix ODBC Driver 13 for SQL Server error on null (#16039) 2018-04-29 11:05:11 +03:00
ac687aab29 Fixed yii\db\Command::upsert() for Cubrid/MSSQL/Oracle 2018-02-24 19:59:12 +03:00
22832b7c49 release version 2.0.14 2018-02-19 00:27:09 +02:00
089685975a Wrap @inheritdoc tag in curly brackets [skip ci] 2018-02-19 00:16:19 +02:00
df91a9608f Fixes #14638: Added yii\db\SchemaBuilderTrait::tinyInteger() 2018-02-12 12:01:21 +03:00
e6f5c46cdc Fixes #15633: Deprecate some things going away/changing in 2.1
- Deprecated `yii\base\BaseObject::className()` in favor of native PHP syntax `::class`, which does not trigger autoloading
- Deprecated XCache and Zend data cache support as caching backends
- Deprecated `yii\BaseYii::powered()` method
- Added `yii\base\InvalidArgumentException` and deprecated `yii\base\InvalidParamException`
- Added `yii\BaseYii::debug()` and deprecated `yii\BaseYii::trace()`
2018-02-11 01:48:29 +03:00
de1750228d Fixes #13879: Added upsert support for yii\db\QueryBuilder and yii\db\Command 2018-02-09 01:05:50 +03:00
d16586334d Fixes #7640: Implemented custom data types support. Added JSON support for MySQL and PostgreSQL, array support for PostgreSQL 2018-02-05 04:59:14 +07:00
65f6b59b35 @inheritdoc notation changed 2018-01-23 13:11:24 +02:00
5a8c3d537b Enable phpdoc_summary rule in php-cs-fixer config (#14675)
* Enable `phpdoc_summary` rule in php-cs-fixer config.

* Fix case in "PHPDoc".
2017-08-21 11:19:35 +02:00
1501c659ac Add empty lines before return statements. (#14682) [skip ci] 2017-08-21 01:58:49 +03:00
fe8a0a6a2e Enable no_useless_else rule in php-cs-fixer (#14420) 2017-07-10 11:26:21 +03:00
164d3c83e9 Have I fixed these phpdocs? Let’s see… 2017-07-03 15:10:48 +03:00