102 Commits

Author SHA1 Message Date
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
73ac13e6d7 Implement retrieving dbms constraints 2017-05-15 20:55:25 +03:00
d7fad8a555 Fixes #14059: Removed unused AR instantiating for calling of static methods 2017-04-26 16:09:55 +03:00
6da1ec6fb2 Fixes #13845: mt_rand() is not used instead of rand() in yii\captcha\CaptchaAction + minor code improvements 2017-03-24 13:50:13 +03:00
1b322f519f Fixes #13776: Fixed setting precision and scale for decimal columns in MSSQL 2017-03-16 19:38:56 +03:00
a9fb0171f7 Fixes #13745: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in MSSQL and bug fixes in yii\db\QueryBuilder::buildLikeCondition() 2017-03-11 22:36:01 +03:00
9a915ba10c Fixes #8120: Fixes LIKE special characters escaping for Cubrid/MSSQL/Oracle/SQLite in yii\db\QueryBuilder 2017-02-24 01:24:06 +03:00
0ea45c78a8 Fixes #13571: Fix yii\db\mssql\QueryBuilder::checkIntegrity for all tables 2017-02-22 16:57:32 +03:00
56c65f6079 Fixes #13577: Implemented yii\db\mssql\QueryBuilder::resetSequence() 2017-02-20 14:54:33 +03:00
cc37cd626f Fixes #12599: Fixed MSSQL fail to work with nvarbinary. Enhanced SQL scripts compatibility with older versions 2017-01-23 10:31:52 +03:00