umbrellio / laravel-pg-extensions
100%
master: 100%

LAST BUILD BRANCH: feature/triggers
DEFAULT BRANCH: master
Repo Added
Files 86
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

LAST BUILD ON BRANCH 2.6.0
branch: 2.6.0
CHANGE BRANCH
x

312

push

travis-ci

lazeevv 
Added support creating EXCLUDE/CHECK constraints (#23)

EXCLUDE constraints
https://www.postgresql.org/docs/9.0/sql-createtable.html#SQL-CREATETABLE-EXCLUDE

Using the example below:

Schema::create('table', function (Blueprint $table) {
    $table->integer('type_id'); 
    $table->date('date_start'); 
    $table->date('date_end'); 
    $table->softDeletes();
    $table
        ->exclude(['date_start', 'date_end'])
        ->using('type_id', '=')
        ->using('daterange(date_start, date_end)', '&&')
        ->method('gist')
        ->with('some_arg', 1)
        ->with('any_arg', 'some_value')
        ->whereNull('deleted_at');
});
An Exclude Constraint will be generated for your table:

ALTER TABLE test_table
    ADD CONSTRAINT test_table_date_start_date_end_excl
        EXCLUDE USING gist (type_id WITH =, daterange(date_start, date_end) WITH &&)
        WITH (some_arg = 1, any_arg = 'some_value')
        WHERE ("deleted_at" is null)
CHECK constraints
https://www.postgresql.org/docs/9.4/ddl-constraints.html#DDL-CONSTRAINTS-CHECK-CONSTRAINTS

Using the example below:

Schema::create('table', function (Blueprint $table) {
    $table->integer('type_id'); 
    $table->date('date_start'); 
    $table->date('date_end'); 
    $table
        ->check(['date_start', 'date_end'])
        ->whereColumn('date_end', '>', 'date_end')
        ->whereIn('type_id', [1, 2, 3]);
});
An Check Constraint will be generated for your table:

ALTER TABLE test_table
    ADD CONSTRAINT test_table_date_start_date_end_chk
        CHECK ("date_end" > "date_start" AND "type_id" IN [1, 2, 3])

74 of 74 new or added lines in 8 files covered. (100.0%)

307 of 307 relevant lines covered (100.0%)

36.95 hits per line

Relevant lines Covered
307 RELEVANT LINES 307 COVERED LINES
36.95 HITS PER LINE
Source Files on 2.6.0

Recent builds

Builds Branch Commit Type Ran Committer Via Coverage
312 2.6.0 Added support creating EXCLUDE/CHECK constraints (#23) EXCLUDE constraints https://www.postgresql.org/docs/9.0/sql-createtable.html#SQL-CREATETABLE-EXCLUDE Using the example below: Schema::create('table', function (Blueprint $table) { ... push lazeevv travis-ci pending completion  
See All Builds (408)