52 Commits

Author SHA1 Message Date
387d5aa083 Merge branch '8573-oci-schema-number-mapping' of https://github.com/vbelogai/yii2 into vbelogai-8573-oci-schema-number-mapping 2016-01-17 13:29:04 +02:00
cd87d67f34 Global DOCS update: ~~~ replaced with ``` 2015-12-02 23:15:28 +02:00
1b3770fd21 Use === instead of == where possible 2015-10-10 01:04:35 +03:00
5ab4f0f090 Better quotes usage in strings
- Use single quote where interpolation isn't necessary
- Use interpolation when it's better than concatenation
2015-10-10 00:23:52 +03:00
c2f83da8d8 Fix phpdoc 2015-10-05 15:00:13 +06:00
34d5b45b35 proper fix for #8844, convert array before using it
fixes #9415
2015-08-14 12:26:36 +02:00
681db52ba6 refactored SchemaBuilder
- rename class to ColumnSchemaBuilder as this is more appropriate
- changed internal organisation to match how the rest of schema related classes work
  - the ColumnSchemaBuilder is now created the same way as QueryBuilder is
- removed static call magic and method annotations, now real methods are called as they are
- the whole code works on objects in a db context now instead of setting database connection in global state
- trait is now used by Migration by default but can be used in other contexts as well

Migration usage is now as follows:

```php
$this->createTable('example_table', [
  'id' => $this->primaryKey(),
  'name' => $this->string(64)->notNull(),
  'type' => $this->integer()->notNull()->defaultValue(10),
  'description' => $this->text(),
  'rule_name' => $this->string(64),
  'data' => $this->text(),
  'created_at' => $this->datetime()->notNull(),
  'updated_at' => $this->datetime(),
]);
```
2015-08-03 23:25:50 +02:00
6d9fe671de various code style and whitespace adjustments 2015-08-02 00:27:19 +02:00
b8fefe513c 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

close #8844
2015-07-26 02:08:47 +02:00
ae42a054bb PSR-2 spaces, commas, etc 2015-06-09 00:05:06 +03:00
2134c72bb0 Undefined class Expression 2015-06-08 16:10:41 +03:00
1f8aafd36b #8573 fix 2015-06-03 17:57:47 +03:00
672510d521 Update Schema.php
insert: added $columnSchemas initialization; added size parameter to pdoStatement->bindParam
2015-04-28 15:46:10 +03:00
ef662b57be added missing @since annotations 2015-04-24 12:09:40 +02:00
60aa5f3eb9 Redundant checks at yii\db\oci\Schema::insert() and yii\db\pgsql\Schema::insert() removed 2015-04-14 11:59:58 +03:00
31ef4c4504 Command execution at yii\db\oci\Schema::insert() fixed 2015-04-13 17:49:14 +03:00
4e8ee7b001 Use RETURNING for inserts for pgsql and oci to support PKs with a custom default value expression 2015-04-13 17:11:00 +03:00
901d640b55 Fixes #7973: Added Schema::getSchemaNames method 2015-04-03 01:03:49 +03:00
664958548f fix oci\Schema::findConstraints() and pgsql\Schema::findTableNames(); added missing view to oci tests 2015-03-30 23:51:53 +02:00
4d1ca9ff17 Fixes #7831: Add order when fetching database table names and constraints 2015-03-30 22:18:56 +03:00
29304a185a Fixes #7833: Support (materialized) views and foreign tables along normal tables when fetching table schema 2015-03-30 19:01:12 +03:00
48255a446d Fixes #7867: Fixes findUniqueIndexes not to perform any processing on unique index on function for pgsql, Implemented findUniqueIndexes for oci and mssql 2015-03-30 18:01:30 +03:00
4f49feee8d 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 table schemas for mysql when PDO::ATTR_CASE is set
added tests for oci
fixed fetching composite fks for oci
improvements in oci schema parsing
removed autoIncrement detection fro oci and added test to verify that
implement batchInsert for oci
fix detecting IntegrityException for oci
fixed creating raw sql by skipping object and resource params
fix command test failing for sqlite
2015-03-29 21:57:13 +02:00
2202ae6cb8 Fixes #6080: Oracle DB schema did not load column types correctly 2014-12-16 23:21:11 -05:00
b733a18904 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. 2014-11-15 08:32:47 -05:00
20774165bc Fixes #4644: Added \yii\db\Schema::createColumnSchema() to be able to customize column schema used 2014-08-12 00:01:27 +04:00
1f31f27787 phpdoc 2014-07-29 22:19:14 +02:00
0edd8bc65a Fixed missing and incorrect phpdoc 2014-07-25 17:26:35 +04:00
1f0d2ab7d9 Fixed Oracle DB type mapping. (Fixes #4) 2014-07-24 20:51:58 -04:00
91e0c5ae8a Added Connection::useMaster() and refactored code. 2014-07-11 21:04:26 -04:00
e67d0b3c39 WIP 2014-07-11 14:01:44 -04:00
ff50f15056 proper quoting of sequence name. 2014-07-10 14:06:47 -04:00
b147e6516d minor CS fixes [skip ci] 2014-07-10 11:59:27 -04:00
0322e427e7 fix unnecessary diff 2014-07-07 21:24:21 +06:00
93c567e7e1 Retriev quoteSimpleTableName 2014-07-07 20:54:31 +06:00
9c55cc48f8 Removing unnecessary methods 2014-07-07 11:38:05 +06:00
b96e45faf7 Remove test for asterisk in quoteSimpleTableName 2014-07-05 22:07:46 +06:00
d06685ff88 Asterisk in Oracle not need quote
If quote asterisk oracle say "Syntax error"
2014-07-05 12:28:54 +06:00
27943ce735 Merge pull request #4063 from yiisoft/typecast-split
split typecast method into two
2014-06-27 02:14:31 +02:00
5d0452b2ae rename ColumnSchema::typecast to phpTypecast 2014-06-27 02:12:59 +02:00
332f2a07ee OCI/Schema getlastinsertedid function fix and i add const oracle column type to schema 2014-06-26 15:49:47 +02:00
8a70d9fbd1 rename column schema typecast method 2014-06-26 00:11:04 +02:00
6a48f68955 split typecast method into two
one method for fetching data and one for sending to db.

fixes #2287
2014-06-26 00:00:37 +02:00
3f27a4b74f OCI createColumn fix 2014-06-23 14:59:56 +02:00
f5dbd9a084 Fixes #3564: Fixed the bug that primary key columns should not take default values from schema 2014-05-23 10:35:20 -04:00
cb4488ae4c Implemented Oracle column comment reading from another schema 2014-03-30 19:41:47 +04:00
bf3c75147d reverted breaking PHPdoc codestyle changes
issue #2852
2014-03-23 20:51:09 +01:00
b5f8a4dc22 Reformat code te be PSR-2 compatible 2014-03-16 10:46:21 +06:00
12d4615039 Changed "and" to "&&" 2014-03-04 22:28:52 +04:00
bea9e3fc06 Fixes #1645: Added support for nested DB transactions 2014-02-15 22:16:09 -05:00