84 Commits

Author SHA1 Message Date
161526cd41 HTTPS everywhere (#19503) 2022-08-03 12:32:18 +03:00
395dc70468 Merge branch 'master' into fix/db-pgsql-raw-sql-params 2021-04-01 23:49:53 +03:00
335385d7ba Db pgsql getRawSql params replace fix 2021-04-01 19:37:50 +03:00
42e8aa4ea5 Fix #18325: Fix yii\db\pgsql\Schema to respect non-default PgSQL schema name for data types
Co-authored-by: SilverFire - Dmitry Naumenko <d.naumenko.a@gmail.com>
2021-04-01 00:52:02 +03:00
54f25c4b04 Fix #17174: Fix yii\db\BaseActiveRecord::unlink() to not ignore on conditions in via relations 2021-03-14 19:04:07 +03:00
5558ee793b Fix #18040, fix #15265, fix #18232 database issues (#18225)
- Bug #18040: Display width specification for integer data types was deprecated in MySQL 8.0.19
- Bug #15265: PostgreSQL > 10.0 is not pass tests with default value of timestamp CURRENT_TIMESTAMP
- Bug #18232: Fail tests pgsql v-10.14, v-11.9, v-12-latest
2020-09-10 20:36:04 +03:00
bc180ac20d Fix #17745: Fix PostgreSQL query builder drops default value when it is empty 2019-12-18 14:27:10 +03:00
09eacd8dc1 Bug #17597: PostgreSQL 12 and partitioned tables support (batyrmastyr)
* yiisoft#17597, pg_constraint.consrc removed in Postgres 12

* yiisoft#17597, load schema for partitioned tables (introduced in Postgres 10)

* messed up with issue number

* #yiisoft#17597 Postgres 12 support, support GENERATED AS IDENTITY columns

* uncleared FileCache leads to falsy failures on subsequent test runs

* moved .sql for postgres 10 and 12 to separate files, added ResetSequence test for GENERATED AS IDENTITY column
2019-10-18 14:57:24 +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
56215d58e1 Fixes #12077, #12135, #17263: Fixed PostgreSQL version of alterColumn() to accept properly ColumnSchemaBuilder definition of column 2019-04-30 21:08:00 +04:00
b4adada51e Fixes #16022: Fix UniqueValidator for PostgreSQL. Checks the uniqueness of keys in jsonb field 2018-12-05 00:06:51 +03:00
292a545642 Fixes #16104: Fixed yii\db\pgsql\QueryBuilder::dropIndex() to prepend index name with schema name 2018-05-31 17:37:14 +03:00
c6ea3fb455 Revert "Fixed JsonExpressionBuilder to generate SQL NULL"
This reverts commit cf4bd39fc1927c3cbe85c08c6fc473d60921d96f.
2018-03-10 11:11:11 +02:00
cf4bd39fc1 Fixed JsonExpressionBuilder to generate SQL NULL
Fixes #15863
2018-03-10 10:04:41 +02:00
aed911b5f1 Fixed nesting of JsonExpression, ArrayExpression 2018-03-08 12:45:01 +02:00
4e35eb6539 Fixed JSONB support in PostgreSQL 9.4
Closes #15829
2018-03-04 20:25:36 +02:00
f7da602250 PgSQL: Fix table schema load for table name in quotes
This commit fixes the table schema loading for PostgreSQL, when
the table name is specified in quotes, e.g. `"type"`.
2018-03-04 20:19:45 +02:00
66081c6187 Added a unit test to verify #15827
Closes #15827
2018-03-03 22:31:42 +02:00
5fa25b331d Fixed encoding of empty ArrayExpression for PostgreSQL 2018-03-03 20:43:58 +02:00
d5d4b8b0f5 Fixed null values handling for PostgresSQL arrays
Fixes #15804
2018-03-03 18:54:33 +02:00
dc452b7e24 Fixed multiple JSON-related issues (#15732) 2018-02-23 23:07:04 +02:00
6c8b87f3e2 Implemented \Traversable in ArrayExpression (#15733)
* Implemented \Traversable in ArrayExpression

* Fix punctuation [skip ci]
2018-02-23 22:50:06 +02:00
2eba4b54f8 Added tests to verify issue #15684 2018-02-20 23:03:58 +02:00
e806a3b50a Added yii\db\ExpressionInterface support to yii\db\Command::batchInsert()
Fixes #15661
2018-02-18 20:23:08 +02:00
df91a9608f Fixes #14638: Added yii\db\SchemaBuilderTrait::tinyInteger() 2018-02-12 12:01:21 +03:00
de1750228d Fixes #13879: Added upsert support for yii\db\QueryBuilder and yii\db\Command 2018-02-09 01:05:50 +03:00
ecf3ef8bf9 Use root NS specification for opcoded functions 2018-02-08 00:00:36 +03:00
40b038379f Fixes #13019: Support JSON in SchemaBuilderTrait 2018-02-06 16:35:49 +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
4e176ca325 Fixes #15108: Fixed yii\db\Schema::getSchemaNames() for MSSQL and added tests for all DBMSes 2017-11-07 19:20:14 +03:00
7e7faeebd1 Fixed excess escaping in Command::batchInsert() (#13236) 2017-10-23 22:43:39 +03:00
b0148a5e8f Added test to check issue #14274 2017-10-06 18:08:48 +03: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
0c0942d6e2 Enable phpdoc_add_missing_param_annotation rule in php-cs-fixer config. (#14681) [skip ci] 2017-08-21 01:57:23 +03:00
c8856ccd4e Fix merging issues & CS 2017-06-17 01:02:01 +03:00
f820d2ca36 Merge branch 'master' into db-constraints 2017-06-16 16:52:43 +03:00
ba0ab403b5 Added php-cs-fixer coding standards validation to Travis CI (#14100)
* php-cs-fixer: PSR2 rule.

* php-cs-fixer: PSR2 rule - fix views.

* Travis setup refactoring.

* Add php-cs-fixer to travis cs tests.

* Fix tests on hhvm-3.12

* improve travis config

* composer update

* revert composer update

* improve travis config

* Fix CS.

* Extract config to separate classes.

* Extract config to separate classes.

* Add file header.

* Force short array syntax.

* binary_operator_spaces fixer

* Fix broken tests

* cast_spaces fixer

* concat_space fixer

* dir_constant fixer

* ereg_to_preg fixer

* function_typehint_space fixer

* hash_to_slash_comment fixer

* is_null fixer

* linebreak_after_opening_tag fixer

* lowercase_cast fixer

* magic_constant_casing fixer

* modernize_types_casting fixer

* native_function_casing fixer

* new_with_braces fixer

* no_alias_functions fixer

* no_blank_lines_after_class_opening fixer

* no_blank_lines_after_phpdoc fixer

* no_empty_comment fixer

* no_empty_phpdoc fixer

* no_empty_statement fixer

* no_extra_consecutive_blank_lines fixer

* no_leading_import_slash fixer

* no_leading_namespace_whitespace fixer

* no_mixed_echo_print fixer

* no_multiline_whitespace_around_double_arrow fixer

* no_multiline_whitespace_before_semicolons fixer

* no_php4_constructor fixer

* no_short_bool_cast fixer

* no_singleline_whitespace_before_semicolons fixer

* no_spaces_around_offset fixer

* no_trailing_comma_in_list_call fixer

* no_trailing_comma_in_singleline_array fixer

* no_unneeded_control_parentheses fixer

* no_unused_imports fixer

* no_useless_return fixer

* no_whitespace_before_comma_in_array fixer

* no_whitespace_in_blank_line fixer

* not_operator_with_successor_space fixer

* object_operator_without_whitespace fixer

* ordered_imports fixer

* php_unit_construct fixer

* php_unit_dedicate_assert fixer

* php_unit_fqcn_annotation fixer

* phpdoc_indent fixer

* phpdoc_no_access fixer

* phpdoc_no_empty_return fixer

* phpdoc_no_package fixer

* phpdoc_no_useless_inheritdoc fixer

* Fix broken tests

* phpdoc_return_self_reference fixer

* phpdoc_single_line_var_spacing fixer

* phpdoc_single_line_var_spacing fixer

* phpdoc_to_comment fixer

* phpdoc_trim fixer

* phpdoc_var_without_name fixer

* psr4 fixer

* self_accessor fixer

* short_scalar_cast fixer

* single_blank_line_before_namespace fixer

* single_quote fixer

* standardize_not_equals fixer

* ternary_operator_spaces fixer

* trailing_comma_in_multiline_array fixer

* trim_array_spaces fixer

* protected_to_private fixer

* unary_operator_spaces fixer

* whitespace_after_comma_in_array fixer

* `parent::setRules()` -> `$this->setRules()`

* blank_line_after_opening_tag fixer

* Update finder config.

* Revert changes for YiiRequirementChecker.

* Fix array formatting.

* Add missing import.

* Fix CS for new code merged from master.

* Fix some indentation issues.
2017-06-12 12:25:45 +03:00
2b7e8be1e8 Fixes #14192: Fixed wrong default null value for TIMESTAMP when using PostgreSQL 2017-06-11 18:48:15 +03:00
73ac13e6d7 Implement retrieving dbms constraints 2017-05-15 20:55:25 +03:00
d8e6a89af9 fixed tests without assettions 2017-04-13 16:17:35 +03:00
3f8e8a89eb Used more specific unit test assertions in framework tests 2017-03-14 09:45:31 +03:00
fab53b4a6e Fixes #13582: Added tests for all yii\db\QueryBuilder::resetSequence implementations, fixed SQLite implementation 2017-02-20 23:04:04 +03:00
323568c2e9 Remove trailing spaces from sources and tests (#13621) [skip ci] 2017-02-19 17:34:22 +03:00
3692941ead Fixes #11464: Foreign key name is not provided by schema 2017-01-16 00:27:20 +03:00
df733d1bbe Fixed QueryBuilderTest 2016-12-17 22:08:13 +02:00
2f8225a244 Fixed QueryBuilderTest to work with PgSQL and other DBMS 2016-12-17 21:58:22 +02:00
f76f0cff6c Test against the current hhvm version (#12971)
* Test against the current hhvm version

This provides the current HHVM version (3.15.2 as of this PR) and will track with each release (i.e. will be 3.16 when 3.16 is released.

If testing against HHVM LST versions is desired follow this guide. https://docs.travis-ci.com/user/languages/php#HHVM-versions

Should be able to change to container based Trusty after Q1-17 https://blog.travis-ci.com/2016-11-08-trusty-container-public-beta/

* Try to create travis user for trusty hhvm and grant permissions

remove conditionals for apc and memcache

* more tweaks to grant privileges

* try 127.0.0.1 rather than localhost

* grant after db create

* try a different create user grant privileges form

* try to specify postgresql: "9.3" for hhvm

* need to look more into specifying postgresql: "9.3"

hhvm issues

* addon with no dash postgresql: "9.3"

* requested change && not ||

* redis-server isn't needed here

* Apply @cebe's patch for pgsql test failure

* Update .travis.yml

* Update CommandTest.php

* Update CommandTest.php

* Update CommandTest.php

try to fix hhvm tests

* Update CommandTest.php
2016-11-15 16:50:41 +01:00
24809c5d73 fixed group annotations for #12889 2016-11-10 23:46:05 +01:00
4aa935e69e Fixes #12055: Changed boolean to bool and integer to int in phpdoc 2016-11-07 02:51:39 +03:00
560e3eb0a3 Unit tests created for ActiveQuery (#12889)
* setup ActiveQueryTest

* basic unit tests for ActiveQuery are created:
- all protected & public methods are covered
- method return types are tested
- some functions are already full tested, others are supplied with @todo

* fix driver for mssql

* fix ::class to className()

* remove OCI tests
2016-11-01 20:48:58 +01:00