umbrellio / laravel-pg-extensions

100%

master: 100%

LAST BUILD ON BRANCH 2.1.0

branch: 2.1.0

CHANGE BRANCH

x

Reset

• 2.1.0
• master
• refactor-blueprint
• 2.0.0
• feature/views
• feature/unique-wheres
• feature/tsrange
• feature/default-expression
• feature/using
• feature/extensions-support
• feature/exclude-gist
• feature/has-index
• 2.2.0
• bug/fix-access
• 2.2.1
• bug/connections
• 2.2.2
• 2.2.3
• bug/postgres-connection
• 2.2.2.1
• 2.2.2.2
• 2.2.4
• 2.2.5
• 2.2.6
• doctrine/refactor
• test-travis
• add_numeric_column_type
• 2.3.0
• 2.4.0
• 2.5.0
• bugs/unique-constraints
• feature/exclude-constraint
• 2.5.1
• 2.6.0
• fix-traits-namespace
• 2.6.1
• 2.7.0
• feature/refactor-extensionable
• 3.0.0
• system/upgrade-dependencies
• 4.0.0
• add_ATTR_EMULATE_PREPARES_support
• 4.1.0
• feature/fix_get_pdo
• fix/pdo_field
• 4.1.1
• extensions/initialize
• 4.1.2
• 4.2.0
• laravel_8_support
• 4.3.0
• upgrade/php7.4
• feature/triggers
• types/tsrange
• 4.4.0
• bug/extension
• 4.4.1
• bug/connection
• build/migrate-github-actions
• 4.5.2
• build/workflow
• minor/badges
• fix/composer
• upgrade/php8
• build/release
• build/test-release
• bug/tsrange
• tests

Build # 94

Build Type

push

travis-ci

Committed by lazeevv

Commit Message

Feature/unique wheres (#5)

Extending creating unique indexes with conditions on where, example:

```
Schema::create('cities', static function (Blueprint $table) {
       ... 
       $table->uniquePartial(['name', 'author_id'])
            ->where('editor_id', 1)
            ->whereRaw('field1 = ? and field2 <= ?', ['field1', 'field2'])
            ->whereNotNull('deleted_at')
            ->whereBetween('author_id', [1, 2, 3]);
      ...
```
PS. If you will use $table->uniquePartial() without extend methods after call uniquePartial(), it works as $table->unique().

Run Details

76 of 76 new or added lines in 5 files covered. (100.0%)

126 of 126 relevant lines covered (100.0%)

7.38 hits per line