10065
68%

Ran 11 Oct 2019 05:12PM UTC

Jobs 4

Files 627

Run time 21min

Badge

Embed ▾

pending completion

Build # 10065

Build Type

push

travis-ci

Committed by

web-flow

Commit Message

Add row level security policy to join table (#2954)


#2849 

The table version_sourcefiles is a join table for the
sourcefile table and the workflowversion/tag tables.

If version is frozen, don't allow modifications --
no adding of additional source files, deletion nor modification
of existing ones.

Part of the ticket was to remove the application guards once database protection
was implemented, but I decided against that -- Hibernate throws a 500 exception
in that case. We would need to catch that exception and throw our own exception.
The problem is the exception is thrown after the return statement code in the
Java code for the resource endpoint -- the error happens because the @UnitOfWork
annotation causes Hibernate to attempt to commit the transaction. We would have
to remove the annotation, manually start the transaction and commit it. Which is
doable, but doesn't seem like it would offer much over the current application
guards.

Coverage Stats

14459 of 32867 relevant lines covered (43.99%)

1.72 hits per line

Jobs

ID	Job ID	Ran	Coverage
2	10065.2 (TESTING_PROFILE=unit-tests)	11 Oct 2019 05:12PM UTC	16.32	Travis Job 10065.2
3	10065.3 (TESTING_PROFILE=integration-tests)	11 Oct 2019 05:33PM UTC	59.01	Travis Job 10065.3
4	10065.4 (TESTING_PROFILE=tool-integration-tests)	11 Oct 2019 05:23PM UTC	31.85	Travis Job 10065.4
5	10065.5 (TESTING_PROFILE=workflow-integration-tests)	11 Oct 2019 05:32PM UTC	45.92	Travis Job 10065.5

Source Files on build 10065

Detailed source file information is not available for this build.

dockstore / dockstore / 10065
68%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10065

dockstore / dockstore / 10065 68%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10065

dockstore / dockstore / 10065
68%

README BADGES
x