566
92%

Ran 24 Oct 2016 10:33AM UTC

Jobs 1

Files 29

Run time 2s

Badge

Embed ▾

pending completion

Build # 566

Build Type

push

travis-ci

Committed by

vitorbaptista

Commit Message

Add uniqueness constraints to documents table

There are 3 cases for a document. It can be an FDA document, a document with a
file (with our without URL), and a document with a URL without a file. The
uniqueness constraints for them are:

1. FDA documents - [`fda_approval_id`, `file_id`, `name`]
2. Documents with files - [`type`, `file_id`]
3. Documents with URLs - [`type`, `url`]

In this order. I mean, if a document has an `fda_approval_id`, its the checked
uniqueness constraint must be `1`, and so on.

This is getting overly complicated, and might be a smell that we're trying to
cram different entities in the same table. We might extract them in the future.

Run Details

362 of 392 relevant lines covered (92.35%)

41.98 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	566.1	24 Oct 2016 10:33AM UTC	0	92.35	Travis Job 566.1

Source Files on build 566

Detailed source file information is not available for this build.

opentrials / api / 566
92%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 566

opentrials / api / 566 92%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 566

opentrials / api / 566
92%

README BADGES
x