58 Commits

Author SHA1 Message Date
af75262541 fixed sqlite bigPk creation 2016-02-25 19:10:23 +01:00
e43c41c9ea db layer phpdoc fixes 2016-02-07 16:33:26 +01:00
8680f0f1d8 BC way of merging expression params of orderBy and groupBy
this logic should be moved to the sub methods in 2.1
2016-01-28 17:01:16 +01:00
a4acd048bc Add @throws tags to PHPDocs. 2015-12-24 11:11:03 +00:00
cd87d67f34 Global DOCS update: ~~~ replaced with ``` 2015-12-02 23:15:28 +02:00
cddb036cf9 Fixes #9790: Fixed yii\db\sqlite\QueryBuilder to generate proper SQL for UNION 2015-11-11 21:05:57 +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
0f2a77ed36 Fixes #9442: Fixed yii\db\Migration::renameTable() caused fatal error when using SQLite driver 2015-08-18 11:52:48 +03: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
a2568d1ec8 updated some comments and @since annotations 2015-08-02 19:56:49 +02:00
3f7ffd6707 Improved SchemaBuilder docs, refactored code 2015-07-08 15:39:34 +03:00
b456f699cc Implemented SchemaBuilder 2015-07-08 15:38:21 +03:00
789cdfea86 PSR-2 switch statement 2015-06-08 23:28:44 +03:00
2288f339e6 Parameter type is not compatible with declaration 2015-06-08 16:07:27 +03:00
4d1ca9ff17 Fixes #7831: Add order when fetching database table names and constraints 2015-03-30 22:18:56 +03:00
5870a74672 Added Schema::DOUBLE to represent ANSI SQL Double Precision 2015-02-25 16:01:37 +03:00
1e5f159f78 override only mssql and sqlite QueryBuilder; throw an exception for composite in condition with a subquery 2015-01-31 22:20:41 -05:00
f177f1701a fixed failure on sqlite version check
ensure PDO instance has been created at this point
2015-01-10 22:06:43 +01:00
fff48ef76f Correct SQLite version checking 2015-01-06 01:27:01 +03:00
bb8550886e PHP type casting 2014-10-25 15:30:03 +03:00
25bf486b7f save some function calls on AR insert 2014-08-12 18:13:49 +02: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
3a1e0f3a5c property codestyle framework 2014-07-30 00:21:31 +02: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
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
574f67feff fixed test break 2014-06-26 01:35:56 +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
b04e23f8b7 use native suppport for batch insert in SQLite >= 3.7.11
fixes #3559
2014-06-25 21:18:36 +02:00
6578cfbdab updated phpdoc and classmap 2014-06-25 18:24:23 +02:00
4f95fcd91f added unit tests for schema detection
fixed some issues with schema detection
2014-06-25 03:09:28 +02:00
bbbe2a3e4b Added support for transaction isolation levels
fixes #3220
2014-06-23 19:47:56 +02:00
ce49416e32 Fixes #3752: QueryBuilder::batchInsert() does not typecast input values 2014-06-09 08:12:08 -04:00
5174ea6dfb SQLite support for disable integrity check
This is a porting from yii framework version 1.
I need it to run functional tests with fixtures.
2014-05-24 14:19:11 +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
91965fd391 phpdoc formatting issues 2014-04-23 02:55:17 +02:00
ab799d8ea9 Fixes #2911: Removed tbl_ default for table prefix 2014-03-30 19:33:46 +04:00
bf3c75147d reverted breaking PHPdoc codestyle changes
issue #2852
2014-03-23 20:51:09 +01:00
c24ae25be2 Fixed getting default values from schema for SQLite 2014-03-20 13:54:13 +04:00
b5f8a4dc22 Reformat code te be PSR-2 compatible 2014-03-16 10:46:21 +06:00
5a61ee91be Fixed test break. 2014-03-14 23:06:09 -04:00
9ff8b0f903 Fixes #2571: Fixed the bug that batchInsert will fail for SQLite if the values contain null or boolean false;
Fixes #2683: Fixed the bug that batchInsert will fail for MySQL if the values contain boolean false.
2014-03-14 22:48:20 -04:00
1af04e1e1b Fixes #2661: Added boolean column type support for SQLite 2014-03-07 22:38:30 -05:00
b21fd298c5 Fixed minor coding style issues 2014-02-01 01:18:38 +04:00
8e11629a65 Fixes #2160: SphinxQL does not support OFFSET
Improved `QueryBuilder::buildLimit()` to support big numbers
2014-01-29 22:42:56 -05:00
9b723baa76 Added TableSchema::fullName property 2014-01-16 15:51:14 -05:00
0c38655217 psr-4 move 2014-01-10 21:41:43 -05:00
0d814fa523 Moved "framework" to "iii". 2013-05-09 12:00:15 -04:00