83 Commits

Author SHA1 Message Date
104712103b Fixes #11693: Handle QueryBuilder::batchInsert() calls with no data to insert. (#11812) 2016-06-25 15:51:09 +03:00
7cea46bcb4 Changed SQLite fix #11652 according to https://github.com/yiisoft/yii2/pull/11653#issuecomment-224016289 2016-06-06 19:57:42 +03:00
0a60466729 Fixes #11527: Fixed bigPrimaryKey() for SQLite 2016-06-06 19:33:22 +03:00
9d327baa8b coding style fixes 2016-05-26 11:19:32 +02:00
27866bf9d6 Changed name to append(), fixed phpdoc, added changelog 2016-05-13 15:58:06 +03:00
66eabda770 Fixes #11195: Added ability to append custom string to schema builder column definition 2016-05-13 15:57:54 +03:00
731769241b release version 2.0.8 2016-04-28 16:50:20 +02:00
edd6e719bb added missing since annotations and removed duplicate line 2016-04-28 03:02:17 +02:00
15432971d6 db/ColumnSchemaBuilder::buildCommentString() returns empty string by default 2016-04-20 09:26:07 +03:00
1aa2f1d927 Removed sqlite/ColumnSchemaBuilder::comment() method override 2016-04-19 18:29:12 +03:00
0fe27b9d3b Refactored code in PR #9441 2016-04-19 17:48:25 +03:00
c9dfc90be0 Merge branch 'methods_for_schema_builder' of https://github.com/vaseninm/yii2 into vaseninm-methods_for_schema_builder 2016-04-19 12:21:33 +03:00
e8c3f6cc6f Fixing tests 2016-03-21 04:43:59 -07:00
5c4001d84b Schema Builder Patterns Excel document in /docs folder (temp storage).
Fixed some schema builder patterns.
Added more information to upgrade docs.
2016-03-14 05:29:42 -07:00
2f91889b70 Removed unsignedPrimaryKey() schema builder type; now, the unsigned() modifier works with primary key types e.g. pk()->unsigned() or bigpk()->unsigned(). 2016-02-26 17:48:03 -08:00
f3cf4af4de Merge branch 'master' of git://github.com/yiisoft/yii2 into 9562-add-char-datatype
# Conflicts:
#	framework/db/sqlite/QueryBuilder.php
2016-02-26 00:14:29 -08:00
af75262541 fixed sqlite bigPk creation 2016-02-25 19:10:23 +01:00
81ff4752d9 Added CHECK modifier to PK schema pattern. Modified UNSIGNED tests to not include modifier by default (i.e. only present when testing DBMSes that support it). 2016-02-22 04:06:17 -08:00
f52f60db0f Renamed category constants 2016-02-21 02:06:41 -08:00
51b99320bd Sqlite specific schema builder class actually gets loaded now 2016-02-20 06:53:31 -08:00
8c0b075bed Merge branch '9340-add-after-method-to-migrations-schema-builder' into 9562-add-char-datatype 2016-02-20 01:59:00 -08:00
eaeb926768 Adds char datatype to framework 2016-02-20 01:52:23 -08:00
0400eb9cee Resolved merge conflict in changelog 2016-02-18 02:34:02 -08: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
457002c216 Sqlite specific schema builder class actually gets loaded now 2015-12-29 16:24:24 -08:00
bce61bd474 Add after() option to migrations schema builder 2015-12-28 06:34:46 -08: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
afda00d434 add sqllite dummy 2015-08-17 14:44:53 +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