github.com/yiisoft/db-oracle commits | Ecosyste.ms: OpenCollective

Merge branch '8573-oci-schema-number-mapping' of https://github.com/vbelogai/yii2 into vbelogai-8573-oci-schema-number-mapping

fc919c559c176aba65f8fd20dbdded9befafc8d5 authored almost 9 years ago by SilverFire - Dmitry Naumenko <[email protected]>

Add `after()` option to migrations schema builder

a3a741dab22c16044feac62ae011ce559cba7b9a authored almost 9 years ago by Chris Harris <[email protected]>

Fixes #9443: Added `unsigned()` to `ColumnSchemaBuilder`

6ea34ab43903095a6b6e234344574b4b5dff5d6c authored almost 9 years ago by Alexander Makarov <[email protected]>

Global DOCS update: ~~~ replaced with ```

9bc63a74ec343eb0e5625ea4c4feebd9c0fc7b87 authored almost 9 years ago by SilverFire - Dmitry Naumenko <[email protected]>

Use === instead of == where possible

2bad521d176a00751192138c809e54e33c5ed179 authored about 9 years ago by Alexander Makarov <[email protected]>

Better quotes usage in strings

- Use single quote where interpolation isn't necessary
- Use interpolation when it's better than...

481592a7fac1eaece848a4ccd4659e2eca9d18cc authored about 9 years ago by Alexander Makarov <[email protected]>

Fix phpdoc

8bd757d3dd35f8c79a3206b124e8a8f93fcbf97f authored about 9 years ago by jeicd <[email protected]>

add oracle support (need tested)

b51f4775e7ee19131f018ef9b34604302e24ad34 authored about 9 years ago by Matvey Vasenin <[email protected]>

some test case added

6618c54f73f4494b2977266022a6ebcf8d4377ce authored about 9 years ago by Matvey Vasenin <[email protected]>

proper fix for #8844, convert array before using it

fixes #9415

3c077ff336d538f7455081c9084c3af30f1709ce authored about 9 years ago by Carsten Brandt <[email protected]>

refactored SchemaBuilder

- rename class to ColumnSchemaBuilder as this is more appropriate
- changed internal organisatio...

92e0d87a3c89dbf56b65f06db3e5abbf8b81ba64 authored about 9 years ago by Carsten Brandt <[email protected]>

updated some comments and `@since` annotations

ba89e2469c1d56c550358c03620d47ae0a74504c authored about 9 years ago by Carsten Brandt <[email protected]>

various code style and whitespace adjustments

de5d8a3fb7de3a375b08e24e7967516e31ce7d65 authored about 9 years ago by Carsten Brandt <[email protected]>

fixed: Oracle 11g 11.2.0.1.0 ORA-03113: end-of-file on communication channel

This is a workaround for an oracle bug:
https://code.google.com/p/yii/issues/detail?id=1779

clo...

b699d83c7392383d632bdaffb7e55502cb4a2250 authored about 9 years ago by nidgetgod <[email protected]>

Improved `SchemaBuilder` implementation

12eaac6a1bb6d5a8164fd5ab92e1dc89d248c43c authored over 9 years ago by Matvey Vasenin <[email protected]>

Improved `SchemaBuilder` docs, refactored code

fb1fe87e58dc8e6dd286b489fddc0d9f9db97153 authored over 9 years ago by pana1990 <[email protected]>

Implemented `SchemaBuilder`

55091f0ccb0eab6532d906ecb31432ac86446cff authored over 9 years ago by Matvey Vasenin <[email protected]>

PSR-2 spaces, commas, etc

f6d54c7464d62519f55a9f09aaccf7505879cbf3 authored over 9 years ago by Alexander Mohorev <[email protected]>

Undefined class Expression

98fd243459af5092d84097ce4e2cb6bac7d2c931 authored over 9 years ago by Alexander Mohorev <[email protected]>

#8573 fix

3ea4de64875e134ed2e793ce98ba80d22e981f45 authored over 9 years ago by prog5 <[email protected]>

added missing use statement to fix #8572

- added unit tests for timestamp behavior and insert with expression
- fixed issue #8572

close ...

08e2d74607ee00160fc9c5d9db23e164f519c107 authored over 9 years ago by Carsten Brandt <[email protected]>

Merge branch 'master' into 7374-inserting-ar-without-values

f233ccd961bc43e675ce733a373e821fb5dffc58 authored over 9 years ago by John Was <[email protected]>

Update Schema.php

insert: added $columnSchemas initialization; added size parameter to pdoStatement->bindParam

2e7077c6b2f85400e3a270909ae7ab65cf76ada0 authored over 9 years ago by vbelogai <[email protected]>

added missing `@since` annotations

d83f13a31e9712dc9545a312e39a02e63e32c859 authored over 9 years ago by Carsten Brandt <[email protected]>

Merge branch 'master' into 7374-inserting-ar-without-values

b4e54a7064f353d11a93ff97f99ee9b6eaeb97f2 authored over 9 years ago by Jan Was <[email protected]>

Redundant checks at `yii\db\oci\Schema::insert()` and `yii\db\pgsql\Schema::insert()` removed

c9b6a717df800ca0ad9673b38ff0c084cc5a53ec authored over 9 years ago by Klimov Paul <[email protected]>

Command execution at `yii\db\oci\Schema::insert()` fixed

346758df0708051eef2e5357ca50410c39840ad6 authored over 9 years ago by Paul Klimov <[email protected]>

Use RETURNING for inserts for pgsql and oci to support PKs with a custom default value expression

cf57d3b1a3691ee6f6a2f5d98263e4485313f300 authored over 9 years ago by Paul Klimov <[email protected]>

fix typos

93b35d4c55c4feb4f44842f0d3ac2fa6f97bc0cb authored over 9 years ago by John Was <[email protected]>

add missing space

039229ba4d95bc35d931d3dd3e4fe64b784d0b9e authored over 9 years ago by Jan Waś <[email protected]>

allow calling Command::insert() without any columns

8ae2d452f36a169c90a077224740869e72785a9a authored over 9 years ago by Jan Waś <[email protected]>

Fixes #7973: Added `Schema::getSchemaNames` method

98c953c72fc2149cdbce43fa4e682520f1c16aa4 authored over 9 years ago by John Was <[email protected]>

fix oci\Schema::findConstraints() and pgsql\Schema::findTableNames(); added missing view to oci tests

fc067a40d29d1dfc10032e26320b7bab0b3e79de authored over 9 years ago by John Was <[email protected]>

Fixes #7831: Add order when fetching database table names and constraints

9de9df846d3e19abbc1980c87fcc024cd447a565 authored over 9 years ago by John Was <[email protected]>

Fixes #7833: Support (materialized) views and foreign tables along normal tables when fetching table schema

d9e0d89cbcf3a4bf6bde5592821a8244a7cf3370 authored over 9 years ago by John Was <[email protected]>

Fixes #7867: Fixes findUniqueIndexes not to perform any processing on unique index on function for pgsql, Implemented findUniqueIndexes for oci and mssql

590432f4dc80b2e9b1fc4a99b4365cdd6072fb8e authored over 9 years ago by Jan Was <[email protected]>

fixes #7757: in oci schema fix query results row keys case when PDO::ATTR_CASE is set to PDO::CASE_LOWER

added test to check support for setting PDO::ATTR_CASE and fetching table schemas
fixed fetching ...

3b8db24c1d1f7e1c52b5312cb7a7f2fb5cbe884f authored over 9 years ago by John Was <[email protected]>

Added Schema::DOUBLE to represent ANSI SQL Double Precision

42f48b20584b1f7e3526e756c5e9d8706e4201c0 authored over 9 years ago by Alexander Makarov <[email protected]>

Fixes #6080: Oracle DB schema did not load column types correctly

8c5c2be432190fd92892609d24ed9045baa5086d authored almost 10 years ago by wenbin1989 <[email protected]>

Fixes #6049: `yii\db\Connection::getSchema()` for Oracle should return false when the table does not exist. Oracle does not support `ON UPDATE` clause.

d7820e179f4ff36b4488c2e881a3f79da4d913f7 authored almost 10 years ago by Qiang Xue <[email protected]>

fix oci bugs: \yii\db\oci\Schema::findColumns($table) return true when table doesn't exist When table doesn't exist, query in method `findColumns` return empty array instead of throw a exception.

e1065f11a3434540e5e82faae28dcfca8785869b authored almost 10 years ago by wenbin1989 <[email protected]>

oracle db doesn't support `ON UPDATE` in FOREIGN KEY. remove `ON UPDATE` section in method `addForeignKey`.

3bdd9d6c3b021db170d1704540ceaee53022a8c5 authored almost 10 years ago by wenbin1989 <[email protected]>

Fix batchInsert bug in oci. default batchInsert sql is ``` insert into tableName(col1, col2, col3...) value(`col11`, `col12`,`col13`.... ),(`col21`, `col22`,`col23`.... ); ``` which is illegal in oracle db. Change it to ``` insert into tableName(col1, col2, col3...) select 'col11', 'col12', 'col13' from dual union select 'col21', 'col22', 'col23' from dual union select 'col31', 'col32', 'col33' from dual; ```

5fadea8cffada74e7518f4dfda97ee0b882a0ebf authored almost 10 years ago by wenbin1989 <[email protected]>

Fixes #4254: `SqlDataProvider` does not work with Oracle and SQL Server

e6b6175ee081c0443a4502d107360b2cc16db921 authored about 10 years ago by Qiang Xue <[email protected]>

Fixes #4644: Added `\yii\db\Schema::createColumnSchema()` to be able to customize column schema used

ac42a8664e42c4c07410cf8a218ac363c4d5c307 authored about 10 years ago by mcd.php <[email protected]>

property codestyle framework

f1934628b13b8c584bc699f12857a8856694ebb0 authored about 10 years ago by Carsten Brandt <[email protected]>

phpdoc

9cfab4210a04ada235061639e732031af5dc0581 authored about 10 years ago by Carsten Brandt <[email protected]>

Fixed missing and incorrect phpdoc

1f22b5cfcc98f2e25b3e4629772b21e9ec47c8b4 authored about 10 years ago by Alexander Makarov <[email protected]>

Fixed Oracle DB type mapping. (Fixes #4)

eb5fc3b9b9d9ee57f60625ca560d8d915ad1a3ab authored about 10 years ago by Qiang Xue <[email protected]>

Added Connection::useMaster() and refactored code.

dd4a6c973491b9eb62520c2fce6ed55c6b7afabd authored over 10 years ago by Qiang Xue <[email protected]>

WIP

aa95e7d485e09da754c3a2dd97e2db508a5ea91c authored over 10 years ago by Qiang Xue <[email protected]>

proper quoting of sequence name.

b64427a8fd1950ec3491ed27dfbcef6a22e71c09 authored over 10 years ago by Qiang Xue <[email protected]>

minor CS fixes [skip ci]

8061a40f62ef544c97f0647c96463c34171de1c0 authored over 10 years ago by Qiang Xue <[email protected]>

fix unnecessary diff

0aa24211165c2c4c768542ad9e82aed75eec6126 authored over 10 years ago by miramir <[email protected]>

Retriev quoteSimpleTableName

589103489867418ba7f95d0502201dac7a91791b authored over 10 years ago by Иван Багаев <[email protected]>

Removing unnecessary methods

0e38c5e200861715048d138757e64ac94058919f authored over 10 years ago by miramir <[email protected]>

Remove test for asterisk in quoteSimpleTableName

c07d21794a2cdefe8d4608b5e9e1e5c30caf7e25 authored over 10 years ago by Иван Багаев <[email protected]>

Asterisk in Oracle not need quote

If quote asterisk oracle say "Syntax error"

0fad1c3f314da868e21014e7a1ed4d3b2172fb09 authored over 10 years ago by Иван Багаев <[email protected]>

Merge pull request #4063 from yiisoft/typecast-split

split typecast method into two

f3bcd7db04d8d8dfecdcee542368f9b0ab215820 authored over 10 years ago by Carsten Brandt <[email protected]>

rename ColumnSchema::typecast to phpTypecast

6f66781c36ddefc7152c865c71750f8d588aa8da authored over 10 years ago by Carsten Brandt <[email protected]>

OCI/Schema getlastinsertedid function fix and i add const oracle column type to schema

a338d723c0463dd069d26a64c3883c056c24c04c authored over 10 years ago by Tóth Sándor <[email protected]>

rename column schema typecast method

8ef60137dfc7374bffc2c9aa1f87b2f913626324 authored over 10 years ago by Carsten Brandt <[email protected]>

split typecast method into two

one method for fetching data and one for sending to db.

fixes #2287

0635f47647e80ff703817171db82407f868a84f8 authored over 10 years ago by Carsten Brandt <[email protected]>

OCI createColumn fix

7bebabf8c23abc7e2bef96ecca4a95f04aaa8c63 authored over 10 years ago by Tóth Sándor <[email protected]>

removed `@link` tags from apidoc and replaced with markdown

1c082752d6744ada40c9b6adff6a6593e13214d2 authored over 10 years ago by Carsten Brandt <[email protected]>

Fixes #3564: Fixed the bug that primary key columns should not take default values from schema

0a43cc50378c1494e69f081ef18988a1e72bbfb7 authored over 10 years ago by Qiang Xue <[email protected]>

code style, fixes #3140

af9501c3ca1b7d114a026404e27c4782dd3799d6 authored over 10 years ago by Carsten Brandt <[email protected]>

fixed broken API links [skip ci]

d5625308305a72c68bf996931f80bcdb76140207 authored over 10 years ago by Qiang Xue <[email protected]>

Implemented Oracle column comment reading from another schema

baed7f0b6c365e5d3c6f03fd1cc2de3a9118234a authored over 10 years ago by Alexander Makarov <[email protected]>

Fixed oci querybuilder.

8e251ab4ad5da5bd602cba69fd9e55aa4ddde528 authored over 10 years ago by Qiang Xue <[email protected]>

Fixes #2880

6ac815d35a1ab39558b1bcc9d67ff93e50ffd897 authored over 10 years ago by Qiang Xue <[email protected]>

Fixed activequery select issue.

e1e6c0707aa0191657b965aaf3a0aaa344176cea authored over 10 years ago by Qiang Xue <[email protected]>

reverted breaking PHPdoc codestyle changes

issue #2852

82a6bad4ade59bd6a11b99f3e5550739806fae52 authored over 10 years ago by Carsten Brandt <[email protected]>

Fixes #2848: Individual queries should be enclosed within parenthesis in a UNION query

020bc5422f5c58fe7d3a43d3186a44311adce30a authored over 10 years ago by Qiang Xue <[email protected]>

Fixes #2826

8f6469f37d7e9fe80e1c9d808618b71dd968c7e5 authored over 10 years ago by Qiang Xue <[email protected]>

Reformat code te be PSR-2 compatible

294d3f8bad44f72250bf8fe49a7a857ca4ba8b7a authored over 10 years ago by SonicGD <[email protected]>

Changed "and" to "&&"

f3b3f095833cfebe370981d65fffafc93b4ee943 authored over 10 years ago by Alexander Makarov <[email protected]>

fixed phpdoc errors and updated properties

da8b34fb195bab255d001ab99c2c3e0acdf97553 authored over 10 years ago by Carsten Brandt <[email protected]>

Fixes #1645: Added support for nested DB transactions

e308ccaefb7cbe70707ece55ae627a12252048c8 authored over 10 years ago by Qiang Xue <[email protected]>

Added support for building SQLs with sub-queries

76ef0e0478a07ed5dc51a1eccc5324c88bbf4325 authored over 10 years ago by Qiang Xue <[email protected]>

Fixes #2160: SphinxQL does not support OFFSET

Improved `QueryBuilder::buildLimit()` to support big numbers

2764a045d2c5eaa7ba8a138a4e5a584ae4c1df0e authored over 10 years ago by Qiang Xue <[email protected]>

more union fix.

052de8ffcf82cdab1b1c11394ff5e1e66528b12f authored over 10 years ago by Qiang Xue <[email protected]>

Added `TableSchema::fullName` property

36cefc4ce0aedf77022b015a8f7f1c459568499b authored almost 11 years ago by Qiang Xue <[email protected]>

Removed debug code

6f8164b6cb27bbfbd705ffe74379c0bac8e11a40 authored almost 11 years ago by Alexander Makarov <[email protected]>

psr-4 move

fa8d4d192c649e45f169246cb3fd8c8bb92412f8 authored almost 11 years ago by Qiang Xue <[email protected]>